Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 29

Question list

List of questions

Question 281

(0)

Which of the following statements describes a schema in Snowflake?

Question 282

(0)

What is a responsibility of Snowflake’s virtual warehouses?

Question 283

(0)

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

Question 284

(0)

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

Question 285

(0)

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

Question 286

(0)

Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

Question 287

(0)

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Question 288

(0)

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?

Question 289

(0)

Which statement describes how Snowflake supports reader accounts?

Question 290

(0)

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

Question 281

Which of the following statements describes a schema in Snowflake?

A logical grouping of objects that belongs to a single database

A logical grouping of objects that belongs to multiple databases

A named Snowflake object that includes all the information required to share a database

A uniquely identified Snowflake account within a business entity

Show Answer Comment (0)

Question 282

What is a responsibility of Snowflake’s virtual warehouses?

Infrastructure management

Metadata management

Query execution

Query parsing and optimization

Permanent storage of micro-partitions

Show Answer Comment (0)

Question 283

Which of the following are handled by the cloud services layer of the Snowflake architecture?

(Choose two.)

Query execution

Data loading

Time Travel data

Security

Authentication and access control

Show Answer Comment (0)

Question 284

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

The number of queries executed

The number of active users assigned to the warehouse

The size of the virtual warehouse

The length of time the warehouse is running

The duration of the queries that are executed

Show Answer Comment (0)

Question 285

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

TSV

JSON

PDF

Avro

Parquet

JPEG

Show Answer Comment (0)

Question 286

Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

COPY INTO

CREATE PIPE

INSERT INTO

TABLE STREAM

Show Answer Comment (0)

Question 287

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Schemas

Roles

Secure Views

Stored Procedures

Tables

Secure User-Defined Functions (UDFs)

Show Answer Comment (0)

Question 288

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?

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

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.

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.

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.

Show Answer Comment (0)