New Year Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

What are the three things customers want most from their enterprise data warehouse solution?

Choose 3 answers

A.

On-premise availability

B.

Simplicity

C.

Open source based

D.

Concurrency

E.

Performance

True or False: Data Providers can share data with only the Data Consumer.

A.

True

B.

False

True or False: It is possible to load data into Snowflake without creating a named File Format object.

A.

True

B.

False

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

A.

True

B.

False

True or False: Pipes can be suspended and resumed.

A.

True

B.

False

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

A.

True

B.

False

True or False: Snowflake charges a premium for storing semi-structured data.

A.

True

B.

False

What privileges are required to create a task?

A.

The global privilege create task is required to create a new task.

B.

Tasks are created at the Application level and can only be created by the Account Admin role.

C.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

D.

The role must have access to the target schema and the create task privilege on the schema itself.

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

A.

True

B.

False

Which of the following statement is true of Snowflake?

Select one.

A.

It was built specifically for the cloud

B.

it was built as an on-premises solution and then potted to the cloud

C.

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D.

It was built for Hadoop architecture

E.

It's based on an Oracle Architecture