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
Which Snowflake layer is associated with virtual warehouses?
A. Cloud services
B. Query processing
C. Elastic memory
D. Database storage
Q
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
A. GROUP BY
B. LIMIT
C. ORDER BY
D. PARTITION BY
E. UNION ALL
Q
What information does the Query Profile provide?
A. Graphical representation of the data model
B. Statistics for each component of the processing plan
C. Detailed Information about I he database schema
D. Real-time monitoring of the database operations
Q
Which common query problems are identified by the Query Profile? (Select TWO.)
A. Syntax error
B. Inefficient pruning
C. Ambiguous column names
D. Queries too large to fit in memory
E. Object does not exist or not authorized
Q
For Directory tables, what stage allows for automatic refreshing of metadata?
A. User stage
B. Table stage
C. Named internal stage
D. Named external stage
Q
What are characteristic of Snowsight worksheet? (Select TWO.)
A. Worksheets can be grouped under folder, and a folder of folders.
B. Each worksheet is a unique Snowflake session.
C. Users are limited to running only one on a worksheet.
D. The Snowflake session ends when a user switches worksheets.
E. Users can import worksheets and share them with other users.
Q
Which privilege is needed for a SnowFlake user to see the definition of a secure view?
A. OWNERSHIP
B. MODIFY
C. CREATE
D. USAGE
…………….