NEW QUESTION 1

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

• A. True
• B. False

Answer: B

NEW QUESTION 2

When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

• A. When users will be using compute at different times throughout a 24/7 period
• B. When managing a steady workload
• C. When the compute must be available with no delay or lag time
• D. When you don’t want to have to manually turn on the Warehouse each time a user needs it

Answer: BC

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

NEW QUESTION 3

Which are true of Snowflake roles?

• A. All grants to objects are given to roles, and never to users
• B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
• C. The public role controls at other roles
• D. Roles are a subset of users and users own objects In Snowflake

Answer: AB

NEW QUESTION 4

The Snowflake Cloud Data Platform is described as having which of the following architectures?

• A. Shared-disk
• B. Shared-nothing
• C. Multi-cluster shared data
• D. Serverless query engine

Answer: C

NEW QUESTION 5

True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

• A. True
• B. False

Answer: B

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

NEW QUESTION 6

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

• A. Reader
• B. Consumer
• C. Vendor
• D. Standard
• E. Personalized

Answer: DE

NEW QUESTION 7

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

• A. Standard
• B. Enterprise
• C. Business Critical
• D. Virtual Private Snowflake

Answer: B

NEW QUESTION 8

Which TABLE function helps to convert semi-structured data to a relational representation?

• A. CHECK_JSON
• B. TO_JSON
• C. FLATTEN
• D. PARSE_JSON

Answer: D

NEW QUESTION 9

Which of the following are options when creating a virtual Warehouse? Choose 2 answers

• A. Auto-drop
• B. Auto resize
• C. Auto-resume
• D. Auto-suspend

Answer: CD

Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse Reference: https://www.analytics.today/blog/what-is-a-snowflake-virtual-warehouse

NEW QUESTION 10

Which Snowflake partner specializes in data catalog solutions?

• A. Alation
• B. DataRobot
• C. dbt
• D. Tableau

Answer: A

Explanation:
Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise.
https://docs.snowflake.com/en/user-guide/ecosystem-all.html

NEW QUESTION 11

Which of the following are characteristics of security in Snowflake?

• A. Account and user authentication is only available with the Snowflake Business Critical edition.
• B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
• C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
• D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Answer: C

NEW QUESTION 12

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

• A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
• B. The listing is replicated into all selected regions automatically, the data is not.
• C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
• D. Shares attached to listings in remote regions can be viewed from any account in an organization.
• E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Answer: AC

NEW QUESTION 13

Which of the following is true of Snowpipe via REST API? Choose 2 answers

• A. you can only use it on internal Stages
• B. All COPY INTO options are available fluting pipe creation
• C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
• D. Snowpipe keeps track of which files it has loaded

Answer: CD

Explanation:
https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes

NEW QUESTION 14

Which of the following are common use cases for zero-copy cloning? Choose 3 answers

• A. Quick provisioning of Dev and Test/QA environments
• B. Data backups
• C. Point in time snapshots
• D. Performance optimization

Answer: ABC

Explanation:
Reference: https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning

NEW QUESTION 15

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

Answer: CD

NEW QUESTION 16

What is the MOST performant file format for loading data in Snowflake?

• A. CSV (Unzipped)
• B. Parquet
• C. CSV (Gzipped)
• D. ORC

Answer: A

NEW QUESTION 17

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

• A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
• B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
• C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
• D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
• E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
• F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Answer: DEF

NEW QUESTION 18

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

• A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
• B. The transient table version cannot be retrieved after 24 hours.
• C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
• D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Answer: B

NEW QUESTION 19

which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

• A. Bulk copy from an External Stage
• B. Continuous load using Snowpipe REST API
• C. The Snowflake Web Interface (UT) data loading wizard
• D. Bulk copy from an Internal Stage

Answer: ABC

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-overview.html

NEW QUESTION 20
......