NEW QUESTION 1

How would you execute a series of SQL statements using Task?

• A. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1 where ..
• B. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);
• C. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task.CREATE TASK mytask.... AS callstored_proc_multiple_statements_inside():
• D. Create a task for each SQL statement (e.
• E. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

Answer: C

NEW QUESTION 2

When creating a user it is advisable sable to:
Choose 2 answers

• A. Set the user to be initially disabled
• B. Force an immediate password change
• C. Set a default role for the user
• D. Set the number of minutes to unlock to 15 minutes
• E. Set the users access to expire within a specified timeframe

Answer: BC

NEW QUESTION 3

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

• A. True
• B. False

Answer: B

NEW QUESTION 4

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

• A. The clone always stays in sync with the original table.
• B. The clone has better query performance.
• C. The clone is created almost instantly.
• D. The clone will have time travel history from the original table.
• E. The clone saves space by not duplicating storage.

Answer: CE

NEW QUESTION 5

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

• A. SCIM
• B. Federated authentication
• C. TLS 1.2
• D. Key-pair authentication
• E. OAuth
• F. OCSP authentication

Answer: BDE

NEW QUESTION 6

True or False: Snowpipe via REST API can only reference External Stages as source.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

NEW QUESTION 7

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

• A. Is available to all Snowflake Editions
• B. Is only available to customers with Business Critical Edition
• C. Restricts or enables access to specific IP addresses
• D. Is activated using an “ALTER DATABASE” command

Answer: AC

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

NEW QUESTION 8

Which feature allows a user the ability to control the organization of data in a micro-partition?

• A. Range Partitioning
• B. Search Optimization Service
• C. Automatic Clustering
• D. Horizontal Partitioning

Answer: D

NEW QUESTION 9

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

• A. Gathering the hourly credit usage for an account
• B. Compiling an account's average cloud services cost over the previous month
• C. Summarizing the throughput of Snowpipe costs for an account
• D. Calculating the funds left on an account's contract

Answer: A

NEW QUESTION 10

A sales table FCT_SALES has 100 million records. The following Query was executed
SELECT COUNT (1) FROM FCT___SALES;
How did Snowflake fulfill this query?

• A. Query against the result set cache
• B. Query against a virtual warehouse cache
• C. Query against the most-recently created micro-partition
• D. Query against the metadata excite

Answer: D

NEW QUESTION 11

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

• A. Amazon Web Services
• B. Docker
• C. IBM Cloud
• D. Microsoft Azure Cloud
• E. Google Cloud Platform
• F. Oracle Cloud

Answer: BDE

NEW QUESTION 12

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?

• A. It removes the last element of the outer array.
• B. It removes the outer array structure and loads the records into separate table rows,
• C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
• D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Answer: B

Explanation:
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows.
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.
If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO
<table> command to remove the outer array structure and load the records into separate table rows:
copy into <table> from @~/<file>.json
file_format = (type = 'JSON' strip_outer_array = true); https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

NEW QUESTION 13

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

• A. USAGE
• B. OPERATE
• C. MONITOR
• D. MODIFY

Answer: B

Explanation:
Reference:
https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privileg

NEW QUESTION 14

A virtual warehouse is created using the following command:
Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60 auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

• A. Increase the warehouse size from Medium to 2XL.
• B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
• C. Configure the warehouse to a multi-cluster warehouse.
• D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Answer: B

NEW QUESTION 15

The Snowflake Search Optimization Services supports improved performance of which kind of query?

• A. Queries against large tables where frequent DML occurs
• B. Queries against tables larger than 1 TB
• C. Selective point lookup queries
• D. Queries against a subset of columns in a table

Answer: C

Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimiza%20point,OBJECT%2C%20and%20ARRAY%20columns)

NEW QUESTION 16

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

• A. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
• B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
• C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
• D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed

Answer: BD

Explanation:
The results cache will only be used if it's the same query AND the same role executing the query

NEW QUESTION 17

What is a best practice after creating a custom role?

• A. Create the custom role using the SYSADMIN role.
• B. Assign the custom role to the SYSADMIN role
• C. Assign the custom role to the PUBLIC role
• D. Add__CUSTOM to all custom role names

Answer: B

Explanation:
When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

NEW QUESTION 18

Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

• A. Micro-partitions
• B. Clustering keys
• C. Key partitions
• D. Clustered partitions

Answer: B

Explanation:
Reference: https://community.snowflake.com/s/article/Snowflake-What-the-Cluster

NEW QUESTION 19

True or False: All Snowflake table types include fail-safe storage.

• A. True
• B. False

Answer: B

NEW QUESTION 20
......