DEA-C02 practice questions 121–126

1. Question 121 · 126 in bank

   A Data Engineer is investigating a data quality issue that led to a system failure. Because there is no data from the time of the incident, the Engineer needs replicate the issue, without causing any disruptions to the current operations. How can a safe environment for testing be established without incurring additional costs?

   • AUse Time Travel to restore the data back to the way it was just before the incident occurred.
   • BCreate an empty table using a CREATE TABLE LIKE command and insert the historic data into this table using data from Time Travel. Use this table for testing.
   • CCreate a view using the historic Time Travel data and use this view to test the data.
   • DCreate a clone of the data using the historic Time Travel data and use the clone to test the data.

   Show answer

   Answer: D

   Next question

2. Question 122 · 126 in bank

   Use of what Snowflake Continuous Data Protection (CDP) feature will consume compute credits?

   • ACreating zero-copy clones
   • BEnabling Multi-Factor Authentication (MFA)
   • CUsing Role-Based Access Control (RBAC)
   • DRetrieval of data from Fail-safe

   Show answer

   Answer: D

   Next question

3. Question 123 · 126 in bank

   A Data Engineer is designing a solution that will send report files generated and stored in a Snowflake stage to a customer, using email. The files can only be available for download for 60 minutes as new files will be generated and the old ones become obsolete. What is the recommended way to meet these requirements?

   • AShare data using a scoped URL and the SYSTEM$SEND_EMAIL function.
   • BShare data using pre-signed URL and the SYSTEM$SEND_EMAIL function.
   • CShare data using a stage file URL and the SYSTEM$SEND_EMAIL function.
   • DShare data using a scoped URL and write a custom Python script to send the email.

   Show answer

   Answer: B

   Next question

4. Question 124 · 126 in bank

   A Data Engineer needs to monitor a continuous data pipeline that is processing data. The data is ingested into Snowflake using a pipe from an Amazon S3 bucket, then it is transformed using a series of tasks and streams. The pipeline provides notifications if there is a failure during data importation. How should the Engineer add a notification signaling that there is a failure of a task involved with data transformations?

   • ACreate a queue-type error integration and assign it to this root task: CREATE INTEGRATION my_error_notify TYPE = QUEUE - ENABLED = TRUE - DIRECTION = OUTBOUND - NOTIFICATION-PROVIDER = AWS_SNS - AWS_SNS_TOPIC_ARN = 'arn:aws:sns:us-east-2:111122223333:my_topic' AWS_SNS_ROLE_ARN = 'arn:aws:iam::111122223333:role/error_sns_role'; ALTER TASK order_start SET ERROR_INTEGRATION = my_error_notify;
   • BCreate a Snowflake alert and assign it to this root task: CREATE ALERT pipeline_failure - WAREHOUSE = MY_WH - NOTIFY = my_user1, my_user2; ALTER TASK order_start - set ERROR_INTEGRATION = pipeline_failure;
   • CCreate an email notification and assign it to this root task: CREATE NOTIFICATION INTEGRATION my_email_notify TYPE = EMAIL - ENABLED = TRUE - DEFAULT RECIPIENTS = ('[email protected]'); ALTER TASK order_start - set NOTIFICATION_INTEGRATION = my_email_notify;
   • DCreate a queue notification integration error and assign it to this root task: CREATE NOTIFICATION INTEGRATION mv_error_notify TYPE = QUEUE - ENABLED = TRUE - DIRECTION = OUTBOUND - NOTIFICATION_PROVIDER = AWS_SNS - AWS_SNS_TOPIC_ARN = 'am:aws:sns:us-east-2:111122223333:my_topic' AWS_SNS_ROLE_ARN = 'arn:aws:iam::111122223333:role/error sns role'; ALTER TASK order_start SET ERROR_INTEGRATION = my_error_notify;

   Show answer

   Answer: D

   Next question

5. Question 125 · 126 in bank

   A Data Engineer is supporting a security audit and needs to identify all tables accessed by USER1 in the last month. What query can be used to meet this requirement?

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

   Show answer

   Answer: A

   Next question

6. Question 126 · 126 in bank

   A Data Engineer needs to rewrite SQL code into Snowpark code using the Snowpark Python API. Data is stored in a DataFrame, df_orders. How can this SQL query be rewritten so that it will run in Snowpark?

   

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

   Show answer

   Answer: A

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

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