SNOWPRO-CORE Online Practice Questions and Answers

Account-level storage usage can be monitored via:

A. The snowflake wet Interface (UI) in the Databases section.

B. The Snowflake web interface (UI) in the Account-> Billing a usage section

C. The Information Schema-> ACCOUNT_USAGE_HISTORY View

D. The Account usage Schema-> ACCOUNT_USAGE_METRICS View

Which type of join will list all rows in the specified table, even if those rows have no match in the other table?

A. Cross join

B. Inner join

C. Natural join D. Outer join

Which constraint is enforced in Snowflake?

A. FOREIGN KEY

B. NOT NULL

C. PRIMARY KEY

D. UNIQUE KEY

A user executes the following SQL query:

create table SALES_BKP like SALES;

What are the cost implications for processing this query?

A. Processing costs will be generated based on how long the query takes.

B. Storage costs will be generated based on the size of the data.

C. No costs will be incurred as the query will use metadata.

D. The cost for running the virtual warehouse will be charged by the second.

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A. Whether or not it is also a secure view

B. How often the underlying base table is queried

C. How often the base table changes

D. Whether the materialized view has a cluster key defined

E. How often the materialized view is queried

Which minimum Snowflake edition allows for a dedicated metadata store?

A. Standard

B. Enterprise

C. Business Critical

D. Virtual Private Snowflake

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

A. PUT

B. GET

C. COPY

D. SELECT

Which Snowflake architectural layer is responsible for a query execution plan?

A. Compute

B. Data storage

C. Cloud services

D. Cloud provider