Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 671:

  A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

  A. The primary duster in the virtual warehouse

  B. The entire Virtual Warehouse

  C. The database the Virtual Warehouse resides in

  D. The queries currently being run by the Virtual Warehouse

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 672:

  Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred? Select one.

  A. 1 Hour

  B. 3 Hours

  C. 12 hours

  D. 24 hours

  Correct Answer: D

  Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

• Question 673:

  What is the recommended method for loading data into Snowflake?

  A. Load row by row

  B. Load data in batch

  C. Load data by writing it In the Snowflake Web Interface (UI)

  D. Load data via frequent, angle row DML's

  Correct Answer: B

• Question 674:

  Which of the following DML commands isn't supported by Snowflake?

  A. UPSERT

  B. MERGE

  C. UPDATE

  D. TRUNCATE TABLE

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html

• Question 675:

  Snowflake is designed for which type of workloads? (Choose two.)

  A. OLAP (Analytics) workloads

  B. OLTP (Transactional) workloads

  C. Concurrent workloads

  D. On-premise workloads

  Correct Answer: AC

  Reference:

  https://blog.couchbase.com/its-the-workload-stupid/

  https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

• Question 676:

  Which of the following statements is true of data loading? Select one.

  A. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

  B. The "deal file size for loading is 16MB to match micro-partition size

  C. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file

  Correct Answer: C

• Question 677:

  True or False: The COPY command must specify a File Format in order to execute.

  A. True

  B. False

  Correct Answer: B

  Create Stage:

  https://docs.snowflake.com/en/sql-reference/sql/create-stage.html Create Table (STAGE_FILE_FORMAT option):

  https://docs.snowflake.com/en/sql-reference/sql/create-table.html Copy Into:

  https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

• Question 678:

  How many shares can be consumed by single Data Consumer?

  A. 1

  B. 10

  C. 100, but can be increased by contacting support

  D. Unlimited

  Correct Answer: D

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

• Question 679:

  Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

  A. JDBC

  B. SnowSQL

  C. Snowflake Web Interface (UI)

  D. ODBC

  E. Python

  Correct Answer: ABCDE

  Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

• Question 680:

  True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

  A. True

  B. false:

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-snowflake.html