DEA-C01 Self-Study Guide for Becoming an SnowPro Advanced: Data Engineer Certification Exam Expert [Q44-Q60]

NEW QUESTION 44
In a data engineering pipeline, a company is using multiple applications and teams to access a shared Amazon S3 bucket. To streamline access and simplify permissions management for these different entities, which S3 feature should the company utilize?

Enable multiple IAM roles, each corresponding to an application or team, granting access to the S3 bucket.

Use S3 Access Points to create unique endpoints with tailored permissions for each application or team.

Activate S3 Transfer Acceleration for the bucket to ensure fast and differentiated access for each application or team.

Implement S3 Lifecycle policies for each application or team to manage their specific data access and retention.

NEW QUESTION 45
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 46
A company plans to provision a log delivery stream within a VPC. The company configured the VPC flow logs to publish to Amazon CloudWatch Logs. The company needs to send the flow logs to Splunk in near real time for further analysis.
Which solution will meet these requirements with the LEAST operational overhead?

Configure an Amazon Kinesis Data Streams data stream to use Splunk as the destination. Create a CloudWatch Logs subscription filter to send log events to the data stream.

Create an Amazon Kinesis Data Firehose delivery stream to use Splunk as the destination. Create a CloudWatch Logs subscription filter to send log events to the delivery stream.

Create an Amazon Kinesis Data Firehose delivery stream to use Splunk as the destination. Create an AWS Lambda function to send the flow logs from CloudWatch Logs to the delivery stream.

Configure an Amazon Kinesis Data Streams data stream to use Splunk as the destination. Create an AWS Lambda function to send the flow logs from CloudWatch Logs to the data stream.

NEW QUESTION 47
When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared with Snowflake accounts, Snowflake returns a NULL value for these functions?

TRUE

FALSE

NEW QUESTION 48
Regular views do not cache data, and therefore cannot improve performance by caching?

TRUE

FALSE

NEW QUESTION 49
A retail company stores transactions, store locations, and customer information tables in four reserved ra3.4xlarge Amazon Redshift cluster nodes. All three tables use even table distribution.
The company updates the store location table only once or twice every few years.
A data engineer notices that Redshift queues are slowing down because the whole store location table is constantly being broadcast to all four compute nodes for most queries. The data engineer wants to speed up the query performance by minimizing the broadcasting of the store location table.
Which solution will meet these requirements in the MOST cost-effective way?

Change the distribution style of the store location table from EVEN distribution to ALL distribution.

Change the distribution style of the store location table to KEY distribution based on the column that has the highest dimension.

Add a join column named store_id into the sort key for all the tables.

Upgrade the Redshift reserved node to a larger instance size in the same instance family.

NEW QUESTION 50
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 51
1.+————————————————————–+
2.| SYSTEM$CLUSTERING_INFORMATION(‘SF_DATA’, ‘(COL1, COL3)’) |
3.|————————————————————–|
4.| { |
5.| “cluster_by_keys” : “(COL1, COL3)”, |
6.| “total_partition_count” : 1156, |
7.| “total_constant_partition_count” : 0, |
8.| “average_overlaps” : 117.5484, |
9.| “average_depth” : 64.0701, |
10.| “partition_depth_histogram” : { |
11.| “00000” : 0, |
12.| “00001” : 0, |
13.| “00002” : 3, |
14.| “00003” : 3, |
15.| “00004” : 4, |
16.| “00005” : 6, |
17.| “00006” : 3, |
18.| “00007” : 5, |
19.| “00008” : 10, |
20.| “00009” : 5, |
21.| “00010” : 7, |
22.| “00011” : 6, |
23.| “00012” : 8, |
24.| “00013” : 8, |
25.| “00014” : 9, |
26.| “00015” : 8, |
27.| “00016” : 6, |
28.| “00032” : 98, |
29.| “00064” : 269, |
30.| “00128” : 698 |
31.| } |
32.| } |
33.+————————————————————–+
The Above example indicates that the SF_DATA table is not well-clustered for which of following valid reasons?

Zero (0) constant micro-partitions out of 1156 total micro-partitions.

High average of overlapping micro-partitions.

