SnowPro-Core Exam - SnowPro Core Certification Exam

NEW QUESTION 1

What are value types that a VARIANT column can store? (Select TWO)

• A. STRUCT
• B. OBJECT
• C. BINARY
• D. ARRAY
• E. CLOB

Answer: BD

Explanation:
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics

NEW QUESTION 2

True or False: You can resize a Virtual Warehouse while queries are running.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

NEW QUESTION 3

When creating a user it is advisable sable to:
Choose 2 answers

• A. Set the user to be initially disabled
• B. Force an immediate password change
• C. Set a default role for the user
• D. Set the number of minutes to unlock to 15 minutes
• E. Set the users access to expire within a specified timeframe

Answer: BC

NEW QUESTION 4

Where can a user find and review the failed logins of a specific user for the past 30 days?

• A. The USERS view in ACCOUNT_USAGE
• B. The LOGIN_HISTORY view in ACCOUNT_USAGE
• C. The ACCESS_HISTORY view in ACCOUNT_USAGE
• D. The SESSIONS view in ACCOUNT_USAGE

Answer: B

NEW QUESTION 5

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

• A. Database replication and failover
• B. Automated index management
• C. Customer managed keys (Tri-secret secure)
• D. Extended time travel
• E. Native support for geospatial data

Answer: AD

NEW QUESTION 6

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

• A. 30 days
• B. 7 days
• C. 48 hours
• D. 24 hours

Answer: D

NEW QUESTION 7

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

• A. Row level access policies
• B. Data masking policies
• C. Data encryption
• D. Time Travel
• E. External tokenization

Answer: CD

NEW QUESTION 8

Which data type can store more than one type of data structure?

• A. JSON
• B. BINARY
• C. VARCHAR
• D. VARIANT

Answer: D

NEW QUESTION 9

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

• A. True
• B. False

Answer: A

Explanation:
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

NEW QUESTION 10

How would a user run a multi-cluster warehouse in maximized mode?

• A. Configure the maximum clusters setting to "Maximum."
• B. Turn on the additional clusters manually after starting the warehouse.
• C. Set the minimum Clusters and maximum Clusters settings to the same value.
• D. Set the minimum clusters and maximum clusters settings to different values.

Answer: D

NEW QUESTION 11

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A. Schema
• B. View
• C. Internal stage
• D. Table
• E. User
• F. Role

Answer: AD

NEW QUESTION 12

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

• A. Configure the warehouse to a size larger than generally required
• B. Set the minimum and maximum clusters to autoscale
• C. Use the standard warehouse scaling policy
• D. Use the economy warehouse scaling policy

Answer: B

NEW QUESTION 13

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

• A. 4
• B. 16
• C. 32
• D. 128

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

NEW QUESTION 14

Which Snowflake tool would be BEST to troubleshoot network connectivity?

• A. SnowCLI
• B. SnowUI
• C. SnowSQL
• D. SnowCD

Answer: D

Explanation:
https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivi

NEW QUESTION 15

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• A. Customer-managed encryption keys through Tri-Secret Secure
• B. Automatic encryption of all data
• C. Up to 90 days of data recovery through Time Travel
• D. Object-level access control
• E. Column-level security to apply data masking policies to tables and views

Answer: BD

Explanation:
https://docs.snowflake.com/en/user-guide/intro-editions.html

NEW QUESTION 16

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

• A. The user has the appropriate privileges on the objects associated with the query
• B. Micro-partitions have been reclustered since the query was last run
• C. The new query is run using the same virtual warehouse as the previous query
• D. The query includes a User Defined Function (UDF)
• E. The query has been run within 24 hours of the previously-run query

Answer: AE

NEW QUESTION 17

Which of the following commands sets the Virtual Warehouse for a session?

• A. COPT WAREHOUSE FROM <<Config file> ;
• B. SET warehouse = <<warehouse name>>;
• C. USE WAREHOUSE <<warehouse name>>;
• D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Answer: C

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

NEW QUESTION 18

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

• A. SHOW STORAGE BY TABLE;
• B. SHOW TABLES;
• C. Information Schema -> TABLE_HISTORY
• D. Information Schema -> TABLE_FUNCTION
• E. Information Schema -> TABLE_STORAGE_METRICS

Answer: AE

NEW QUESTION 19
......