To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.
The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Some new questions:
Q
When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?
A. SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);
B. SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);
C. SELECT * FROM MY_TABLE SAMPLE (5 ROWS);
D. SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);
Q
Which type of Snowflake virtual warehouse provides 16 times the memory for each node and is recommended for larger workloads like Machine Learning (ML) training?
A. A size 6XL warehouse
B. A standard warehouse
C. A multi-cluster warehouse
D. A Snowpark-optimized warehouse
Q
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
A. GET
B. CREATE STAGE
C. PUT
D. COPY INTO
E. CREATE PIPE
Q
A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two variant columns? (Select TWO).
A. RECORD_TIMESTAMP
B. RECORD_CONTENT
C. RECORDKEY
D. RECORD_SESSION
E. RECORD_METADATA
………..
Some new questions:
Q
Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?
A. Free listing
B. Paid listing
C. Direct share
D. Data Exchange
Q
What kind of authentication do Snowpipe REST endpoints use?
A. OAuth
B. Key-based
C. Username and password
D. Single Sign-On (SSO)
Q
What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).
A. INSERT
B. UPDATE
C. DELETE
D. TRUNCATE
E. UPSERT
Q
What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?
A. The stage definition
B. The table definition
C. The use of a copy into
D. The use of a copy INTO
Q
Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?
A. Snowsight
B. SnowCD
C. Snowpark
D. SnowSQL
………….