10 free sample questions from a bank of 1251, with the correct answers and explanations. No signup required — start practising right now.
1Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:
Micro-partitions
Clustering keys
Key partitions
Clustered partitions
Answer: B
2Which statement best describes clustering?
Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
The database administrator must define the clustering methodology for each Snowflake table
The clustering key must be included on the COPY command when loading data into Snowflake
Clustering can be disabled within a Snowflake account
Answer: A
3What is the most granular object that the Time Travel retention period can be defined on?
Account
Database
Schema
Table
Answer: D
4Which task is supported by the use of Access History in Snowflake?
Data backups
Cost monitoring
Compliance auditing
Performance optimization
Answer: C
5Which feature of Snowflake’s Continuous Data Protection (CDP) has associated costs?
Fail-safe
Network policies
End-to-end encryption
Multi-Factor Authentication (MFA)
Answer: A
6When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?
File URL
Scoped URL
Relative URL
Pre-Signed URL
Answer: B
7Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Column compression
Data clustering
Micro-partitioning
Metadata management
Answer: D
8A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
CREATE TABLE [table_name] LIKE TABLE_A;
CREATE VIEW [view_name] AS SELECT * FROM TABLE_A;
CREATE TABLE [table_name] AS SELECT * FROM TABLE_A;
CREATE MATERIALIZED VIEW [view_name] AS SELECT * FROM TABLE_A;
Answer: A
9In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
READ
REFERENCES
REFERENCE_USAGE
USAGE
Answer: C
10Which function can be used with the COPY INTO [LOCATION] statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?