Snowflake COF-R02 Quiz 1 Topic 1 Questions 1-5

Question: 1

True or False: A single database can exist in more than one Snowflake account.

ATrue

BFalse

Show Answer

Question: 2

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

AData can be filtered by an optional where clause

BIncoming data can be joined with other tables

CColumns can be reordered

DColumns can be omitted

ERow level access can be defined

Show Answer

Question: 3

Which interfaces can be used to create and/or manage Virtual Warehouses?

AThe Snowflake Web Interface (UI)

BSQL commands

CData integration tools

DAll of the above

Show Answer

Question: 4

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

AUse auto-ingest Snowpipes to load large files in a serverless model.

BProduce the largest files possible, reducing the overall number of files to process.

CProduce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

DUse an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Show Answer

Question: 5

What is the minimum Snowflake edition required to use Dynamic Data Masking?

AStandard

BEnterprise

CBusiness Critical

DVirtual Private Snowflake (VPC)

Show Answer

Snowflake COF-R02 Quiz:1 Topic:1 Questions:1-5