2023 Realistic Verified DEA-C01 exam dumps Q&As – DEA-C01 Free Update [Q44-Q58]

NEW QUESTION 44
For SQL UDFs, The invoker of the function need not have access to the objects referenced in the function definition, but only needs the privilege to use the function?

TRUE

FALSE

NEW QUESTION 45
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.

NEW QUESTION 46
Data Engineer try to load data from external stage using Snowpipe & later find out that some Set of Files Not Loaded. To debug the issue, she used COPY_HISTORY function & cross verified that its output indicates a subset of files was not loaded. What is possible reason of arising this situation in both REST API call and Auto-Ingest methods? [Select 2]

External event-driven functionality is used to call the REST APIs, and a backlog of da-ta files already existed in the external stage before the events were configured.

An event notification failure prevented a set of files from getting queued.

Files modified and staged again after 14 days and Snowpipe ignores modified files that are staged again.

A backlog of data files already existed in the external stage do not have any impact on Load failure, as this is well managed by serverless SnowPipe

NEW QUESTION 47
Jonas, a Lead Performance Engineer,identifed that some of the operation of his query which func-tionally remove the duplicates from huge data set is spilling the data to remote disk. How can he alleviate spilling to a remote disk for better query performance?

Jonas can recommend using a large warehouse which effectively increase the available memory/local disk space for the operations.

He can Process data in smaller batches to manage workload.

Spilling do not have a profound effect on query performance (especially if remote disk is used for spilling).

Data Sharing can be helpful to improve query performance.

NEW QUESTION 48
John, Data Engineer, do have technical requirements to refresh the External tables Metadata period-ically or in auto mode, which approach John can take to meet this technical specification?

John can use AUTO_REFRESH parameter if the underlying External Cloud host sup-ports this for External tables.

He can create a task that executes an ALTER EXTERNAL TABLE … REFRESH statement every 5 minutes.

External table cannot be scheduled via Snowflake Tasks, 3rd party tools/scripts needs to be used provided by External cloud storage provider.

Snowflake implicitly take care this Infrastructure needs, as underlying warehouse layer internally manage the refresh. No action needed from John.

NEW QUESTION 49
The following CREATE DATABASE command creates a clone of a database snowmy_db i.e.
Create database pods_db clone snowmy_db
before (statement => ‘7e5d0cb9-005e-94e6-b058-k8f5b37c5725’);
What are possible reason of failing cloning operation for this database?

Time Travel Statement query time is beyond the retention time of few current child (e.g., a table) of the Database entity.

Time Travel Statement query time is at or before the point in time when the object was created.

CREATE DATABASE query fails due to compilation error as it do not support state-ment keyword.

SQL Compilation error: “Incorrect Syntax ‘before’ while creating database”

NEW QUESTION 50
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.

NEW QUESTION 51
By default, a newly-created Custom role is not assigned to any user, nor granted to any other role?

TRUE

FALSE

NEW QUESTION 52
Jeff, a Data Engineer, accessing elements in JSON object in its 3 data loading scripts, he unknow-ingly use the upper case while accessing the elements. e.g.
Script 1 –> fruits:apple.sweet
Script 2 –> FRUITS:apple.sweet
Script 3 –> FRUITS:Apple.Sweet
Which are the correct statements?

Script 1 & Script 2 traverse path twill be treated same, but Script 2 will not.

Script 1,2,3 traverse path will treat in same way.

Script 1 & 3 traverse path will be treated in same way.

Script 2&3 traverse path will be same.

NEW QUESTION 53
Mark the incorrect statement in case Data engineer using the COPY INTO <table> command to load data from files into Snowflake tables?

For Data loading of files with semi-structured file formats (JSON, Avro, etc.), the only supported character set is UTF-16.

For loading data from all semi-structured supported file formats (JSON, Avro, etc.), as well as unloading data, UTF-8 is the only supported character set.

For Local environment, Files are first copied (“staged”) to an internal (Snowflake) stage, then loaded into a table.

UTF-32 & UTF-16 both encoding character sets supported for loading data from de-limited files (CSV, TSV, etc.)

NEW QUESTION 54
You as Data engineer might want to consider disabling auto-suspend for a warehouse if?

You have a low, fluctuating workload for the warehouse.

You have a heavy, steady workload for the warehouse.

You require the warehouse to be available with delay.

You require the warehouse to be available with no delay or lag time.

NEW QUESTION 55
Which are the two ways to access elements in a JSON object?

Use SemiColon notation to traverse a path in a JSON object:
<col-umn>:<level1_element>;<level2_element>;<level3_element>.

use Curly bracket notation to traverse the path in an object:
<col-umn>{‘<level1_element>’}{‘<level2_element>’}.

Use dot notation to traverse a path in a JSON object:
<col-umn>:<level1_element>.<level2_element>.<level3_element>.

use bracket notation to traverse the path in an object:
<col-umn>[‘<level1_element>’][‘<level2_element>’].

NEW QUESTION 56
Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction.
What is term used to call these Transaction?

Scoped transactions

Inner Transaction

Nested Scope Transaction

Atomic Transaction

Enclosed Transaction

NEW QUESTION 57
Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?

TRUE

FALSE

UPDATE

INSERT

NEW QUESTION 58
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.