NEW QUESTION 1

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

• A. Caching query results
• B. Running EXPLAIN and SHOW commands
• C. Cloning a database
• D. Running a custom query
• E. Running COPY commands

Answer: AD

NEW QUESTION 2

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

• A. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
• B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
• C. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
• D. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Answer: B

NEW QUESTION 3

Which Snowflake architectural layer is responsible for a query execution plan?

• A. Compute
• B. Data storage
• C. Cloud services
• D. Cloud provider

Answer: D

NEW QUESTION 4

True or False: Users are able to see the result sets of queries executed by other users that share their same role.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

NEW QUESTION 5

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 6

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A. Schema
• B. View
• C. Internal stage
• D. Table
• E. User
• F. Role

Answer: AD

NEW QUESTION 7

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

• A. Internal stages
• B. Incremental backups
• C. Time Travel
• D. Zero-copy clones
• E. Fail-safe

Answer: CE

Explanation:
Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.
Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):
Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.
Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe. https://docs.snowflake.com/en/user-guide/data-availability.html

NEW QUESTION 8

What is the purpose of an External Function?

• A. To call code that executes outside of Snowflake
• B. To run a function in another Snowflake database
• C. To share data in Snowflake with external parties
• D. To ingest data from on-premises data sources

Answer: A

Explanation:
https://docs.snowflake.com/en/sql-reference/external-functions.html

NEW QUESTION 9

What is the recommended Snowflake data type to store semi-structured data like JSON?

• A. VARCHAR
• B. RAW
• C. LOB
• D. VARIANT

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

NEW QUESTION 10

The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

• A. The complexity of each query
• B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
• C. The size of the data required for each query
• D. The tool that s executing the query

Answer: AC

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

NEW QUESTION 11

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 12

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 13

Which object allows you to limit the number of credits consumed within a Snowflake account? Select one.

• A. Account usage Tracking
• B. Resource Monitor
• C. Warehouse Limit Parameter
• D. Credit Consumption Tracker

Answer: B

Explanation:
The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."

NEW QUESTION 14

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 15

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

• A. Pre-signed URL
• B. Scoped URL
• C. Signed URL
• D. File URL

Answer: C

NEW QUESTION 16

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

• A. Customers can change the size of the Warehouse after creation
• B. A Warehouse can be resized while running
• C. A Warehouse can be configured to suspend after a period of inactivity
• D. A Warehouse can be configured to auto-resume when new queries are submitted

Answer: ABCD

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

NEW QUESTION 17

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

• A. True
• B. False

Answer: B

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

NEW QUESTION 18

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

• A. USERADMIN
• B. PUBLIC
• C. ORGADMIN
• D. SYSADMIN

Answer: D

NEW QUESTION 19

Where would a Snowflake user find information about query activity from 90 days ago?

• A. Account___usage . query history view
• B. account___usage.query___history___archive View
• C. information___schema . cruery_history view
• D. information___schema - query history_by_ses s i on view

Answer: A

NEW QUESTION 20
......