SnowPro Core Questions + Answers

Post by **answerhappygod** » Wed Apr 13, 2022 7:06 am

Question 1 ( Topic 1 )
Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:
A. Micro-partitions
B. Clustering keys
C. Key partitions
D. Clustered partitions

Answer : B

Reference:
https://community.snowflake.com/s/artic ... he-Cluster
Question 2 ( Topic 1 )
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
A. Custom
B. Economy
C. Optimized
D. Standard

Answer : BD

Reference:
https://community.snowflake.com/s/artic ... erformance
Question 3 ( Topic 1 )
True or False: A single database can exist in more than one Snowflake account.
A. True
B. False

Answer : B

Reference:
https://docs.snowflake.com/en/sql-refer ... abase.html
Question 4 ( Topic 1 )
Which of the following roles is recommended to be used to create and manage users and roles?
A. SYSADMIN
B. SECURITYADMIN
C. PUBLIC
D. ACCOUNTADMIN

Answer : D

Reference:
https://docs.snowflake.com/en/user-guid ... tions.html
Question 5 ( Topic 1 )
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
A. True
B. False

Answer : B

Reference:
https://docs.snowflake.com/en/user-guid ... nload.html

Question 6 ( Topic 1 )
Select the different types of Internal Stages: (Choose three.)
A. Named Stage
B. User Stage
C. Table Stage
D. Schema Stage

Answer : ABC

Reference:
https://dwgeek.com/type-of-snowflake-st ... amed-Stage
Question 7 ( Topic 1 )
True or False: A customer using SnowSQL / native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.
A. True
B. False

Answer : B

Reference:
https://docs.snowflake.com/en/user-guid ... cting.html
Question 8 ( Topic 1 )
Account-level storage usage can be monitored via:
A. The Snowflake Web Interface (UI) in the Databases section
B. The Snowflake Web Interface (UI) in the Account -> Billing & Usage section
C. The Information Schema -> ACCOUNT_USAGE_HISTORY View
D. The Account Usage Schema -> ACCOUNT_USAGE_METRICS View

Answer : B

Reference:
https://docs.snowflake.com/en/user-guid ... lling.html
Question 9 ( Topic 1 )
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
A. Number of users
B. Warehouse size
C. Amount of data processed
D. # of clusters for the Warehouse

Answer : BC

Question 10 ( Topic 1 )
Which statement best describes ג€clusteringג€?
A. Clustering represents the way data is grouped together and stored within Snowflakeג€™s micro-partitions
B. The database administrator must define the clustering methodology for each Snowflake table
C. The clustering key must be included on the COPY command when loading data into Snowflake
D. Clustering can be disabled within a Snowflake account

Answer : A

Reference:
https://docs.snowflake.com/en/user-guid ... tions.html

Question 11 ( Topic 1 )
True or False: The COPY command must specify a File Format in order to execute.
A. True
B. False

Answer : A

Reference:
https://interworks.com/blog/hcalder/201 ... snowflake/
Question 12 ( Topic 1 )
Which of the following commands sets the Virtual Warehouse for a session?
A. COPY WAREHOUSE FROM <<config file>>;
B. SET WAREHOUSE = <<warehouse name>>;
C. USE WAREHOUSE <<warehouse name>>;
D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Answer : C

Reference:
https://docs.snowflake.com/en/user-guid ... tasks.html
Question 13 ( Topic 1 )
Which of the following objects can be cloned? (Choose four.)
A. Tables
B. Named File Formats
C. Schemas
D. Shares
E. Databases
F. Users

Answer : ACEF

Question 14 ( Topic 1 )
Which object allows you to limit the number of credits consumed within a Snowflake account?
A. Account Usage Tracking
B. Resource Monitor
C. Warehouse Limit Parameter
D. Credit Consumption Tracker

Answer : B

Reference:
https://docs.snowflake.com/en/user-guid ... itors.html
Question 15 ( Topic 1 )
Snowflake is designed for which type of workloads? (Choose two.)
A. OLAP (Analytics) workloads
B. OLTP (Transactional) workloads
C. Concurrent workloads
D. On-premise workloads

Answer : AB

Reference:
https://blog.couchbase.com/its-the-workload-stupid/

Question 16 ( Topic 1 )
What are the three layers that make up Snowflakeג€™s architecture? (Choose three.)
A. Compute
B. Tri-Secret Secure
C. Storage
D. Cloud Services

Answer : ACD

Reference:
https://docs.snowflake.com/en/user-guid ... cepts.html
Question 17 ( Topic 1 )
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
A. To accommodate more queries
B. To accommodate more users
C. To accommodate fluctuations in workload
D. To accommodate a more complex workload

Answer : A

Reference:
https://docs.snowflake.com/en/user-guid ... tions.html
Question 18 ( Topic 1 )
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
A. True
B. False

Answer : B

Reference:
https://interworks.com/blog/bdu/2020/02 ... a-sharing/
Question 19 ( Topic 1 )
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)
A. JDBC
B. SnowSQL
C. Snowflake Web Interface (UI)
D. ODBC
E. Python

Answer : ABCDE

Reference:
https://docs.snowflake.com/en/user-guid ... y-mfa.html
Question 20 ( Topic 1 )
True or False: Snowflake charges a premium for storing semi-structured data.
A. True
B. False

Answer : B

Reference:
https://snowflakecommunity.force.com/s/ ... tured-data

Question 21 ( Topic 1 )
Which of the following statements describes a benefit of Snowflakeג€™s separation of compute and storage? (Choose all that apply.)
A. Growth of storage and compute are tightly coupled together
B. Storage expands without the requirement to add more compute
C. Compute can be scaled up or down without the requirement to add more storage
D. Multiple compute clusters can access stored data without contention

Answer : A

Reference:
https://towardsdatascience.com/why-you- ... d-compute-
65d2dffd450f
Question 22 ( Topic 1 )
True or False: It is possible to unload structured data to semi-structured formats such as JSON and Parquet.
A. True
B. False

Answer : A

Reference:
https://docs.snowflake.com/en/user-guid ... epare.html
Question 23 ( Topic 1 )
In which layer of its architecture does Snowflake store its metadata statistics?
A. Storage Layer
B. Compute Layer
C. Database Layer
D. Cloud Services Layer

Answer : D

Reference:
https://hevodata.com/blog/snowflake-arc ... warehouse/
Question 24 ( Topic 1 )
True or False: Data in fail-safe can be deleted by a user or the Snowflake team before it expires.
A. True
B. False

Answer : B

Reference:
https://blog.knoldus.com/ksnow-time-tra ... snowflake/
Question 25 ( Topic 1 )
True or False: Snowflakeג€™s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
A. True
B. False

Answer : B

Reference:
https://docs.snowflake.com/en/user-guid ... cepts.html