ExamGecko
Search Search Login
Home Home / Snowflake / COF-C02

Snowflake COF-C02 Practice Test - Questions Answers, Page 22

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
Which minimum Snowflake edition allows for a dedicated metadata store?
How can the outer array structure of a semi-structured file be removed?
Who can access the data published in a Data Exchange?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
What virtual warehouse configuration should be used when processing a large number of complex queries?
Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How does the search optimization service improve query performance?
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select TWO).

Question 211

Report
Export
Collapse

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

A.
Schemas
A.
Schemas
Answers
B.
Roles
B.
Roles
Answers
C.
Secure Views
C.
Secure Views
Answers
D.
Stored Procedures
D.
Stored Procedures
Answers
E.
Tables
E.
Tables
Answers
F.
Secure User-Defined Functions (UDFs)
F.
Secure User-Defined Functions (UDFs)
Answers
Suggested answer: A, C, F

Explanation:

In Snowflake, you can share several types of objects with other Snowflake accounts. These include schemas, secure views, and secure user-defined functions (UDFs).Sharing these objects allows for collaboration and data access across different Snowflake accounts while maintaining security and governance controls4.

Question 212

Report
Export
Collapse

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.
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.
Answers
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.
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.
Answers
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.
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.
Answers
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.
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.
Answers
Suggested answer: D

Explanation:

Snowflake allows data providers to share data with consumers across different cloud platforms and regions through database replication. The data provider must replicate the database to a secondary account in the target region or cloud platform within the same organization, and then create a share to the data consumer's account.This process ensures that the data is available in the consumer's region and on their cloud platform, facilitating seamless data sharing. References: Sharing data securely across regions and cloud platforms | Snowflake Documentation

Question 213

Report
Export
Collapse

Which statement describes how Snowflake supports reader accounts?

A.
A reader account can consume data from the provider account that created it and combine it with its own data.
A.
A reader account can consume data from the provider account that created it and combine it with its own data.
Answers
B.
A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
B.
A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
Answers
C.
The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
C.
The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
Answers
D.
The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
D.
The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
Answers
Suggested answer: B

Explanation:

Snowflake supports reader accounts, which are a type of account that allows data providers to share data with consumers who are not Snowflake customers.However, for data sharing to occur, the consumer needs to become a licensed Snowflake customer because data sharing is only supported between Snowflake accounts. References: Introduction to Secure Data Sharing | Snowflake Documentation2.

Question 214

Report
Export
Collapse

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

A.
USERADMIN
A.
USERADMIN
Answers
B.
PUBLIC
B.
PUBLIC
Answers
C.
ORGADMIN
C.
ORGADMIN
Answers
D.
SYSADMIN
D.
SYSADMIN
Answers
Suggested answer: A

Explanation:

The first user assigned to a new Snowflake account, typically with the ACCOUNTADMIN role, should create at least one additional user with the USERADMIN administrative privilege.This role is responsible for creating and managing users and roles within the Snowflake account. References: Access control considerations | Snowflake Documentation

Question 215

Report
Export
Collapse

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A.
A directory table is a separate database object.
A.
A directory table is a separate database object.
Answers
B.
Directory tables store data file metadata.
B.
Directory tables store data file metadata.
Answers
C.
A directory table will be automatically added to a stage.
C.
A directory table will be automatically added to a stage.
Answers
D.
Directory tables do not have their own grantable privileges.
D.
Directory tables do not have their own grantable privileges.
Answers
E.
Directory table data can not be refreshed manually.
E.
Directory table data can not be refreshed manually.
Answers
Suggested answer: B, D

Explanation:

Directory tables in Snowflake are used to store metadata about data files in a stage. They are not separate database objects but are conceptually similar to external tables.Directory tables do not have grantable privileges of their own

Question 216

Report
Export
Collapse

Which data type can store more than one type of data structure?

A.
JSON
A.
JSON
Answers
B.
BINARY
B.
BINARY
Answers
C.
VARCHAR
C.
VARCHAR
Answers
D.
VARIANT
D.
VARIANT
Answers
Suggested answer: D

Explanation:

The VARIANT data type in Snowflake can store multiple types of data structures, as it is designed to hold semi-structured data.It can contain any other data type, including OBJECT and ARRAY, which allows it to represent various data structures

Question 217

Report
Export
Collapse

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A.
Schema Stage
A.
Schema Stage
Answers
B.
User Stage
B.
User Stage
Answers
C.
Database Stage
C.
Database Stage
Answers
D.
Table Stage
D.
Table Stage
Answers
E.
External Named Stage
E.
External Named Stage
Answers
F.
Internal Named Stage
F.
Internal Named Stage
Answers
Suggested answer: B, D, F

Explanation:

The Snowflake PUT command is used to upload files from a local file system to Snowflake stages, specifically the user stage, table stage, and internal named stage.These stages are where the data files are temporarily stored before being loaded into Snowflake tables

Question 218

Report
Export
Collapse

What internal stages are available in Snowflake? (Choose three.)

A.
Schema stage
A.
Schema stage
Answers
B.
Named stage
B.
Named stage
Answers
C.
User stage
C.
User stage
Answers
D.
Stream stage
D.
Stream stage
Answers
E.
Table stage
E.
Table stage
Answers
F.
Database stage
F.
Database stage
Answers
Suggested answer: B, C, E

Explanation:

Snowflake supports three types of internal stages: Named, User, and Table stages. These stages are used for staging data files to be loaded into Snowflake tables.Schema, Stream, and Database stages are not supported as internal stages in Snowflake. References: Snowflake Documentation1.

Question 219

Report
Export
Collapse

How would a user run a multi-cluster warehouse in maximized mode?

A.
Configure the maximum clusters setting to 'Maximum.'
A.
Configure the maximum clusters setting to 'Maximum.'
Answers
B.
Turn on the additional clusters manually after starting the warehouse.
B.
Turn on the additional clusters manually after starting the warehouse.
Answers
C.
Set the minimum Clusters and maximum Clusters settings to the same value.
C.
Set the minimum Clusters and maximum Clusters settings to the same value.
Answers
D.
Set the minimum clusters and maximum clusters settings to different values.
D.
Set the minimum clusters and maximum clusters settings to different values.
Answers
Suggested answer: C

Explanation:

To run a multi-cluster warehouse in maximized mode, a user should set the minimum and maximum number of clusters to the same value.This ensures that all clusters are available when the warehouse is started, providing maximum resources for query execution. References: Snowflake Documentation2.

Question 220

Report
Export
Collapse

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

A.
SHOW STORAGE BY TABLE;
A.
SHOW STORAGE BY TABLE;
Answers
B.
SHOW TABLES;
B.
SHOW TABLES;
Answers
C.
Information Schema -> TABLE_HISTORY
C.
Information Schema -> TABLE_HISTORY
Answers
D.
Information Schema -> TABLE_FUNCTION
D.
Information Schema -> TABLE_FUNCTION
Answers
E.
Information Schema -> TABLE_STORAGE_METRICS
E.
Information Schema -> TABLE_STORAGE_METRICS
Answers
Suggested answer: A, E

Explanation:

To monitor data storage for individual tables, the commands and objects that can be used are 'SHOW STORAGE BY TABLE;' and the Information Schema view 'TABLE_STORAGE_METRICS'.These tools provide detailed information about the storage utilization for tables. References: Snowflake Documentation

Total 716 questions
Go to page: of 72
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms