[Q36-Q55] Try DEA-C01 Free Now! Real Exam Question Answers Updated [Jan 08, 2024]

Rate this post

Try DEA-C01 Free Now! Real Exam Question Answers Updated [Jan 08, 2024]

Get Ready to Pass the DEA-C01 exam with Snowflake Latest Practice Exam

NEW QUESTION 36
The smaller the average depth, the better clustered the table is with regards to the specified column?

TRUE

FALSE

NEW QUESTION 37
Which of the below concepts/functions helps while implementing advanced Column-level Security?

CURRENT_ROLE

INVOKER_ROLE

Role Hierarchy

CURRENT_CLIENT

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

ALTR

Baffle

BIG Squid

Dataiku

Zepl

NEW QUESTION 39
Select the correct usage statements with regards to SQL UDF?

The body of a UDF cannot contain DDL statements or any DML statement other than SELECT.

Scalar functions (UDFs) have a limit of 500 input arguments.

When using a query expression in a SQL UDF, do not include a semicolon within the UDF body to terminate the query expression.

You can include only one query expression.

All of above are correct.

NEW QUESTION 40
Select the incorrect statement while working with warehouses?

Compute resources waiting to shut down are considered to be in “quiesce” mode.

Resizing a warehouse to a larger size is useful while loading and unloading significant amounts of data.

Resizing a warehouse will have any immediate impact on statements that are currently being executed by the warehouse.

Resizing a suspended warehouse does not provision any new compute resources for the warehouse.

NEW QUESTION 41
A database contains a table and a stored procedure defined as.

No other operations are affecting the log_table.
What will be the outcome of the procedure call?

The Iog_table contains zero records and the stored procedure returned 1 as a return value

The Iog_table contains one record and the stored procedure returned 1 as a return value

The log_table contains one record and the stored procedure returned NULL as a return value

The Iog_table contains zero records and the stored procedure returned NULL as a return value

NEW QUESTION 42
Which query will show a list of the 20 most recent executions of a specified task kttask, that have been scheduled within the last hour that have ended or are stillrunning’s.

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

GCP

AWS & AZURE

AWS only

AWS,GCP,AZURE

NEW QUESTION 44
Elon, a Data Engineer, needs to Split Semi-structured Elements from the Source files and load them as an array into Separate Columns.
Source File:
1.+———————————————————————-+
2.| $1 |
3.|———————————————————————-|
4.| {“mac_address”: {“host1”: “197.128.1.1”,”host2″: “197.168.0.1”}}, |
5.| {“mac_address”: {“host1”: “197.168.2.1”,”host2″: “197.168.3.1”}} |
6.+———————————————————————-+ Output: Splitting the Machine Address as below.
1.COL1 | COL2 |
2.|———-+———-|
3.| [ | [ |
4.| “197”, | “197”, |
5.| “128”, | “168”, |
6.| “1”, | “0”, |
7.| “1” | “1” |
8.| ] | ] |
9.| [ | [ |
10.| “197”, | “197”, |
11.| “168”, | “168”, |
12.| “2”, | “3”, |
13.| “1” | “1” |
14.| ] | ]
Which SnowFlake Function can Elon use to transform this semi structured data in the output for-mat?

CONVERT_TO_ARRAY

SPLIT

GROUP_BY_CONNECT

NEST

NEW QUESTION 45
If using a JavaScript UDF in a masking policy, Data Engineer needs to ensure the data type of the column, UDF, and masking policy match irrespective of case-sensitivity?

TRUE

FALSE

NEW QUESTION 46
A Data Engineer is working on a Snowflake deployment in AWS eu-west-1 (Ireland). The Engineer is planning to load data from staged files into target tables using the copy into command Which sources are valid? (Select THREE)

Internal stage on GCP us-central1 (Iowa)

Internal stage on AWS eu-central-1 (Frankfurt)

External stage on GCP us-central1 (Iowa)

External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)

External stage in an Amazon S3 bucket on AWS eu-central 1 (Frankfurt)

SSO attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)

NEW QUESTION 47
Within a Snowflake account permissions have been defined with custom roles and role hierarchies.
To set up column-level masking using a role in the hierarchy of the current user, what command would be used?

CORRECT_ROLE

IKVOKER_ROLE

IS_RCLE_IN_SESSION

IS_GRANTED_TO_INVOKER_ROLE

NEW QUESTION 48
A Data Engineer defines the following masking policy:

….
must be applied to the full_name column in the customer table:

Which query will apply the masking policy on the full_name column?

ALTER TABLE customer MODIFY COLUMN full_name Set MASKING POLICY name_policy;

ALTER TABLE customer MODIFY COLUMN full_nam ADD MASKING POLICY name_poiicy;

ALTER TABLE customer MODIFY COLUMN first_nane SET MASKING POLICY name_policy; lasT_name SET MASKING POLICY name_pclicy;

ALTER TABLE customer MODIFY COLUMN first_name ADD MASKING POLICY name_policy,

NEW QUESTION 49
What are characteristics of Snowpark Python packages? (Select THREE).
Third-party packages can be registered as a dependency to the Snowpark session using the session, import () method.

Python packages can access any external endpoints

Python packages can only be loaded in a local environment

Third-party supported Python packages are locked down to prevent hitting

The SQL command DESCRIBE FUNCTION will list the imported Python packages of the Python User-Defined Function (UDF).

Querying information__schema .packages will provide a list of supported Python packages and versions

NEW QUESTION 50
Harry using Snowflake Enterprise Edition & decided to scale in/out the Cluster in automatic mode. He needs to configure some warehouses as multi cluster mode and some among them in Standard mode as per needs.
If Harry is using Snowflake Enterprise Edition (or a higher edition), all his warehouses should be configured as multi-cluster warehouses only.

TRUE

FALSE

NEW QUESTION 51
If the data retention period for a table is less than 90 days, and a stream has not been consumed, Snowflake temporarily extends this period to prevent it from going stale?

TRUE

FALSE

NEW QUESTION 52
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 53
Data Engineer identified use case where he decided to use materialized view for query perfor-mance. Which one is not the limitation he must be aware of before using MVs in their use case?

Truncating a materialized view is not supported.

Time Travel is not currently supported on materialized views.

You cannot directly clone a materialized view by using the CREATE MATERIAL-IZED VIEW …
CLONE… command.

A materialized view can query only a single table & Joins, including self-joins, are not supported.

A materialized views does not support clustering.

A materialized views cannot be created on Shared Data.

A materialized view cannot include HAVING clauses OR ORDER BY clause.

Context Functions like CURRENT_TIME or CURRENT_TIMESTAMP is not per-mitted.

NEW QUESTION 54
A company is using Snowpipe to bring in millions of rows every day of Change Data Capture (CDC) into a Snowflake staging table on a real-time basis The CDC needs to get processedand combined with other data in Snowflake and land in a final table as part of the full data pipeline.
How can a Data engineer MOST efficiently process the incoming CDC on an ongoing basis?

Transform the data during the data load with Snowpipe by modifying the related copy into statement to include transformation steps such as case statements andJOIN’S.

Schedule a task that dynamically retrieves the last time the task was run from information_schema-rask_hiSwOry and use that timestamp to process the delta of the new rows since the last time the task was run.

Create a stream on the staging table and schedule a task that transforms data from the stream only when the stream has data.

Use a create ok replace table as statement that references the staging table and includes all the transformation SQL. Use a task to run the full create or replace table as statement on a scheduled basis

NEW QUESTION 55
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?

FALSE

TRUE