While unloading data into a stage, how can the user ensure that the output will be a single file?

• A.Use the copy option files=single.
• B.Use the COPY Option SINGLE=TRUE .
• C.Use the get option SINGLE-TRUE.
• D.Use the GET option FILES-SINGLE.

Comment: *

Name: *

Email: *

Verification: *

Which commands are supported by the query acceleration service? (Select TWO).

• A.MERGE
• B.UPDATE
• C.DELETE
• D.SELECT
• E.INSERT

Comment: *

Name: *

Email: *

Verification: *

How can a user change which columns are referenced in a view?

• A.Modify the columns in the underlying table
• B.Use the ALTER VIEW command to update the view
• C.Recreate the view with the required changes
• D.Materialize the view to perform the changes

Comment: *

Name: *

Email: *

Verification: *

True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?

• A.Create a view on the table.
• B.Add a clustering key to the table
• C.Add a limit clause to the query.
• D.Add a Dynamic Data Masking policy to the table.

Comment: *

Name: *

Email: *

Verification: *