Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 311:

  Which command should be used when loading many flat files into a single table?

  A. PUT

  B. INSERT

  C. COPY INTO

  D. MERGE

  Correct Answer: C

• Question 312:

  Which statements reflect valid commands when using secondary roles? (Choose two.)

  A. USE SECONDARY ROLES RESUME

  B. USE SECONDARY ROLES SUSPEND

  C. USE SECONDARY ROLES ALL

  D. USE SECONDARY ROLES ADD

  E. USE SECONDARY ROLES NONE

  Correct Answer: CE

• Question 313:

  Which semi-structured data formats can be loaded into Snowflake with a COPY command? (Choose two.)

  A. CSV

  B. EDI

  C. HTML

  D. ORC

  E. XML

  Correct Answer: DE

• Question 314:

  How long is a query visible in the Query History page in the Snowflake Web Interface (UI)?

  A. 60 minutes

  B. 24 hours

  C. 14 days

  D. 30 days

  Correct Answer: C

• Question 315:

  Where can a Snowflake user find the query history in Snowsight?

  A. Admin

  B. Activity

  C. Dashboards

  D. Data

  Correct Answer: B

• Question 316:

  Why do Snowflake's virtual warehouses have scaling policies?

  A. To help save extra storage costs

  B. To help increase the performance of serverless computing features

  C. To help control the credits consumed by a multi-cluster warehouse running in auto-scale mode

  D. To help control the credits consumed by a multi-cluster warehouse running in maximized mode

  Correct Answer: C

• Question 317:

  Which view will return users who have queried a table?

  A. SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_EVENT_HISTORY

  B. SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY

  C. SNOWFLAKE.ACCOUNT_USAGE.COLUMNS

  D. SNOWFLAKE.ACCOUNT_USAGE.OBJECT_DEPENDENCIES

  Correct Answer: B

• Question 318:

  Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data.

  How does Snowflake recommend resolving this issue?

  A. Scale up the existing warehouse

  B. Create separate warehouses for each user

  C. Create separate warehouses for each workload

  D. Stop loading and querying data at the same time

  Correct Answer: C

• Question 319:

  Which statement is true of zero-copy cloning?

  A. It increases storage costs as cloning a table requires storing its data twice

  B. A cloned table includes the load history of the original source

  C. It is licensed as an additional Snowflake feature

  D. All micro-partitions between the original and cloned tables are fully shared

  Correct Answer: D

• Question 320:

  What is SnowSQL?

  A. Snowflake's new user interface where users can visualize data into charts and dashboards.

  B. Snowflake's proprietary extension of the ANSI SQL standard, including built-in keywords and system functions.

  C. Snowflake's command line client built on the Python connector which is used to connect to Snowflake and execute SQL.

  D. Snowflake's library that provides a programming interface for processing data on Snowflake without moving it to the system where the application code runs.

  Correct Answer: C