Free SnowPro Advanced: Data Engineer Certification Exam Practice Questions

Question # 21

How Data Engineer can do Monitoring of Files which are Staged Internally during Continuous data pipelines loading process? [Select all that apply]

Options:

She Can Monitor the files using Metadata maintained by Snowflake i.e. file-name,last_modified date etc.

Snowflake retains historical data for COPY INTO commands executed within the pre-vious 14 days.

She can Monitor the status of each COPY INTO

command on the History tab page of the classic web interface.

She can use the DATA_LOAD_HISTORY Information Schema view to retrieve the history of data loaded into tables using the COPY INTO command.

She can use the DATA_VALIDATE function to validate the data files She have loaded and can retrieve any errors encountered during the load.

Discussion 0

command on the History tab page of the classic web interface.

· Use the VALIDATE function to validate the data files you’ve loaded and retrieve any errors en-countered during the load.

· Use the LOAD_HISTORY Information Schema view to retrieve the history of data loaded into tables using the COPY INTO command.

Question # 22

Melissa, Senior Data Engineer, looking out to optimize query performance for one of the Critical Control Dashboard, she found that most of the searches by the users on the control dashboards are based on Equality search on all the underlying columns mostly. Which Best techniques she should consider here?

Options:

She can go for clustering on underlying tables which can speedup Equality searches.

A materialized view speeds both equality searches and range searches.

The search optimization service would best fit here as it can be applied to all underlying columns & speeds up equality searches.

(Correct)

Melissa can create Indexes & Hints on the searchable columns to speed up Equality search.

Discussion 0

Question # 23

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?

Options:

By Executing UNDROP command he could possibly recover the dropped Share SF_SHARE & its associated Databases for immediate consumer access.

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_SHAR

A dropped share cannot be restored. The share must be created again using the CRE-ATE SHARE command and then configured using GRANT … TO SHARE and ALTER SHAR

Consumer accounts that have created databases from the share will still be able to que-ry these databases as Share is separate securable object & it’s still accessible using time travel feature.

Discussion 0

Question # 24

To view/monitor the clustering metadata for a table, Snowflake provides which of the following system functions?

Options:

SYSTEM$CLUSTERING_DEPTH_KEY

SYSTEM$CLUSTERING_KEY_INFORMATION (including clustering depth)

SYSTEM$CLUSTERING_DEPTH

SYSTEM$CLUSTERING_INFORMATION (including clustering depth)

Discussion 0

Question # 25

Select the Incorrect statement about External Functions in SnowFlake?

Options:

An external function is a type of UD

An external function does not contain its own code; instead, the external function calls code that is stored and executed outside Snowflake.

Inside Snowflake, the external function is stored as a API Integration object.

Inside Snowflake, the external function is stored as a database object that contains in-formation that Snowflake uses to call the remote service.

Discussion 0

Question # 26

Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?

Options:

SYSTEM$TASK_DEPENDENTS

SYSTEM$TASK_DEPENDENTS_ENABLE

SYSTEM$TASK_DEPENDENTS_RESUME

SYSTEM$TASK_RECURSIVE_ENABLE

Discussion 0

Question # 27

The Snowpipe API provides REST endpoints for fetching load reports. One of the Endpoint named insertReport helps to retrieves a report of files submitted via insertFiles end point whose contents were recently ingested into a table. A success response (200) contains information about files that have recently been added to the table. Response Looks like below:

1.{

2."pipe": "SNOWTESTD

SFTESTSCHEM

SFpipe",

3."completeResult": true,

4."nextBeginMark": "1_16",

5."files": [

6.{

7."path": "data4859992083898.csv",

8."stageLocation": "s3://mybucket/",

9."fileSize": 89,

10."timeReceived": "2022-01-31T04:47:41.453Z",

11."lastInsertTime": "2022-01-31T04:48:28.575Z",

12."rowsInserted": 1,

13."rowsParsed": 1,

14."errorsSeen": 0,

15."errorLimit": 1,

16."complete": true,

17."status": "????"

18.}

19.]

20.}

Which one is the correct value of status string data in the Response Body?

Options:

LOADED

LOADED_SUCCESS

LOAD_SUCCESS

SUCCESS

Discussion 0

Question # 28

Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set?

Options:

TRUE

FALSE

Discussion 0

Question # 29

Which of the following security and governance tools/technologies are known to provide native connectivity to Snowflake? [Select 2]

Options:

ALTR

Baffle

BIG Squid

Dataiku

Zepl

Discussion 0

Question # 30

As Data Engineer, you have requirement to Load set of New Product Files containing Product rele-vant information into the Snowflake internal tables, Later you analyzed that some of the Source files are already loaded in one of the historical batch & for that you have prechecked Metadata col-umn LAST_MODIFIED date for a staged data file & found out that LAST_MODIFIED date is older than 64 days for few files and the initial set of data was loaded into the table more than 64 days earlier, Which one is the best approach to Load Source data files with expired load metadata along with set of files whose metadata might be available to avoid data duplication?

Options:

Since the initial set of data for the table (i.e. the first batch after the table was created) was loaded, we can simply use the COPY INTO command to load all the product files with the known load status irrespective of their column LAST_MODIFIED date values.

The COPY command cannot definitively determine whether a file has been loaded al-ready if the LAST_MODIFIED date is older than 64 days and the initial set of data was loaded into the table more than 64 days earlier (and if the file was loaded into the table, that also occurred more than 64 days earlier). In this case, to prevent accidental reload, the command skips the product files by default.

Set the FORCE option to load all files, ignoring load metadata if it exists.

To load files whose metadata has expired, set the LOAD_UNCERTAIN_FILES copy option to true.

Discussion 0

DEA-C01 PDF

$54.25
~~$154.99~~

Add to Cart

DEA-C01 Testing Engine

$59.5
~~$169.99~~

Add to Cart

DEA-C01 PDF + Testing Engine

$74.55
~~$212.99~~

Add to Cart

We Accept

Secure Site

TESTED 12 Oct 2026
Customer Review

I was overwhelmed by the amount of material I had to cover, but Exams4sure's practice questions were incredibly close to the real exam. I studied for three weeks and passed with confidence. Highly recommend it to anyone short on time!

Ivy Rose Happy Customer
Quality Commitment

We don't just sell practice tests, we deliver results. Our material is carefully crafted to cover exactly what you need, so even with a tight schedule, you can prepare effectively and pass with confidence. If it doesn't meet your expectations, we're only a message away, your success and satisfaction come first.