ExamGecko
Login
Home / Snowflake / COF-C02 / List of questions
Ask Question

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

List of questions

Question 211

Report Export Collapse

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

Schemas
Schemas
Roles
Roles
Secure Views
Secure Views
Stored Procedures
Stored Procedures
Tables
Tables
Secure User-Defined Functions (UDFs)
Secure User-Defined Functions (UDFs)
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.

asked 23/09/2024
IOSSIF ZINGUER
54 questions

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?

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 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 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 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.
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.
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

asked 23/09/2024
Ryan Shannon
43 questions

Question 213

Report Export Collapse

Which statement describes how Snowflake supports reader accounts?

A reader account can consume data from the provider account that created it and combine it with its own data.
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.
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 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.
The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
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.

asked 23/09/2024
Tom Bodett
40 questions

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?

USERADMIN
USERADMIN
PUBLIC
PUBLIC
ORGADMIN
ORGADMIN
SYSADMIN
SYSADMIN
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

asked 23/09/2024
Wasawatt Ch
42 questions

Question 215

Report Export Collapse

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

A directory table is a separate database object.
A directory table is a separate database object.
Directory tables store data file metadata.
Directory tables store data file metadata.
A directory table will be automatically added to a stage.
A directory table will be automatically added to a stage.
Directory tables do not have their own grantable privileges.
Directory tables do not have their own grantable privileges.
Directory table data can not be refreshed manually.
Directory table data can not be refreshed manually.
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

asked 23/09/2024
Daniel Vong
46 questions

Question 216

Report Export Collapse

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

JSON
JSON
BINARY
BINARY
VARCHAR
VARCHAR
VARIANT
VARIANT
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

asked 23/09/2024
Lukasz Malaczek
36 questions

Question 217

Report Export Collapse

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

Schema Stage
Schema Stage
User Stage
User Stage
Database Stage
Database Stage
Table Stage
Table Stage
External Named Stage
External Named Stage
Internal Named Stage
Internal Named Stage
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

asked 23/09/2024
Gustavo Castro
41 questions

Question 218

Report Export Collapse

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

Schema stage
Schema stage
Named stage
Named stage
User stage
User stage
Stream stage
Stream stage
Table stage
Table stage
Database stage
Database stage
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.

asked 23/09/2024
Sean Kell
46 questions

Question 219

Report Export Collapse

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

Configure the maximum clusters setting to 'Maximum.'
Configure the maximum clusters setting to 'Maximum.'
Turn on the additional clusters manually after starting the warehouse.
Turn on the additional clusters manually after starting the warehouse.
Set the minimum Clusters and maximum Clusters settings to the same value.
Set the minimum Clusters and maximum Clusters settings to the same value.
Set the minimum clusters and maximum clusters settings to different values.
Set the minimum clusters and maximum clusters settings to different values.
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.

asked 23/09/2024
Misael Mosco Jiménez
43 questions

Question 220

Report Export Collapse

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

SHOW STORAGE BY TABLE;
SHOW STORAGE BY TABLE;
SHOW TABLES;
SHOW TABLES;
Information Schema -> TABLE_HISTORY
Information Schema -> TABLE_HISTORY
Information Schema -> TABLE_FUNCTION
Information Schema -> TABLE_FUNCTION
Information Schema -> TABLE_STORAGE_METRICS
Information Schema -> TABLE_STORAGE_METRICS
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

asked 23/09/2024
Nelson G Porras
47 questions
Total 716 questions
Go to page: of 72
Open VPLUS File
Convert VPLUS to PDF

Related questions

How can the outer array structure of a semi-structured file be removed?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
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?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
How does the search optimization service improve query performance?
What is a key feature of Snowflake architecture?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).