Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 691:

  Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA): Select one:

  A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

  B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN

  C. SECURITYADMIN, ACCOUNTADMIN

  D. ACCOUNTADMIN

  Correct Answer: D

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

• Question 692:

  True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

  A. True

  B. False

  Correct Answer: B

• Question 693:

  Which of the following commands sets the Virtual Warehouse for a session?

  A. COPT WAREHOUSE FROM < ;

  B. SET warehouse = <>;

  C. USE WAREHOUSE <>;

  D. USE VIRTUAL_WAREHOUSE <>;

  Correct Answer: C

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

• Question 694:

  Which statement best describes Snowflake tables?

  A. Snowflake tables are logical representations of underlying physical data

  B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake

  C. Snowflake tables require that clustering keys be defined to perform optimally

  D. Snowflake tables are owned by a user

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html

• Question 695:

  Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?

  A. Java

  B. JavaScript

  C. SQL

  D. Python

  Correct Answer: ABCD

  Reference: https://docs.snowflake.com/en/sql-reference/user-defined-functions.html

• Question 696:

  Which of the following objects is not covered by Time Travel?

  A. Tables

  B. Schemas

  C. Databases

  D. Stages

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

• Question 697:

  What is the minimum duration charged when starting a virtual warehouse?

  A. 1 second

  B. 1 minute

  C. 1 hour

  D. 1 day

  Correct Answer: B

• Question 698:

  Which of the following terms best describes Snowflake's database architecture?

  A. Columnar shared nothing

  B. Shared disk

  C. Multi-cluster, shared data

  D. Cloud-native shared memory

  Correct Answer: C

  https://www.snowflake.com/product/architecture/

  Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.

• Question 699:

  Which of the following are options when creating a Virtual Warehouse?

  A. Auto-suspend

  B. Auto-resume

  C. Local SSD size

  D. User count

  Correct Answer: AB

• Question 700:

  When loading data into Snowflake, the COPY command supports: Choose 2 answers

  A. Joins

  B. Fitters

  C. Data type conversions

  D. Column reordering

  E. Aggregates

  Correct Answer: CD