Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

How would a user execute a series of SQL statements using a 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 the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS

call stored_proc1(); call stored_proc2();

C.

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

D.

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

A.

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

B.

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

C.

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

D.

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

E.

grant SELECT on all tables in database DB1 to role MYROLE;

F.

grant SELECT on future tables in database DB1 to role MYROLE;

What can a Snowflake user do with the information included in the details section of a Query Profile?

A.

Determine the total duration of the query.

B.

Determine the role of the user who ran the query.

C.

Determine the source system that the queried table is from.

D.

Determine if the query was on structured or semi-structured data.

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

A.

CHECK_JSON

B.

TO_JSON

C.

FLATTEN

D.

PARSE_JSON

If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

A.

1 minute

B.

2 minutes

C.

6 minutes

D.

8 minutes

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

A.

Scale up the existing warehouse.

B.

Create separate warehouses for each user.

C.

Create separate warehouses for each workload.

D.

Stop loading and querying data at the same time.

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

A.

SHOW STORAGE BY TABLE;

B.

SHOW TABLES;

C.

Information Schema -> TABLE_HISTORY

D.

Information Schema -> TABLE_FUNCTION

E.

Information Schema -> TABLE_STORAGE_METRICS

How often are the Account and Table master keys automatically rotated by Snowflake?

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days.

What internal stages are available in Snowflake? (Choose three.)

A.

Schema stage

B.

Named stage

C.

User stage

D.

Stream stage

E.

Table stage

F.

Database stage

Which role has the ability to create and manage users and roles?

A.

ORGADMIN

B.

USERADMIN

C.

SYSADMIN

D.

SECURITYADMIN

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

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

A.

Resource monitor

B.

Account_usage. query_history

C.

Information_schema.warehouse_load_history

D.

Information schema.warehouse metering history

Which of the following can be used when unloading data from Snowflake? (Choose two.)

A.

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B.

Use the ENCODING file format option to change the encoding from the default UTF-8.

C.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

A.

Cloud services layer

B.

Compute layer

C.

Storage layer

D.

Cloud agnostic layer

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

A.

The warehouse size does not change until all queries currently running in the warehouse have completed.

B.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

C.

The warehouse size does not change until the warehouse is suspended and restarted.

D.

It does not return from the command until the warehouse has finished changing its size.