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

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

Add to Whishlist

List of questions

Question 101

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 102

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 104

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 105

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 106

Report Export Collapse

How often are encryption keys automatically rotated by Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 107

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 109

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

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?

Become a Premium Member for full access
  Unlock Premium Member
Total 330 questions
Go to page: of 33
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
What is the default character set used when loading CSV files into Snowflake?
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Which of the following terms best describes Snowflake’s database architecture?
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
What are the three layers that make up Snowflake’s architecture? Choose 3 answer