Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 181:

  In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

  A. When the system has enough load for 2 minutes

  B. When the system has enough load for 6 minutes

  C. When the system has enough load for 8 minutes

  D. When the system has enough load for 10 minutes

  Correct Answer: B

• Question 182:

  Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

  A. Data is live, ready-to-query, and can be personalized.

  B. Data needs to be loaded into a cloud provider as a consumer account.

  C. Data is not available for copying or moving to an individual Snowflake account.

  D. Data is available without copying or moving.

  E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

  Correct Answer: AD

• Question 183:

  What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  A. Authentication

  B. Resource management

  C. Virtual warehouse caching

  D. Query parsing and optimization

  E. Query execution

  F. Physical storage of micro-partitions

  Correct Answer: ABD

• Question 184:

  Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

  A. Schema Stage

  B. User Stage

  C. Database Stage

  D. Table Stage

  E. External Named Stage

  F. Internal Named Stage

  Correct Answer: BDF

• Question 185:

  What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

  A. The Pipe load history is reset to empty.

  B. The REFRESH command is executed.

  C. The stage will be purged.

  D. The destination table is truncated.

  Correct Answer: B

• Question 186:

  If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

  A. The columns that are queried in the select clause.

  B. The columns with very high cardinality.

  C. The columns with many different values.

  D. The columns most actively used in the select filters.

  Correct Answer: D

• Question 187:

  How would a user run a multi-cluster warehouse in maximized mode?

  A. Configure the maximum clusters setting to "Maximum."

  B. Turn on the additional clusters manually after starting the warehouse.

  C. Set the minimum Clusters and maximum Clusters settings to the same value.

  D. Set the minimum clusters and maximum clusters settings to different values.

  Correct Answer: C

• Question 188:

  Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

  Which diagram indicates a well-clustered table?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 189:

  A user is preparing to load data from an external stage

  Which practice will provide the MOST efficient loading performance?

  A. Organize files into logical paths

  B. Store the files on the external stage to ensure caching is maintained

  C. Use pattern matching for regular expression execution

  D. Load the data in one large file

  Correct Answer: A

• Question 190:

  What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  A. VIEWS_HISTORY

  B. OBJECT_HISTORY

  C. ACCESS_HISTORY

  D. LOGIN_HISTORY

  Correct Answer: C