snow3

What are characteristics of transient tables in Snowflake? (Choose two.)

• Transient tables have a Fail-safe period of 7 days.

• Transient tables can be cloned to permanent tables.

• Transient tables persist until they are explicitly dropped.

• Transient tables can be altered to make them permanent tables.

• Transient tables have Time Travel retention periods of 0 or 1 day.

The use of which technique or tool will improve Snowflake query performance on very large tables?

• Indexing

• Clustering keys

• Multi-clustering

• Materialized views

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

• Access control

• Fail-safe

• Network policies

• Time Travel

What does the client redirect feature in Snowflake enable?

• A redirect of client connections to Snowflake accounts in the same regions for business continuity.

• A redirect of client connections to Snowflake accounts in different regions for business continuity.

• A redirect of client connections to Snowflake accounts in different regions for data replication.

• A redirect of client connections to Snowflake accounts in the same regions for data replication.

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

• Tags

• Comments

• Internal tokenization

• Row access policies

The use of which Snowflake table type will reduce costs when working with ETL workflows?

• External

• Permanent

• Temporary

• Transient

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

Which SQL command will download all the data files from an internal table stage named TBL_EMPLOYEE to a local window directory or folder on a client machine in a folder named folder with space within the C drive?

• GET @%TBL_EMPLOYEE 'file:/ C:\folder with space\';

• GET @%TBL_EMPLOYEE 'file:/ C:/folder with space/';

• PUT 'file:/ C:\folder with space\*' @%TBL_EMPLOYEE;

• PUT 'file:/ C:/folder with space/*' @%TBL_EMPLOYEE;

Which Snowflake view is used to support compliance auditing?

• ACCESS_HISTORY

• COPY_HISTORY

• QUERY_HISTORY

• ROW_ACCESS_POLICIES

What is a characteristic of the maintenance of a materialized view?

• Materialized views cannot be refreshed automatically.

• An additional set of scripts is needed to refresh data in materialized views.

• A materialized view is automatically refreshed by a Snowflake managed warehouse.

• A materialized view can be set up with the auto-refresh feature using the SQL SET command.