ExamGecko
Home / Snowflake / DEA-C01
Ask Question

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

Question list
Search

List of questions

Search

Question 41

Report
Export
Collapse

SYSTEM$CLUSTERING_INFORMATION functions returns clustering information, including average clustering depth, for a table based on one or more columns in the table. The function returns a JSON object containing average_overlaps name/value pairs. Does High average_overlaps indicates well organized Clustering?

YES
YES
NO
NO
Suggested answer: B

Explanation:

Higher the avg_overlap indicates poorly organized clustering.

asked 23/09/2024
Daniel Yontz
44 questions

Question 42

Report
Export
Collapse

The smaller the average depth, the better clustered the table is with regards to the specified column?

TRUE
TRUE
FALSE
FALSE
Suggested answer: A
asked 23/09/2024
Tobi Space
39 questions

Question 43

Report
Export
Collapse

Data Engineer, ran the below clustering depth analysis function:

select system$clustering_depth('TPCH_CUSTOMERS', '(C1, C6)', 'C9 = 30'); on TPCH_CUSTOMERS table, will return which of the following?

An error: this function does not accept lists of columns as a third parameter.
An error: this function does not accept lists of columns as a third parameter.
An error: this function does not accept predicates ('C9 = 30') as parameter.
An error: this function does not accept predicates ('C9 = 30') as parameter.
Calculate the clustering depth for a table using mentioned columns in the table.
Calculate the clustering depth for a table using mentioned columns in the table.
Calculate the clustering depth for a table using the clustering key defined for the table.
Calculate the clustering depth for a table using the clustering key defined for the table.
Suggested answer: C
asked 23/09/2024
Thuy Nguyen
32 questions

Question 44

Report
Export
Collapse

Mark the Correct Statements:

Statement 1. Snowflake's zero-copy cloning feature provides a convenient way to quickly take a "snapshot" of any table, schema, or database.

Statement 2. Data Engineer can use zero-copy cloning feature for creating instant backups that do not incur any additional costs (until changes are made to the cloned object).

Statement 1
Statement 1
Statement 2
Statement 2
Both are False.
Both are False.
Statement 1 & 2 are correct.
Statement 1 & 2 are correct.
Suggested answer: C

Explanation:

Snowflake's zero-copy cloning feature provides a convenient way to quickly take a "snapshot" of any table, schema, or database and create a derived copy of that object which initially shares the underlying storage. This can be extremely useful for creating instant backups that do not incur any additional costs (until changes are made to the cloned object).

For example, when a clone is created of a table, the clone utilizes no data storage because it shares all the existing micro-partitions of the original table at the time it was cloned; however, rows can then be added, deleted, or updated in the clone independently from the original table. Each change to the clone results in new micro-partitions that are owned exclusively by the clone and are protected through CDP.

asked 23/09/2024
Ian Wilson
45 questions

Question 45

Report
Export
Collapse

Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?

TRUE
TRUE
FALSE
FALSE
Suggested answer: A
asked 23/09/2024
mostafa badawi
43 questions

Question 46

Report
Export
Collapse

Mark the Correct Statements:

Statement 1. Enable failover for a primary database to one or more accounts in your organization using an ALTER DATABASE … ENABLE FAILOVER TO ACCOUNTS statement.

Statement 2. Enabling failover for a primary database can be done by Data Engineer either before or after a replica of the primary database has been created in a specified account.

Statement 1
Statement 1
Statement 2
Statement 2
Both are False.
Both are False.
Both are Correct.
Both are Correct.
Suggested answer: D
asked 23/09/2024
Bas Vogel
41 questions

Question 47

Report
Export
Collapse

Which Role inherits the privileges of the USERADMIN role via the system role hierarchy?

SYSADMIN
SYSADMIN
SECURITYADMIN
SECURITYADMIN
PUBLIC
PUBLIC
CUSTOM ROLE
CUSTOM ROLE
Suggested answer: B
asked 23/09/2024
Tuukka Valkeasuo
33 questions

Question 48

Report
Export
Collapse

Which privilege are required on an object (i.e. user or role) with USERADMIN Role can modify the object properties?

OPEARTE
OPEARTE
MANAGE GRANTS
MANAGE GRANTS
OWNERSHIP
OWNERSHIP
MODIFY
MODIFY
Suggested answer: C
asked 23/09/2024
Nicholas Roy
43 questions

Question 49

Report
Export
Collapse

Does sensitive data in Snowflake is modified in an existing table while applying Masking policies?

YES
YES
NO
NO
Suggested answer: B

Explanation:

Snowflake supports masking policies as a schema-level object to protect sensitive data from unauthorized access while allowing authorized users to access sensitive data at query runtime. This means that sensitive data in Snowflake is not modified in an existing table (i.e. no static masking).

Rather, when users execute a query in which a masking policy applies, the masking policy condi-tions determine whether unauthorized users see masked, partially masked, obfuscated, or tokenized data.

asked 23/09/2024
Meghan Crofford
39 questions

Question 50

Report
Export
Collapse

Can Masking policies be applied to virtual columns?

TRUE
TRUE
FALSE
FALSE
Suggested answer: B
asked 23/09/2024
AMMAR SHEIKH SALEH
33 questions
Total 130 questions
Go to page: of 13