SnowPro Advanced Data Engineer DEA-C02

Review 65 SNOWPRO-ADVANCED-DATA-ENGINEER-DEA-C02 practice questions with answer explanations and community insights.

Question 1

A table is loaded using Snowpipe and truncated afterwards. Later, a Data Engineer finds that the table needs to be reloaded, but the metadata of the pipe will not allow the same files to be loaded again. How can this issue be solved using the LEAST amount of operational overhead?

  1. Wait until the metadata expires and then reload the file using Snowpipe.
  2. Modify the file by adding a blank row to the bottom and re-stage the file.
  3. Set the FORCE=TRUE option in the Snowpipe COPY INTO command.
  4. Recreate the pipe by using the CREATE OR REPLACE PIPE command.

Question 2

A company using Snowflake works with a third party that provides economic data. The third-party provider recently moved their data to Snowflake. How can the company access the third-party data in Snowflake with the LEAST amount of operational overhead?

  1. Have the data provider enable database replication so the company can create a replica of the provider's database.
  2. Have the data provider create a share object and add the company's Snowflake account to the share.
  3. Have the data provider create a listing on the Snowflake Marketplace so the company can request access to the data.
  4. Have the data provider create a new user and role specifically for the company so the company can log into the data provider's Snowflake account to access the data.

Question 3

A Data Engineer made modifications to staged files and re-staged them. A pipe is running but the changed data is not appearing in the table. What step should the Engineer take in order to see the changed data without duplicating data?

  1. Run the CREATE or REPLACE pipe syntax.
  2. Re-run the pipe by using the RELOAD PIPE syntax.
  3. Re-run the pipe by using the ONLY_CHANGES syntax.
  4. Create new files with the changed data.

Question 4

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

  1. Query the VALIDATE information schema view.
  2. Call the VALIDATE table function.
  3. Call the VALIDATE_PIPE_LOAD table function.
  4. Query the VALIDATE account usage schema view.

Question 5

A company called IOŠ¢ Corporation has subsidiary companies in Germany and Japan. The German subsidiary has a Snowflake account called IOTGER in AWS region EU (Frankfurt) (Region ID: eu-central-1). The Japanese subsidiary has a Snowflake account called IOTJPN in Azure region Japan East (Tokyo) (Region ID: japaneast). The subsidiaries are totally independent of one another, and their Snowflake accounts belong to different Snowflake organizations. A Data Engineer needs to share data in a database called IOT PROD from the German account to the Japanese account. What steps need to be taken by the German subsidiary so that the Japanese subsidiary can use the shared data?

  1. Create share S1 into IOTGER. Add the objects to be shared from IOT_PROD in IOTGER to the share S1, then add account IOTJPN to the share S1.
  2. Replicate database IOT_PROD from IOTGER to IOTJPN with the same database name. Create share S1 into IOTJPN, add the objects to be shared from IOTPROD in IOTJPN to the share S1, and add account IOTJPN to the share S1.
  3. Create a clone of the database IOT_PROD into IOTJPN. Create secure views into the cloned database that read data from the objects to be shared. Create share S1 into IOTJPN. Add the secure views to the share S1, and add account IOTJPN to the share S1.
  4. Create an additional Snowflake account IOTGER2 into region Japan East. Replicate database IOT_PROD from IOTGER to IOTGER2 with the same database name. Create share S1 into IOTGER2, and add the objects to be shared from IOT_PROD in IOTGER2 to the share S1. Then add account IOTJPN to the share S1.