Free Snowflake COF-R02 Practice Exam with Questions & Answers | Set: 6

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task can be executed using a SELECT statement to run a predefined SQL command.

select src:dealership from car_sales;

select src.dealership from car_sales;

select src:Dealership from car_sales;

select dealership from car_sales;

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

Scaling out adds clusters of varying sizes to a virtual warehouse.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

COPY WAREHOUSE FROM <<config file>>;

SET WAREHOUSE = <>;

USE WAREHOUSE <>;

USE VIRTUAL_WAREHOUSE <>;

Protegrity

Tableau

DBeaver

SAP

A reader account can consume data from the provider account that created it and combine it with its own data.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

Bytes sent over network

Percentage scanned from cache

Partitions total

Bytes spilled to local storage

Partitions scanned

Materialized view

Sequence

Secure view

Transient table

Clustered table

Amazon Web Services

Docker

IBM Cloud

Microsoft Azure Cloud

Google Cloud Platform

Oracle Cloud