Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 231:

  Which of the following is the Snowflake Account_Usage.Metering_History view used for?

  A. Gathering the hourly credit usage for an account

  B. Compiling an account's average cloud services cost over the previous month

  C. Summarizing the throughput of Snowpipe costs for an account

  D. Calculating the funds left on an account's contract

  Correct Answer: A

• Question 232:

  What is the minimum Snowflake edition required to use Dynamic Data Masking?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake (VPC)

  Correct Answer: B

• Question 233:

  A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

  What will occur?

  A. No virtual warehouse will be used, data will be read from the result cache.

  B. No virtual warehouse will be used, data will be read from the local disk cache.

  C. The default virtual warehouse will be used to read all data.

  D. The virtual warehouse that is defined at the session level will be used to read all data.

  Correct Answer: A

• Question 234:

  Which Snowflake partner category is represented at the top of this diagram (labeled 1)?

  

  A. Business Intelligence

  B. Machine Learning and Data Science

  C. Security and Governance

  D. Data Integration

  Correct Answer: D

• Question 235:

  The following SQL statements have been executed:

  

  What will the output be of the last select statement?

  A. 3

  B. 4

  C. 7

  D. 8

  Correct Answer: C

• Question 236:

  What does the orange bar on an operator represent when reviewing the Query Profile?

  

  A. A measure of progress of the operator's execution.

  B. The fraction of time that this operator consumed within the query step.

  C. The cost of the operator in terms of the virtual warehouse CPU utilization.

  D. The fraction of data scanned from cache versus remote disk for the operator.

  Correct Answer: B

• Question 237:

  How can a Snowflake user access a JSON object, given the following table? (Choose two.)

  

  A. src:salesperson.name

  B. src:salesPerson.name

  C. src:salesPerson.Name

  D. SRC:salesPerson.name

  E. SRC:salesPerson.Name

  Correct Answer: BD

• Question 238:

  The Query Profile in the image is for a query executed in Snowsight. Four of the key nodes are highlighted in yellow.

  

  Which highlighted node will be the MOST expensive?

  A. Aggregate[1]

  B. Join[5]

  C. TableScan[2]

  D. TableScan[3]

  Correct Answer: D

• Question 239:

  For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

  A. CHECK_OPTION

  B. IS_SECURE

  C. IS_UPDATEABLE

  D. TABLE_NAME

  Correct Answer: B

• Question 240:

  A clustering key was defined on a table, but it is no longer needed.

  How can the key be removed?

  A. ALTER TABLE PURGE CLUSTERING KEY

  B. ALTER TABLE DELETE CLUSTERING KEY

  C. ALTER TABLE DROP CLUSTERING KEY

  D. ALTER TABLE REMOVE CLUSTERING KEY

  Correct Answer: C