Snow12

What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?

• Reorder the rows in a relational table and then unload the rows into a file.

• Convert the rows in a relational table to a single VARIANT column and then unload the rows into a file.

• Reorder the data columns according to a target table definition and then unload the rows into the table.

• Convert the rows in a source file to a single VARIANT column and then load the rows from the file to a variant table.

The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)

• Views for all the objects contained in the database

• Views for all the objects contained in the Snowflake account

• Views for historical and usage data across the Snowflake account

• Table functions for historical and usage data across the Snowflake account

• Table functions for account-level objects, such as roles, virtual warehouses, and databases

What is the purpose of the Snowflake SPLIT_TO_TABLE function?

• To count the number of characters in a string

• To split a string into an array of sub-strings

• To split a string and flatten the results into rows

• To split a string and flatten the results into columns

Which command is used to unload data from a Snowflake table to an external stage?

• COPY INTO

• COPY INTO followed by GET

• GET

• COPY INTO followed by PUT

What are Snowflake best practices when assigning the ACCOUNTADMIN role to users? (Choose two.)

• The ACCOUNTADMIN role should be assigned to at least two users.

• The ACCOUNTADMIN role should be used to create Snowflake objects.

• The ACCOUNTADMIN role should be used for running automated scripts.

• The ACCOUNTADMIN role should be given to any user who needs a high level of authority.

• All users assigned the ACCOUNTADMIN role should use Multi-Factor Authentication (MFA).

What is a recommended approach for optimizing query performance in Snowflake?

• Use subqueries whenever possible.

• Use a large number of joins to combine data from multiple tables.

• Select all columns from tables, even if they are not needed in the query.

• Use a smaller number of larger tables rather than a larger number of smaller tables.

Which Snowflake view is used to support compliance auditing?

• ACCESS_HISTORY

• COPY_HISTORY

• QUERY_HISTORY

• ROW_ACCESS_POLICIES

How can a Snowflake user load duplicate files with a COPY INTO command?

• The COPY INTO options should be set to PURGE = FALSE

• The COPY INTO options should be set to FORCE = TRUE

• The COPY INTO options should be set to RETURN_FAILED_ONLY = FALSE

• The COPY INTO options should be set to ON_ERROR = CONTINUE

What causes objects in a data share to become unavailable to a consumer account?

• The DATA_RETENTION_TIME_IN_DAYS parameter in the consumer account is set to 0.

• The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.

• The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

• The consumer account acquires the data share through a private data exchange.

Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

• Directory table

• Temporary table

• Transient table

• A table with a materialized view