DEA-C02 practice questions 111–120

1. Question 111 · 126 in bank

   Select 2

   A Data Engineer is using Time Travel to clone a table using this query: CREATE TABLE MY_TABLE_CLONE CLONE MY_TABLE AT (OFFSET => -60*30); An error is returned. What could be causing the error? (Choose two.)

   • AThe source object is an external table.
   • BThe object has exceeded the maximum cloning limit.
   • CTime Travel and cloning features cannot be run together.
   • DThe object cannot be cloned because it has a row access policy attached to it.
   • EThe source object did not exist at the time specified in the AT | BEFORE parameter.

   Show answer

   Answer: AE

   Next question

2. Question 112 · 126 in bank

   A Data Engineer needs to create a tag-based masking policy to determine whether data should be masked based on the value of the label string assigned to column salary in table staff. The Engineer created the tag and masking policy with these commands: USE SCHEMA governance.tags; CREATE TAG hr_col_salary; USE ROLE masking_admin; USE SCHEMA governance.masking_policies; CREATE MASKING POLICY salary_mask_tag_policy AS (val number) RETURNS number -> CASE - WHEN SYSTEM$GET_TAG_ON_CURRENT_COLUMN('tags.hr_col_salary') = 'visible' or 'payroll_admin' = current_role() THEN val ELSE -1 - END; ALTER TAG hr_col_salary SET - MASKING POLICY salary_mask_tag_policy; How should the Engineer apply the tag to ensure that only users with the payroll_admin role can access the data?

   • A//IMG//
   • B//IMG//
   • C//IMG//
   • D//IMG//

   Show answer

   Answer: A

   Next question

3. Question 113 · 126 in bank

   How can a Data Engineer return all the errors encountered during a previous file upload that used the COPY command?

   • AQuery the VALIDATE information schema view.
   • BCall the VALIDATE table function.
   • CCall the VALIDATE_PIPE_LOAD table function.
   • DQuery the VALIDATE account usage schema view.

   Show answer

   Answer: B

   Next question

4. Question 114 · 126 in bank

   Select 2

   When working with semi-structured data in a VARIANT column, which Snowflake functions will allow a user to write queries that extract values using a hierarchy name? (Choose two.)

   • AGET()
   • BPARSE_JSON()
   • CGET_PATH()
   • DLATERAL FLATTEN
   • ETO_ARRAY()

   Show answer

   Answer: AC

   Next question

5. Question 115 · 126 in bank

   A company is running several machine learning models that were developed in Scala and are running on-premises. A Data Engineer has been asked to design a solution using Snowflake. What is the FASTEST way to migrate the models to Snowflake?

   • AConvert the Scala code to SQL and create new SQL User-Defined Functions (UDFs) in Snowflake.
   • BCreate new Scala User-Defined Functions (UDFs) in Snowflake using the existing Scala code.
   • CUse Snowpark to create User-Defined Functions (UDFs) based on the existing Scala code.
   • DUse a Python function to create User-Defined Functions (UDFs) based on the existing Scala code.

   Show answer

   Answer: C

   Next question

6. Question 116 · 126 in bank

   Select 3

   A Data Engineer created table t1 and applied a projection policy, my_proj_policy to several columns:

   

   What effect will the policy have on columns account_number and account_type? (Choose three.)

   • AThe columns cannot be used to insert data into another table.
   • BThe columns will be masked and will only be visible to a defined user role.
   • CThese columns cannot pass an argument to an external function or external stored procedure.
   • DThe data in these columns will not be included in query results.
   • ETags can now be placed on these columns.
   • FThe columns cannot be used in a WHERE clause.

   Show answer

   Answer: ACD

   Next question

7. Question 117 · 126 in bank

   A retail store's application team needs to build a loyalty program for their customers. The customer table contains Personal Identifiable Information (PII), and the team members have been assigned the role DEVELOPER. CREATE TABLE customer_data ( customer_first_name string, customer_last_name string, customer_address string, customer_email string, ... some other columns, ); The team needs to access the customer data, but the email field must be obfuscated. Which solution protects the sensitive information, while maintaining the usability of the data?

   • ACreate a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view.
   • BCreate a separate table for all the non-PII columns and grant the role DEVELOPER access to the new table.
   • CUse the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.
   • DUse the CURRENT_ROLE context function to integrate with a masking policy on the sensitive fields.

   Show answer

   Answer: D

   Next question

8. Question 118 · 126 in bank

   A Data Engineer is cloning a production database for use as a development environment using these commands: USE ROLE CLONE_ADMIN; CREATE DATABASE DB_DEV CLONE DE_PROD AT (OFFSET => -1800); What must the Engineer do to ensure the cloned environment is ready to use?

   • ARun this command on all pipes in the DB_DEV to resume loading from them: ALTER PIPE SET PIPE_EXECUTION_PAUSED = FALSE;
   • BRun this command on all external stages in the DB_DEV to point them to development files: ALTER STAGE SET STORAGE_INTEGRATION = ;
   • CRun this command on all tables in the DB_DEV to revoke permissions from all production roles: GRANT OWNERSHIP ON ALL TABLES IN DATABASE DB_DEV TO ROLE CLONE_ADMIN REVOKE CURRENT GRANTS;
   • DRun this command on all tables with sequences in the DB_DEV to reattach the sequences to the cloned tables: ALTER TABLE .. ALTER COLUMN SET DEFAULT .. .NEXTVAL;

   Show answer

   Answer: A

   Next question

9. Question 119 · 126 in bank

   A table, TABLE SALES, is reloaded daily, and is used by many users to support multiple data reporting tools. Users report poor performance when querying the table. This is the clustering information for TABLE SALES: { "cluster_by_keys" : "LINEAR(SALES_DT)", "total_partition_count" : 10798, "total_constant_partition_count" : 0, "average_overlaps" : 10797.0, "average_depth" : 10798.0, "partition_depth__histogram" : { "00000" : 0, "00001" : 0, "00002" : 0, "00003" : 0, "00004" : 0, "00005" : 0, "00006" : 0, "00007" : 0, "00008" : 0, "00009" : 0, "00010" : 0, "00011" : 0, "00012" : 0, "00013" : 0, "00014" : 0, "00015" : 0, "00016" : 0, "16384" : 10798 }, "clustering_errors" : [ ] } What step will improve the performance of the micro-partitions and OPTIMIZE query performance?

   • AIncorporate additional pruning options when the table is being accessed by reporting queries.
   • BIdentify and purge duplicate data in the table.
   • CUse the ORDER BY SALES_DT parameter when inserting the data into the table.
   • DPerform a one-time insert overwrite with the ORDER BY SALES_DT parameter.

   Show answer

   Answer: D

   Next question

10. Question 120 · 126 in bank

    How can a Data Engineer track credit consumption related to the use of Data Metric Functions (DMFs)?

    • AQuery the DATABASE_STORAGE_USAGE_HISTORY table function.
    • BQuery the DATA_QUALITY_MONITORING_USAGE_HISTORY view.
    • CQuery the DATABASE_STORAGE_USAGE_HISTORY view.
    • DQuery the WAREHOUSE_METERING_HISTORY table function.

    Show answer

    Answer: B

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DEA-C02 practice, question 111. 126 questions available.