Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 741:

  What is the default character set used when loading CSV files into Snowflake?

  A. UTF-8

  B. UTF-16

  C. ISO S859-1

  D. ANSI_X3.A

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20 use%20for%20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

• Question 742:

  Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

  A. Customer-managed encryption keys through Tri-Secret Secure

  B. Automatic encryption of all data

  C. Up to 90 days of data recovery through Time Travel

  D. Object-level access control

  E. Column-level security to apply data masking policies to tables and views

  Correct Answer: BD

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

• Question 743:

  Which of the following are benefits of micro-partitioning? (Select TWO)

  A. Micro-partitions cannot overlap in their range of values

  B. Micro-partitions are immutable objects that support the use of Time Travel.

  C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

  D. Rows are automatically stored in sorted order within micro-partitions

  E. Micro-partitions can be defined on a schema-by-schema basis

  Correct Answer: BC

• Question 744:

  True or False: A Virtual Warehouse can be resized while suspended.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse

• Question 745:

  Which statement about billing applies to Snowflake credits?

  A. Credits are billed per-minute with a 60-minute minimum

  B. Credits are used to pay for cloud data storage usage

  C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs

  D. Credits are consumed based on the warehouse size and the time the warehouse is running

  Correct Answer: D

  Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used. https://docs.snowflake.com/en/user-guide/what-are-credits.html

• Question 746:

  What data is stored in the Snowflake storage layer? (Select TWO).

  A. Snowflake parameters

  B. Micro-partitions

  C. Query history

  D. Persisted query results

  E. Standard and secure view results

  Correct Answer: BC

  B. Micro-partitions

  C. Query history (also stored in the data layer of SNOWFLAKE.USAGE_SCHEMA)

• Question 747:

  A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

  Which of the following statements will accommodate this request?

  A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

  B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

  C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

  D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

  Correct Answer: B

• Question 748:

  A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

  A. list @mytable;

  B. list @%raytable;

  C. list @ %m.ystage;

  D. list @mystage;

  Correct Answer: D

• Question 749:

  What happens when a cloned table is replicated to a secondary database? (Select TWO)

  A. A read-only copy of the cloned tables is stored.

  B. The replication will not be successful.

  C. The physical data is replicated

  D. Additional costs for storage are charged to a secondary account

  E. Metadata pointers to cloned tables are replicated

  Correct Answer: CD

  Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/database-replicationconsiderations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20areandtext=However%2C%20when%20a%20cloned%20table,storage%20usage%20for% 20your%20account.

• Question 750:

  User-level network policies can be created by which of the following roles? (Select TWO).

  A. ROLEADMIN

  B. ACCOUNTADMIN

  C. SYSADMIN

  D. SECURITYADMIN

  E. USERADMIN

  Correct Answer: BD