SnowPro-Core Exam - SnowPro Core Certification Exam

NEW QUESTION 1

What is the minimum Snowflake edition that has column-level security enabled?

• A. Standard
• B. Enterprise
• C. Business Critical
• D. Virtual Private Snowflake

Answer: B

NEW QUESTION 2

True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html

NEW QUESTION 3

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

• A. Configure 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 user's access to expire within a specified timeframe.

Answer: AE

NEW QUESTION 4

In which use cases does Snowflake apply egress charges?

• A. Data sharing within a specific region
• B. Query result retrieval
• C. Database replication
• D. Loading data into Snowflake

Answer: A

Explanation:
Cloud providers apply data egress
charges in either of the following use cases:
Data is transferred from one region to another within the same cloud platform.
Data is transferred out of the cloud platform.
https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20d

NEW QUESTION 5

What is the minimum Snowflake edition that provides data sharing?

• A. Standard
• B. Premier
• C. Enterprise
• D. Business Critical Edition

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing

NEW QUESTION 6

How can a row access policy be applied to a table or a view? (Choose two.)

• A. Within the policy DDL
• B. Within the create table or create view DDL
• C. By future APPLY for all objects in a schema
• D. Within a control table
• E. Using the command ALTER <object> ADD ROW ACCESS POLICY <policy>;

Answer: BD

NEW QUESTION 7

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

• A. Concurrency
• B. Performance

Answer: A

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

NEW QUESTION 8

True or False: You can query the files in an External Stage directly without having to load the data into a table.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

NEW QUESTION 9

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

• A. In the metadata of the target table for 14 days
• B. In the metadata of the pipe for 14 days
• C. In the metadata of the target table for 64 days
• D. In the metadata of the pipe for 64 days

Answer: A

NEW QUESTION 10

For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.

• A. The number of queries that ran using the Warehouse.
• B. The size of the Warehouse and the number of clusters that ran within a given time period.
• C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
• D. The number of users who accessed the Warehouse.

Answer: B

NEW QUESTION 11

What is cached during a query on a virtual warehouse?

• A. All columns in a micro-partition
• B. Any columns accessed during the query
• C. The columns in the result set of the query
• D. All rows accessed during the query

Answer: B

NEW QUESTION 12

What are common issues found by using the Query Profile? (Choose two.)

• A. Identifying queries that will likely run very slowly before executing them
• B. Locating queries that consume a high amount of credits
• C. Identifying logical issues with the queries
• D. Identifying inefficient micro-partition pruning
• E. Data spilling to a local or remote disk

Answer: AD

NEW QUESTION 13

True or False: Snowpipe via RFST API can only reference External Stages as source.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

NEW QUESTION 14

Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

• A. COPY INTO
• B. CREATE PIPE
• C. INSERT INTO
• D. TABLE STREAM

Answer: B

NEW QUESTION 15

True or False: Snowflake charges additional fees to Data providers for each share they create.

• A. True
• B. False

Answer: B

Explanation:
"The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."

NEW QUESTION 16

How does Snowflake Fail-safe protect data in a permanent table?

• A. Fail-safe makes data available up to 1 day, recoverable by user operations.
• B. Fail-safe makes data available for 7 days, recoverable by user operations.
• C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
• D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Answer: C

NEW QUESTION 17

What internal stages are available in Snowflake? (Choose three.)

• A. Schema stage
• B. Named stage
• C. User stage
• D. Stream stage
• E. Table stage
• F. Database stage

Answer: ABE

NEW QUESTION 18

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

• A. Data can be filtered by an optional where clause
• B. Incoming data can be joined with other tables
• C. Columns can be reordered
• D. Columns can be omitted
• E. Row level access can be defined

Answer: CD

NEW QUESTION 19
......