nerdexam
SnowflakeSnowflake

DEA-C02 · Question #72

DEA-C02 Question #72: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.

Security and Governance

Question

A Data Engineer has been asked by the development team to create a snapshot of production data from the ABC database into the developer account. None of the data is Personal Identifiable Information (PII) or sensitive. Both accounts are in the same region and use the same cloud provider. The Engineer performs these steps: In the production account: use role accountadmin; create database ABC_CLONE clone ABC; create share ABC_SHARE; grant usage on database ABC_CLONE to share ABC_SHARE; alter share ABC_share add accounts = dev_account; In the developer account: use role accountadmin; create database ABC_DEV FROM share prod_account.ABC_SHARE; grant imported privileges on database ABC_DEV to role developers; What is the reason the development team cannot see the data in the tables in the developer account?

Options

  • AThe Data Engineer did not grant on the schema and on the tables in the
  • BThe Data Engineer did not grant to the schemas and tables in the
  • CThe Data Engineer did not grant select on the schema and tables in the share in the developer
  • DThe Data Engineer did not grant on the database in the developer account.

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Data Sharing#Snowflake Privileges#Object Hierarchy#Zero-Copy Clone
Full DEA-C02 PracticeBrowse All DEA-C02 Questions