Logo ExamsQA
Exit
Free 0/10
1
Question

When a Snowflake user loads CSV data from a stage, which copy into <table> command guideline should they follow?

Options
A

The CSV field delimiter must be a comma character (*,"),
B

The number of columns in each row should be consistent.
C

The data file in the stage must be in a compressed format.
D

The data file must have the same number of columns as the target table.
2
Question

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?

Options
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
3
Question

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

Options
A

A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.
B

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
C

A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.
D

Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
4
Question

What do temporary and transient tables have m common in Snowflake? (Select TWO).

Select 2
Options
A

Both tables have no Fail-safe period.
B

Both tables have data retention period maximums of one day.
C

Both tables are visible only to a single user session.
D

For both tables the retention period ends when the tables are dropped.
E

For both tables, the retention period does not end when the session ends
5
Question

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

Options
A

DATA_RETENTION_TIME_IN_DAYS
B

MAX_DATA_EXTENSION_TIME_IN_DAYS
C

MIN_DATA_RETENTION_TIME_IN_DAYS
D

MAX CONCURRENCY LEVEL
6
Question

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

Options
A

Standard
B

Enterprise
C

Business Critical
D

Virtual Private Snowflake
7
Question

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Select 2
Options
A

Use the DROP <file> command after the load completes.
B

Specify the TEMPORARY option when creating the file format.
C

Specify the PURGE copy option in the COPY INTO <table> command.
D

Use the REMOVE command after the load completes.
E

Use the DELETE LOAD HISTORY command after the load completes.
8
Question

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Select 2
Options
A

Customer-managed encryption keys through Tri-Secret Secure
B

Automatic encryption of all data
C

Up to 90 days of data recovery through Time Travel
D

Object-level access control
E

Column-level security to apply data masking policies to tables and views
9
Question

Which Snowflake object contains all the information required to share a database?

Options
A

Private listing
B

Secure view
C

Sequence
D

Share
10
Question

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

Select 2
Options
A

Range of values
B

Distinct values
C

Index values
D

Sorted values
E

Null values