Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 81:

  How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

  A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

  B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

  C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

  D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

  Correct Answer: D

• Question 82:

  What privilege should a user be granted to change permissions for new objects in a managed access schema?

  A. Grant the OWNERSHIP privilege on the schema.

  B. Grant the OWNERSHIP privilege on the database.

  C. Grant the MANAGE GRANTS global privilege.

  D. Grant ALL privileges on the schema.

  Correct Answer: A

• Question 83:

  What type of query benefits the MOST from search optimization?

  A. A query that uses only disjunction (i.e., OR) predicates

  B. A query that includes analytical expressions

  C. A query that uses equality predicates or predicates that use IN

  D. A query that filters on semi-structured data types

  Correct Answer: C

  Reference: https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use

• Question 84:

  Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

  A. SELECT SUM (ORDER_AMT) FROM SALES;

  B. SELECT AVG(ORDER_QTY) FROM SALES;

  C. SELECT MIN(ORDER_AMT) FROM SALES;

  D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

  Correct Answer: C

• Question 85:

  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

  Correct Answer: B

• Question 86:

  Which of the following significantly improves the performance of selective point lookup queries on a table?

  A. Clustering

  B. Materialized Views

  C. Zero-copy Cloning

  D. Search Optimization Service

  Correct Answer: D

• Question 87:

  What is the following SQL command used for?

  Select * from table(validate(t1, job_id => '_last'));

  A. To validate external table files in table t1 across all sessions

  B. To validate task SQL statements against table t1 in the last 14 days

  C. To validate a file for errors before it gets executed using a COPY command

  D. To return errors from the last executed COPY command into table t1 in the current session

  Correct Answer: D

• Question 88:

  Which minimum Snowflake edition allows for a dedicated metadata store?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: D

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

• Question 89:

  Which statement describes pruning?

  A. The filtering or disregarding of micro-partitions that are not needed to return a query.

  B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.

  C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.

  D. The ability to allow the result of a query to be accessed as if it were a table.

  Correct Answer: A

• Question 90:

  What is the minimum Snowflake edition required for row level security?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: B