High average of overlap depth across micro-partitions.

Most of the micro-partitions are grouped at the lower-end of the histogram, with the majority of micro-partitions having an overlap depth between 64 and 128.

ALL of the above

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

NEW QUESTION 53
A company receives a daily file that contains customer data in .xls format. The company stores the file in Amazon S3. The daily file is approximately 2 GB in size.
A data engineer concatenates the column in the file that contains customer first names and the column that contains customer last names. The data engineer needs to determine the number of distinct customers in the file.
Which solution will meet this requirement with the LEAST operational effort?

Create and run an Apache Spark job in an AWS Glue notebook. Configure the job to read the S3 file and calculate the number of distinct customers.

Create an AWS Glue crawler to create an AWS Glue Data Catalog of the S3 file. Run SQL queries from Amazon Athena to calculate the number of distinct customers.

Create and run an Apache Spark job in Amazon EMR Serverless to calculate the number of distinct customers.

Use AWS Glue DataBrew to create a recipe that uses the COUNT_DISTINCT aggregate function to calculate the number of distinct customers.

NEW QUESTION 54
A new customer table is created by a data pipeline in a Snowflake schema where MANAGED ACCESSenabled.
…. Can gran access to the CUSTOMER table? (Select THREE.)

The role that owns the schema

The role that owns the database

The role that owns the customer table

The SYSADMIN role

The SECURITYADMIN role

The USERADMIN role with the manage grants privilege

NEW QUESTION 55
Search optimization works best to improve the performance of a query when the following condi-tions are true:[Select All that apply]

The table is not clustered.

The table is frequently queried on columns other than the primary cluster key.

Search Query uses Equality predicates (for example, <column_name> = <constant>) OR Predicates that use IN.

Search Query uses Sort Operations.

NEW QUESTION 56
To troubleshoot data load failure in one of your Copy Statement, Data Engineer have Executed a COPY statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS with reference to the set of files he had attempted to load. Which below function can facilitate analysis of the problematic records on top of the Results produced? [Select 2]

RESULT_SCAN

LAST_QUERY_ID

Rejected_record

LOAD_ERROR

NEW QUESTION 57
What are Common Query Problems a Data Engineer can identified using Query Profiler?

“Exploding” Joins i.e Joins resulting due to a “Cartesian product”

Queries Too Large to Fit in Memory

Inefficient Pruning

Ineffective Data Sharing

NEW QUESTION 58
A media company wants to improve a system that recommends media content to customer based on user behavior and preferences. To improve the recommendation system, the company needs to incorporate insights from third-party datasets into the company’s existing analytics platform.
The company wants to minimize the effort and time required to incorporate third-party datasets.
Which solution will meet these requirements with the LEAST operational overhead?

Use API calls to access and integrate third-party datasets from AWS Data Exchange.

Use API calls to access and integrate third-party datasets from AWS DataSync.

Use Amazon Kinesis Data Streams to access and integrate third-party datasets from AWS CodeCommit repositories.

Use Amazon Kinesis Data Streams to access and integrate third-party datasets from Amazon Elastic Container Registry (Amazon ECR).

NEW QUESTION 59
While creating even Secure UDF, snowflake recommended to use randomized identifiers (e.g. gen-erated by UUID_STRING) instead of sequence-generated values?

TRUE
(Correct)

FALSE

NEW QUESTION 60
A company maintains multiple extract, transform, and load (ETL) workflows that ingest data from the company’s operational databases into an Amazon S3 based data lake. The ETL workflows use AWS Glue and Amazon EMR to process data.
The company wants to improve the existing architecture to provide automated orchestration and to require minimal manual effort.
Which solution will meet these requirements with the LEAST operational overhead?

AWS Glue workflows

AWS Step Functions tasks

AWS Lambda functions

Amazon Managed Workflows for Apache Airflow (Amazon MWAA) workflows

DEA-C01 Self-Study Guide for Becoming an SnowPro Advanced: Data Engineer Certification Exam Expert [Q44-Q60]

admin

Leave a Reply Cancel reply

Related posts:

admin

You might also like

Leave a Reply Cancel reply