Snowflake DEA-C01 SnowPro Advanced Data Engineer Certification Online Training
Snowflake DEA-C01 Online Training
The questions for DEA-C01 were last updated at Jan 05,2025.
- Exam Code: DEA-C01
- Exam Name: SnowPro Advanced Data Engineer Certification
- Certification Provider: Snowflake
- Latest update: Jan 05,2025
Ryan, a Data Engineer, accidently drop the Share named SF_SHARE which results in immediate access revoke for all the consumers (i.e., accounts who have created a database from that SF_SHARE).
What action he can take to recover the dropped Share?
- A . By Executing UNDROP command he could possibly recover the dropped Share SF_SHARE & its associated Databases for immediate consumer access.
- B . He can recreate a share with the same name as a previous share which does restore the databases created (by any consumers) from the share SF_SHARE.
- C . A dropped share cannot be restored. The share must be created again using the CRE-ATE SHARE command and then configured using GRANT <privilege> … TO SHARE and ALTER SHARE.
- D . Consumer accounts that have created databases from the share will still be able to query these databases as Share is separate securable object & it’s still accessible using time travel feature.
For enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks, which two glob-al/account privileges snowflake provide?
- A . CREATE SHARE
- B . IMPORT SHARE
- C . REFERENCE USAGE
- D . OPERATE
Mark the correct Statements with respect to Secure views & its creation in the SnowFlake Account?
- A . For a secure view, internal optimizations can indirectly expose data & the view definition is visible to other users.
- B . Secure views should not be used for views that are defined solely for query convenience, such as views created to simplify queries for which users do not need to under-stand the underlying data representation.
- C . To convert an existing view to a secure view and back to a regular view, set/unset the SECURE keyword in the ALTER VIEW or ALTER MATERIALIZED VIEW command.
- D . For non-materialized views, the IS_SECURE column in the Information Schema and Account Usage views identifies whether a view is secure.
- E . The internals of a secure view are not exposed in Query Profile (in the web interface). This is the case even for the owner of the secure view, because non-owners might have access to an owner’s Query Profile.
When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions?
- A . FALSE
- B . TRUE
Snowflake computes and adds partitions based on the defined partition column expressions when an external table metadata is refreshed.
What are the Correct Statements to configure Partition metadata refresh in case of External Tables?
- A . By default, the metadata is refreshed automatically when the object is created.
- B . The object owner can configure the metadata to refresh automatically when new or updated data files are available in the external stage.
- C . Metadata refresh is not required as its Managed implicitly by Snowflake.
- D . Partitions of External tables is managed by External Stage Cloud provider.
- E . There is nothing like adding partitions on External tables.
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
- A . TRUE
- B . FALSE
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
- A . TRUE
- B . FALSE
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
- A . TRUE
- B . FALSE
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
- A . TRUE
- B . FALSE
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
- A . TRUE
- B . FALSE
Latest DEA-C01 Dumps Valid Version with 100 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
