Snowflake
SOL-C01
Q1:
Which command is used to view the details of a file format object in Snowflake?
○
A
LIST FILE FORMAT○
B
ALTER FILE FORMAT○
C
DESCRIBE FILE FORMAT○
D
SHOW FILE FORMATS
Snowflake
SOL-C01
Q2:
How do databases, schemas, tables, and views interact in Snowflake's hierarchy? (Choose any 2 options)
☐
A
A view can contain multiple databases☐
B
Tables and views store data and provide virtual tables☐
C
A database contains schemas, which contain tables and views☐
D
Schemas manage network settings
Snowflake
SOL-C01
Q3:
What will be returned when a user runs this command?
SELECT count FROM my_table LIMIT 10;
○
A
A non-deterministic set of 10 values in the count column.○
B
The highest 10 values in the count column.○
C
All values in the count column that are less than or equal to 10.○
D
The lowest 10 values in the count column.
Snowflake
SOL-C01
Q4:
What are the key benefits of the Snowflake multi-cluster shared data architecture? (Select TWO).
☐
A
It provides enhanced data security features.☐
B
It optimizes data loading for unstructured data.☐
C
It allows for independent scaling of compute and storage.☐
D
It stores data in a columnar format to improve performance.☐
E
It offers near-unlimited concurrency and elasticity.
Snowflake
SOL-C01
Q5:
Which cloud platforms does Snowflake support?
○
A
Amazon Web Services (AWS)○
B
Google Cloud Platform (GCP)○
C
Microsoft Azure○
D
All of the options