SnowPro-Core Exam - SnowPro Core Certification Exam

NEW QUESTION 1

When unloading to a stage, which of the following is a recommended practice or approach?

• A. Set SINGLE: = true for larger files
• B. Use OBJECT_CONSTRUCT ( * ) when using Parquet
• C. Avoid the use of the CAST function
• D. Define an individual file format

Answer: C

NEW QUESTION 2

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

• A. VARIANT
• B. VARRAY
• C. STRUCT
• D. ARRAY
• E. QUEUE

Answer: AD

NEW QUESTION 3

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

• A. Informatica
• B. Power Bl
• C. Adobe
• D. Data Robot

Answer: D

Explanation:
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

NEW QUESTION 4

True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

• A. True
• B. False

Answer: B

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

NEW QUESTION 5

True or False: Snowflake charges a premium for storing semi-structured data.

• A. True
• B. False

Answer: B

Explanation:
Reference:
https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges- premium-for-storing-semi-structured-data

NEW QUESTION 6

Which of the following significantly improves the performance of selective point lookup queries on a table?

• A. Clustering
• B. Materialized Views
• C. Zero-copy Cloning
• D. Search Optimization Service

Answer: A

NEW QUESTION 7

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

• A. parse_json()
• B. json_extract_path_text()
• C. object_construct()
• D. flatten

Answer: B

NEW QUESTION 8

Which of the following describes how clustering keys work in Snowflake?

• A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
• B. Clustering keys sort the designated columns over time, without blocking DML operations
• C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
• D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Answer: B

NEW QUESTION 9

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

Answer: D

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

NEW QUESTION 10

The is the minimum Fail-safe retention time period for transient tables?

• A. 1 day
• B. 7 days
• C. 12 hours
• D. 0 days

Answer: D

NEW QUESTION 11

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

• A. CREATE_SHARE on the account
• B. SHARE on databases and schemas
• C. SELECT on tables used by the secure view
• D. REFERENCE_USAGE on databases

Answer: C

NEW QUESTION 12

Which interfaces can be used to create and/or manage Virtual Warehouses?

• A. The Snowflake Web Interface (UI)
• B. SQL commands
• C. Data integration tools
• D. All of the above

Answer: D

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

NEW QUESTION 13

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement? Select one.

• A. INITTIALLY_SUSPENDED = TRUE/FALSE
• B. START_AFTCR_CREATE = TRUE/FALSE
• C. START_TTIME = 60 // (seconds from now)
• D. START.TIME = CURRENT.DATE()

Answer: A

NEW QUESTION 14

True or False the longer the data retention period, the higher the resulting storage costs.

• A. True
• B. False

Answer: A

NEW QUESTION 15

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

• A. Auto-suspend
• B. Auto-resume
• C. Local SSD size
• D. User count

Answer: AB

NEW QUESTION 16

Which command sets the Virtual Warehouse for a session?

• A. COPY WAREHOUSE FROM <<config file>>;
• B. SET WAREHOUSE = <<warehouse name>>;
• C. USE WAREHOUSE <<warehouse name>>;
• D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Answer: C

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

NEW QUESTION 17

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

• A. The number of queries executed
• B. The number of active users assigned to the warehouse
• C. The size of the virtual warehouse
• D. The length of time the warehouse is running
• E. The duration of the queries that are executed

Answer: AD

NEW QUESTION 18

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

Answer: ADE

NEW QUESTION 19
......