ExamGecko
Home / Snowflake / DEA-C01
Ask Question

Snowflake DEA-C01 Practice Test - Questions Answers, Page 11

Question list
Search

Question 101

Report
Export
Collapse

Which one is not the Core benefits of micro-partitioning

Become a Premium Member for full access
  Unlock Premium Member

Question 102

Report
Export
Collapse

Select the incorrect statements regarding Clustering depth?

Become a Premium Member for full access
  Unlock Premium Member

Question 103

Report
Export
Collapse

To view/monitor the clustering metadata for a table, Snowflake provides which of the following system functions?

Become a Premium Member for full access
  Unlock Premium Member

Question 104

Report
Export
Collapse

Which ones are the false statements about Materialized Views?

Become a Premium Member for full access
  Unlock Premium Member

Question 105

Report
Export
Collapse

Charles, A Lead Data engineer, with ACCOUNTADMIN role wants to configure the time travel for one of the Schema's object. He setup the MIN_DATA_RETENTION_TIME_IN_DAYS pa-rameter with Value 79 at account level but he figured out that DA-TA_RETENTION_TIME_IN_DAYS is already set with value 81 at account level. What would be the effective minimum data retention period for an object?

Become a Premium Member for full access
  Unlock Premium Member

Question 106

Report
Export
Collapse

Changing the retention period for your account or individual objects changes the value for all lowerlevel objects that do not have a retention period explicitly set?

Become a Premium Member for full access
  Unlock Premium Member

Question 107

Report
Export
Collapse

In efforts to recover the dropped child tables within schema named SCV_SCHEMA by Data Engi-neer, She found that DATA_RETENTION_TIME_IN_DAYS parameter set with value 45 days at Schema level & the data retention period for child tables explicitly set at 85 days. What will happen when she will try to run undrop table command on Child tables to recover them on the 50th day as-suming SCV_SCHEMA is already dropped on 45th day?

Become a Premium Member for full access
  Unlock Premium Member

Question 108

Report
Export
Collapse

To support Time Travel, Which of the following SQL extensions/parameters/commands have been implemented?

Become a Premium Member for full access
  Unlock Premium Member

Question 109

Report
Export
Collapse

The following CREATE DATABASE command creates a clone of a database snowmy_db i.e.

Create database pods_db clone snowmy_db before (statement => '7e5d0cb9-005e-94e6-b058-k8f5b37c5725'); What are possible reason of failing cloning operation for this database?

Become a Premium Member for full access
  Unlock Premium Member

Question 110

Report
Export
Collapse

Which of the following statements is/are incorrect regarding Fail-safe data recovery?

Become a Premium Member for full access
  Unlock Premium Member
Total 130 questions
Go to page: of 13