DEA-C01 Snowflake SnowPro Advanced: Data Engineer Certification Exam exact Exam Questions

SnowPro Advanced: Data Engineer Certification Exam

Last Update 22 hours ago Total Questions : 65

The SnowPro Advanced: Data Engineer Certification Exam content is now fully updated, with all current exam questions added 22 hours ago. Deciding to include DEA-C01 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our DEA-C01 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these DEA-C01 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Advanced: Data Engineer Certification Exam practice test comfortably within the allotted time.

Question # 4

Which are the Cloud Platforms that Support Calling an External Function?

GCP

AWS & AZURE

AWS only

AWS,GCP,AZURE

Question # 5

To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards?

He can choose to remove stage files during data loading (using the COPY INTO

command).

Files no longer needed, can be removed using the PURGE=TRUE command.

Files no longer needed, can be removed using the REMOVE command.

Script can be used during data loading & post data loading with DELETE command.

command.

· After the load completes, use the REMOVE command to remove the files in the stage.

Removing files ensures they aren’t inadvertently loaded again. It also improves load performance, because it reduces the number of files that COPY commands must scan to verify whether existing files in a stage were loaded already.

Question # 6

Which one is not the Core benefits of micro-partitioning

Snowflake micro-partitions are derived automatically they do not need to be explicitly defined up-front or maintained by users.

Enables extremely efficient DML and fine-grained pruning for faster queries.

Micro-partitions can overlap in their range of values, helps data skewing.

Columns are stored independently within micro-partitions, often referred to as colum-nar storage.

Columns are also compressed individually within micro-partitions.

Question # 7

Charles, A Lead Data engineer, with ACCOUNTADMIN role wants to configure the time travel for one of the Schema’s object. He setup the MIN_DATA_RETENTION_TIME_IN_DAYS pa-rameter with Value 79 at account level but he figured out that DA-TA_RETENTION_TIME_IN_DAYS is already set with value 81 at account level. What would be the effective minimum data retention period for an object?

There is no such MIN_DATA_RETENTION_TIME_IN_DAYS parameter

Question # 8

Mark the incorrect statement when Data Engineer implement Automating Continuous Data Loading Using Cloud Messaging?

Automated Snowpipe uses event notifications to determine when new files arrive in monitored cloud storage and are ready to load.

When a pipe is paused, event messages received for the pipe enter a limited retention period. The period is 14 days by default. If a pipe is paused for longer than 14 days, it is considered stale.

Notifications identify the cloud storage event and include a list of the file names. They do not include the actual data in the files.

Triggering automated Snowpipe data loads using S3 event messages is supported by Snowflake accounts hosted on Cloud Platform like AWS, GCP or AZURE.

Question # 9

Bob, a Lead Data Engineer is looking out to get the function definition & queried below statement to check if this function is secure enough to use in his script or not.

select is_secure from information_schema.functions where function_name = 'JOHNFUNCTION';

From the query output he is sure that, Function is secure UDF, what are the way provided by snow-flake to get the function definition of secure UDF?

He can get the secure UDF definition using GET_DDL utility function.

UDF definition or text, is visible to users via Query Profile (in the web interface).

SHOW FUNCTIONS Commands

Declaring a UDF as “secure” hide the definition from Bob & all the required Definition commands will throw error.

Question # 10

Snowflake web interface can be used to create users with no passwords or remove passwords from existing users?

TRUE

FALSE