The Secret Of Snowflake SnowPro-Core Free Demo

NEW QUESTION 1

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

• A. An FTP server with TLS encryption
• B. An HTTPS server with WebDAV
• C. A Google Cloud storage bucket
• D. A Windows server file share on Azure

Answer: C

NEW QUESTION 2

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

• A. The primary cluster in the virtual warehouse
• B. The entire virtual warehouse
• C. The database in which the virtual warehouse resides
• D. The Queries currently being run on the virtual warehouse

Answer: B

Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresum

NEW QUESTION 3

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 4

Select the different types of Internal Stages: (Choose three.)

• A. Named Stage
• B. User Stage
• C. Table Stage
• D. Schema Stage

Answer: ABC

Explanation:
Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal- Named-Stage

NEW QUESTION 5

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?

• A. Row access policies
• B. Data masking policies
• C. Data encryption
• D. Role based access control

Answer: B

NEW QUESTION 6

Which feature is only available in the Enterprise or higher editions of Snowflake?

• A. Column-level security
• B. SOC 2 type II certification
• C. Multi-factor Authentication (MFA)
• D. Object-level access control

Answer: A

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

NEW QUESTION 7

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 8

Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

• A. Scaling rhythmically
• B. Scaling max
• C. Scaling out
• D. Scaling up

Answer: D

NEW QUESTION 9

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?

• A. PURGE
• B. MODIFY
• C. REMOVE
• D. DELETE

Answer: D

Explanation:
Reference:
https://www.simplilearn.com/tutorials/sql-tutorial/delete-in-sql#:~:text=The%20Delete%20command%20in%20

NEW QUESTION 10

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

• A. True
• B. False

Answer: A

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

NEW QUESTION 11

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 12

A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

• A. view @my_stage
• B. list @my_stage
• C. show @my_stage
• D. display @my_stage

Answer: B

NEW QUESTION 13

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

• A. Local disk caching
• B. Authentication and access control
• C. Metadata management
• D. Query processing
• E. Database storage

Answer: CD

NEW QUESTION 14

Which of the following objects are contained within a schema? (Choose two.)

• A. Role
• B. Stream
• C. Warehouse
• D. External table
• E. User
• F. Share

Answer: CD

NEW QUESTION 15

True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

NEW QUESTION 16

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

• A. UPSERT
• B. MERGE
• C. UPDATE
• D. TRUNCATE TABLE

Answer: A

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

NEW QUESTION 17

True or False: An active warehouse is required to run a COPY INTO statement.

• A. True
• B. False

Answer: A

NEW QUESTION 18

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

• A. True
• B. False

Answer: B

Explanation:
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

NEW QUESTION 19

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

• A. Management of metadata
• B. Computing the data
• C. Maintaining Availability Zones
• D. Infrastructure security
• E. Parsing and optimizing queries

Answer: AE

NEW QUESTION 20
......