DEA-C01 valid test braindumps – Premium VCE Dumps

NO.19 Data engineer designed the data pipelines using Snowpipe to load data files into Snowflake tables, what will happen in case few files with same name but modified data are queued for reloading?

Data will be reloaded as files are modified & its associated metadata also changed. But Snowflake handle implicitly deduplication.

eTAG is changed for Files even they are having same name, so data will be duplicated in SnowFlake tables.

Snowpipe uses file loading metadata associated with each table object, so no metadata available to prevent duplication.

Snowpipe uses file loading metadata associated with each pipe object to prevent reload-ing the same files (and duplicating data) in a table.

NO.20 For enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks, which two glob-al/account privileges snowflake provide?

CREATE SHARE

IMPORT SHARE

REFERENCE USAGE

OPERATE

NO.21 Which system role is recommended for a custom role hierarchy to be ultimately assigned to?

ACCOUNTADMIN

SECURITYADMIN

SYSTEMADMIN

USERADMIN

NO.22 A data engineer notices that Amazon Athena queries are held in a queue before the queries run.
How can the data engineer prevent the queries from queueing?

Increase the query result limit.

Configure provisioned capacity for an existing workgroup.

Use federated queries.

Allow users who run the Athena queries to an existing workgroup.

NO.23 A Data Engineer ran a stored procedure containing various transactions During the execution, the session abruptly disconnected preventing one transactionfrom committing or rolling hark.The transaction was left in a detached state and created a lock on resources
…must the Engineer take to immediately run a new transaction?

Call the system function SYSTEM$ABORT_TRANSACTION.

Call the system function SYSTEM$CANCEL_TRANSACTION.

Set the LOCK_TIMEOUTto FALSE in the stored procedure

Set the transaction abort on error to true in the stored procedure.

NO.24 What is the purpose of the BUILD_FILE_URL function in Snowflake?

It generates an encrypted URL foe accessing a file in a stage.

It generates a staged URL for accessing a file in a stage.

It generates a permanent URL for accessing files in a stage.

It generates a temporary URL for accessing a file in a stage.

NO.25 A Data Engineer is building a set of reporting tables to analyze consumer requests by region for each of the Data Exchange offerings annually, as well as click-through rates for each listing Which views are needed MINIMALLY as data sources?

SNOWFLAKE- DATA_SHARING_USAGE – LISTING_EVENTS_BAILY

SNOWFLAKE.DATA_SHARING_USAGE.LISTING_CONSOKE>TION_DAILY

SNOWFLAKE. DATA_SHARING_USAGE. LISTING_TELEMETRY_DAILy

SNOWFLAKE.ACCOUNT_USAGE.DATA _TRANSFER_HISTORY

NO.26 What kind of Snowflake integration is required when defining an external function in Snowflake?

API integration

HTTP integration

Notification integration

Security integration

NO.27 What is a characteristic of the use of binding variables in JavaScript stored procedures in Snowflake?

All types of JavaScript variables can be bound

All Snowflake first-class objects can be bound

Only JavaScript variables of type number, string and sf Date can be bound

Users are restricted from binding JavaScript variables because they create SQL injection attack vulnerabilities

NO.28 UDTFs also called a table function, returns zero, one, or multiple rows for each input row?

YES

NO

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

SYSTEM$CLUSTERING_DEPTH_KEY

SYSTEM$CLUSTERING_KEY_INFORMATION (including clustering depth)

SYSTEM$CLUSTERING_DEPTH

SYSTEM$CLUSTERING_INFORMATION (including clustering depth)

NO.30 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

NO.31 A company needs to partition the Amazon S3 storage that the company uses for a data lake. The partitioning will use a path of the S3 object keys in the following format:
s3://bucket/prefix/year=2023/month=01/day=01.
A data engineer must ensure that the AWS Glue Data Catalog synchronizes with the S3 storage when the company adds new partitions to the bucket.
Which solution will meet these requirements with the LEAST latency?

Schedule an AWS Glue crawler to run every morning.

Manually run the AWS Glue CreatePartition API twice each day.

Use code that writes data to Amazon S3 to invoke the Boto3 AWS Glue create_partition API call.

Run the MSCK REPAIR TABLE command from the AWS Glue console.

NO.32 A security company stores IoT data that is in JSON format in an Amazon S3 bucket. The data structure can change when the company upgrades the IoT devices. The company wants to create a data catalog that includes the IoT data. The company’s analytics department will use the data catalog to index the data.
Which solution will meet these requirements MOST cost-effectively?

Create an AWS Glue Data Catalog. Configure an AWS Glue Schema Registry. Create a new AWS Glue workload to orchestrate the ingestion of the data that the analytics department will use into Amazon Redshift Serverless.

Create an Amazon Redshift provisioned cluster. Create an Amazon Redshift Spectrum database for the analytics department to explore the data that is in Amazon S3. Create Redshift stored procedures to load the data into Amazon Redshift.

Create an Amazon Athena workgroup. Explore the data that is in Amazon S3 by using Apache Spark through Athena. Provide the Athena workgroup schema and tables to the analytics department.

Create an AWS Glue Data Catalog. Configure an AWS Glue Schema Registry. Create AWS Lambda user defined functions (UDFs) by using the Amazon Redshift Data API. Create an AWS Step Functions job to orchestrate the ingestion of the data that the analytics department will use into Amazon Redshift Serverless.

NO.33 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

NO.34 A company receives .csv files that contain physical address data. The data is in columns that have the following names: Door_No, Street_Name, City, and Zip_Code. The company wants to create a single column to store these values in the following format:

Which solution will meet this requirement with the LEAST coding effort?

Use AWS Glue DataBrew to read the files. Use the NEST_TO_ARRAY transformation to create the new column.

Use AWS Glue DataBrew to read the files. Use the NEST_TO_MAP transformation to create the new column.

Use AWS Glue DataBrew to read the files. Use the PIVOT transformation to create the new column.

Write a Lambda function in Python to read the files. Use the Python data dictionary type to create the new column.

NO.35 Select the Correct statements with regard to using Federated authentication/SSO?

Snowflake supports using MFA in conjunction with SSO to provide additional levels of security.

Snowflake supports multiple audience values (i.e. Audience or Audience Restriction Fields) in the SAML 2.0 assertion from the identity provider to Snowflake.

Snowflake supports SSO with Private Connectivity to the Snowflake Service for Snow-flake accounts on Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.

Snowflake supports using SSO with organizations, and you can use the corresponding URL in the SAML2 security integration.

Premium VCE Dumps

Premium VCE Dumps

Tag Archives: DEA-C01 valid test braindumps

Current DEA-C01 Exam Dumps [2024] Complete Snowflake Exam Smoothly [Q19-Q35]