Which of the following is the Snowflake Account_Usage.Metering_History view used for?

A.

Gathering the hourly credit usage for an account

B.

Compiling an account's average cloud services cost over the previous month

C.

Summarizing the throughput of Snowpipe costs for an account

D.

Calculating the funds left on an account's contract

Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).

A.

GO driver

B.

Node.js driver

C.

ODBC driver

D.

Python connector

E.

Spark connector

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?

A.

No virtual warehouse will be used, data will be read from the result cache.

B.

No virtual warehouse will be used, data will be read from the local disk cache.

C.

The default virtual warehouse will be used to read all data.

D.

The virtual warehouse that is defined at the session level will be used to read all data.

What can a Snowflake user do in the Admin area of Snowsight?

A.

Analyze query performance.

B.

Write queries and execute them.

C.

Provide an overview of the listings in the Snowflake Marketplace.

D.

Connect to Snowflake partners to explore extended functionality.

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micropartitions?

A.

Enterprise

B.

Business Critical

C.

Standard

D.

Virtual Private Snowflake

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

A.

TSV

B.

JSON

C.

PDF

D.

Avro

E.

Parquet

F.

JPEG

Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

A.

Authy

B.

Duo Security

C.

One Login

D.

RSA SecurlD Access

What is the name of the SnowSQLfile that can store connection information?

A.

history

B.

config

C.

snowsqLcnf

D.

snowsql.pubkey

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

A.

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

B.

A Data Exchange allows groups of accounts to share data privately among the
accounts.

C.

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

D.

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

E.

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A.

STRIP_NULL_VALUES

B.

SKIP_BYTE_ORDER_MARK

C.

REPLACE_INVALID_CHARACTERS

D.

VALIDATION_MODE

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

A.

The data provider in Azure Central Canada can create a direct share to AWS Asia
Pacific, if they are both in the same organization.

B.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

C.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

D.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

What role is required to use Partner Connect?

A.

ACCOUNTADMIN

B.

ORGADMIN

C.

SECURITYADMIN

D.

SYSADMIN