Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 141:

  Which of the following describes a Snowflake stored procedure?

  A. They can be created as secure and hide the underlying metadata from the user.

  B. They can only access tables from a single database.

  C. They can contain only a single SQL statement.

  D. They can be created to run with a caller's rights or an owner's rights.

  Correct Answer: D

• Question 142:

  Where is Snowflake metadata stored?

  A. Within the data files

  B. In the virtual warehouse layer

  C. In the cloud services layer

  D. In the remote storage layer

  Correct Answer: C

• Question 143:

  Which command sets the Virtual Warehouse for a session?

  A. COPY WAREHOUSE FROM <>;

  B. SET WAREHOUSE = <>;

  C. USE WAREHOUSE <>;

  D. USE VIRTUAL_WAREHOUSE <>;

  Correct Answer: C

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

• Question 144:

  Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

  A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

  B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

  C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

  D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

  E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

  F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

  Correct Answer: DEF

• Question 145:

  Which of the following describes the Snowflake Cloud Services layer?

  A. Coordinates activities in the Snowflake account

  B. Executes queries submitted by the Snowflake account users

  C. Manages quotas on the Snowflake account storage

  D. Manages the virtual warehouse cache to speed up queries

  Correct Answer: A

• Question 146:

  Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

  A. External Tokenization

  B. External Tables

  C. Materialized Views

  D. User-Defined Table Functions (UDTF)

  Correct Answer: A

• Question 147:

  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

  Correct Answer: AD

• Question 148:

  Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

  A. Materialized view

  B. Sequence

  C. Secure view

  D. Transient table

  E. Clustered table

  Correct Answer: AE

• Question 149:

  Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

  A. CREATE_SHARE on the account

  B. SHARE on databases and schemas

  C. SELECT on tables used by the secure view

  D. REFERENCE_USAGE on databases

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

• Question 150:

  Users are responsible for data storage costs until what occurs?

  A. Data expires from Time Travel

  B. Data expires from Fail-safe

  C. Data is deleted from a table

  D. Data is truncated from a table

  Correct Answer: B