ExamGecko
Home / Snowflake / COF-R02
Ask Question

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

Question list
Search

Question 101

Report
Export
Collapse

Which of the following objects can be shared through secure data sharing?

Masking policy
Masking policy
Stored procedure
Stored procedure
Task
Task
External table
External table
Suggested answer: D

Explanation:

Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:

Tables

External tables

Secure views

Secure materialized views

Secure UDFs

Snowflake enables the sharing of databases through shares, which are created by data providers and “imported” by data consumers.

https://docs.snowflake.com/en/user-guide/data-sharingintro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables

asked 23/09/2024
Sander Verheijen
36 questions

Question 102

Report
Export
Collapse

Which of the following commands cannot be used within a reader account?

CREATE SHARE
CREATE SHARE
ALTER WAREHOUSE
ALTER WAREHOUSE
DROP ROLE
DROP ROLE
SHOW SCHEMAS
SHOW SCHEMAS
DESCRBE TABLE
DESCRBE TABLE
Suggested answer: B

Explanation:

A reader account is intended primarily for querying data shared by the provider of the account.

Adding new data to the account and/or updating shared data in the account is not supported.

Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.

asked 23/09/2024
Susan Brady
47 questions

Question 103

Report
Export
Collapse

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

list @mytable;
list @mytable;
list @%raytable;
list @%raytable;
list @ %m.ystage;
list @ %m.ystage;
list @mystage;
list @mystage;
Suggested answer: D
asked 23/09/2024
JP Brune
39 questions

Question 104

Report
Export
Collapse

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure
Customer-managed encryption keys through Tri-Secret Secure
Automatic encryption of all data
Automatic encryption of all data
Up to 90 days of data recovery through Time Travel
Up to 90 days of data recovery through Time Travel
Object-level access control
Object-level access control
Column-level security to apply data masking policies to tables and views
Column-level security to apply data masking policies to tables and views
Suggested answer: B, D

Explanation:

https://docs.snowflake.com/en/user-guide/intro-editions.html

asked 23/09/2024
Ioana Mihaila
49 questions

Question 105

Report
Export
Collapse

Which command is used to unload data from a Snowflake table into a file in a stage?

COPY INTO
COPY INTO
GET
GET
WRITE
WRITE
EXTRACT INTO
EXTRACT INTO
Suggested answer: A

Explanation:

https://docs.snowflake.com/en/user-guide/data-unloadsnowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.

asked 23/09/2024
Aimé Tameti
42 questions

Question 106

Report
Export
Collapse

How often are encryption keys automatically rotated by Snowflake?

30 Days
30 Days
60 Days
60 Days
90 Days
90 Days
365 Days
365 Days
Suggested answer: A

Explanation:

All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.

https://docs.snowflake.com/en/user-guide/security-encryptionmanage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is%20automatically%20destroyed.

asked 23/09/2024
Easwari Lakshminarayanan
43 questions

Question 107

Report
Export
Collapse

What are value types that a VARIANT column can store? (Select TWO)

STRUCT
STRUCT
OBJECT
OBJECT
BINARY
BINARY
ARRAY
ARRAY
CLOB
CLOB
Suggested answer: B, D

Explanation:

Characteristics of a VARIANT

A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

asked 23/09/2024
Saley SEINI
34 questions

Question 108

Report
Export
Collapse

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

Create a task that runs a copy into operation from an external stage every 5 minutes
Create a task that runs a copy into operation from an external stage every 5 minutes
Create a task that puts the files in an internal stage and automate the data loading wizard
Create a task that puts the files in an internal stage and automate the data loading wizard
Create a task that runs a GET operation to intermittently check for new files
Create a task that runs a GET operation to intermittently check for new files
Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
Suggested answer: D

Explanation:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

asked 23/09/2024
Shafqat Balouch
29 questions

Question 109

Report
Export
Collapse

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 25 MB or smaller.
Load files that are approximately 25 MB or smaller.
Remove all dates and timestamps.
Remove all dates and timestamps.
Load files that are approximately 100-250 MB (or larger)
Load files that are approximately 100-250 MB (or larger)
Avoid using embedded characters such as commas for numeric data types
Avoid using embedded characters such as commas for numeric data types
Remove semi-structured data types
Remove semi-structured data types
Suggested answer: C, D

Explanation:

https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

asked 23/09/2024
Alex Agenjo Fernandez
26 questions

Question 110

Report
Export
Collapse

A user has 10 files in a stage containing new customer dat a. The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

All data from all of the files on the stage will be appended to the table
All data from all of the files on the stage will be appended to the table
Only data about new customers from the new files will be appended to the table
Only data about new customers from the new files will be appended to the table
The operation will fail with the error uncertain files in stage.
The operation will fail with the error uncertain files in stage.
All data from only the newly-added files will be appended to the table.
All data from only the newly-added files will be appended to the table.
Suggested answer: A
asked 23/09/2024
David Llamas Ampudia
32 questions
Total 330 questions
Go to page: of 33