Home / Snowflake / DEA-C01

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

Question list

List of questions

Question 101

(0)

Which one is not the Core benefits of micro-partitioning

Question 102

(0)

Select the incorrect statements regarding Clustering depth?

Question 103

(0)

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

Question 104

(0)

Which ones are the false statements about Materialized Views?

Question 105

(0)

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 acco

Question 106

(0)

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?

Question 107

(0)

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

Question 108

(0)

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

Question 109

(0)

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

Question 110

(0)

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

Question 101

Which one is not the Core benefits of micro-partitioning

Snowflake micro-partitions are derived automatically they do not need to be explicitly defined upfront or maintained by users.

Enables extremely efficient DML and fine-grained pruning for faster queries.

Micro-partitions can overlap in their range of values, helps data skewing.

Columns are stored independently within micro-partitions, often referred to as colum-nar storage.

Columns are also compressed individually within micro-partitions.

Show Answer Comment (0)

Question 102

Select the incorrect statements regarding Clustering depth?

The clustering depth for a populated table measures the average depth (1 or greater) of the overlapping micro-partitions for specified columns in a table. The smaller the aver-age depth, the better clustered the table is with regards to the specified columns.

It helps Monitoring the clustering "health" of a large table, particularly over time as DML is performed on the table.

Clustering depth can be used for determining whether a large table would benefit from explicitly defining a clustering key.

A table with no micro-partitions (i.e. an unpopulated/empty table) has a clustering depth of 1.(Correct)

Show Answer Comment (0)

Question 103

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

SYSTEM$CLUSTERING_DEPTH_KEY

SYSTEM$CLUSTERING_KEY_INFORMATION (including clustering depth)

SYSTEM$CLUSTERING_DEPTH

SYSTEM$CLUSTERING_INFORMATION (including clustering depth)

Show Answer Comment (0)

Question 104

Which ones are the false statements about Materialized Views?

Snowflake does not allow standard DML (e.g. INSERT, UPDATE, DELETE) on ma-terialized views.

Snowflake does not allow users to truncate materialized views.

Materialized views are first-class account objects.

A materialized view can also be used as the data source for a subquery.

Materialized views can be secure views.

Clustering a subset of the materialized views on a table tends to be more cost-effective than clustering the table itself.

Show Answer Comment (0)

Question 105

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?

There is no such MIN_DATA_RETENTION_TIME_IN_DAYS parameter

Show Answer Comment (0)

Question 106

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?

TRUE

FALSE

Show Answer Comment (0)

Question 107

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?

To honor the data retention period for child tables, She will ab able to recover the child tables on 50th day as DATA_RETENTION_TIME_IN_DAYS is explicitly set with higher retention value.

When a schema is already dropped, the data retention period for child tables, if explicit-ly set to be different from the retention of the schema, is not honoured. So UNDROP command will fail to run on 50th day for Child tables recovery.

Child tables can be recovered using Fail-Safe SQL commands.

Data Engineer needs to first recover the Schema & then Child tables will automatically be recovered irrespective of Retention Inheritance.

Show Answer Comment (0)

Question 108

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

AT | BEFORE clause which can be specified in the CREATE … CLONE commands.

ONSET (time difference in seconds from the present time)

OFFSET (time difference in seconds from the present time)

STATEMENT_ID (identifier for statement, e.g. query ID)

STATEMENT (identifier for statement, e.g. query ID)

UNDROP command for tables, schemas, and databases.

Show Answer Comment (0)

Question 109

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?

Time Travel Statement query time is beyond the retention time of few current child (e.g., a table) of the Database entity.

Time Travel Statement query time is at or before the point in time when the object was created.

CREATE DATABASE query fails due to compilation error as it do not support state-ment keyword.

SQL Compilation error: "Incorrect Syntax 'before' while creating database"

Show Answer Comment (0)

Question 110

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

Data stored in temporary tables is not recoverable after the table is dropped as they do not have fail-safe.

Historical data in transient tables can be recovered by Snowflake due to Operation fail-ure after the Time Travel retention period ends using Fail-safe.

Long-lived tables, such as fact tables, should always be defined as permanent to ensure they are fully protected by Fail-safe.

Short-lived tables (i.e. <1 day), such as ETL work tables, can be defined as transient to eliminate Fail-safe costs.

If downtime and the time required to reload lost data are factors, permanent tables, even with their added Fail-safe costs, may offer a better overall solution than transient tables.

Show Answer Comment (0)

Total 130 questions