最新的SnowPro Advanced認證 DEA-C01考試題庫

問題1

A data engineer is building a solution to detect sensitive information that is stored in a data lake across multiple Amazon S3 buckets. The solution must detect personally identifiable information (PII) that is in a proprietary data format.
Which solution will meet these requirements with the LEAST operational overhead?

A. Use Amazon Made with managed data identifiers.

B. Use the AWS Glue Detect PII transform with specific patterns.

C. Use an AWS Lambda function with custom regular expressions.

D. Use Amazon Athena with a SQL query to match the custom formats.

正確答案: B

說明：（僅 VCESoft 成員可見）

問題2

An airline company is collecting metrics about flight activities for analytics. The company is conducting a proof of concept (POC) test to show how analytics can provide insights that the company can use to increase on-time departures.
The POC test uses objects in Amazon S3 that contain the metrics in .csv format. The POC test uses Amazon Athena to query the data. The data is partitioned in the S3 bucket by date.
As the amount of data increases, the company wants to optimize the storage solution to improve query performance.
Which combination of solutions will meet these requirements? (Choose two.)

A. Preprocess the .csv data to Apache Parquet format by fetching only the data blocks that are needed for predicates.

B. Use an S3 bucket that is in the same AWS Region where the company runs Athena queries.

C. Use an S3 bucket that is in the same account that uses Athena to query the data.

D. Add a randomized string to the beginning of the keys in Amazon S3 to get more throughput across partitions.

E. Preprocess the .csv data to JSON format by fetching only the document keys that the query requires.

正確答案: A,B

說明：（僅 VCESoft 成員可見）

問題3

A company stores a 100 MB dataset in an Amazon S3 bucket as an Apache Parquet file. A data engineer needs to profile the data before performing data preparation steps on the data. Which solution will meet this requirement in the MOST operationally efficient way?

A. Create a profile job on the dataset in AWS Glue DataBrew. Review the profile job results.

B. Load the data into an Amazon QuickSight dataset. Build a topic to profile the data with questions.

C. Stream the data into Amazon Managed Service for Apache Flink for SQL queries. Use the Apache Flink dashboard to profile the data.

D. Ingest the data into Amazon Redshift Spectrum. Use SQL queries to profile the data.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題4

A company runs an extract, transform, and load (ETL) job in AWS Glue. The job processes personally identifiable information (PII) data and writes logs to an Amazon CloudWatch Logs log group. A data engineer needs to mask PII data in the CloudWatch logs group. Which solution will meet these requirements?

A. Configure a data protection policy. Attach the policy to the CloudWatch log group.

B. Call AWS Glue sensitive data detection APIs in the ETL job.

C. Attach an AWS Glue security configuration to the ETL job.

D. Run an Amazon Macie sensitive data discovery job.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題5

A company needs to optimize storage for an Amazon S3 bucket. Objects older than 1 year must be accessible within 5 hours. All versions of the objects must be retained and immutable for 7 years. All versions of the objects must use the write-once-read-many (WORM) model. Which solution will meet these requirements?

A. Configure S3 Object Lock on the bucket and use the S3 Intelligent-Tiering storage class.
Configure a lifecycle policy for the bucket to transition objects that are older than 1 year to S3 Glacier Flexible Retrieval. Configure the policy to delete objects that are older than 7 years.

B. Configure S3 Versioning on the bucket and use the S3 Intelligent-Tiering storage class. Configure a lifecycle policy for the bucket to transition objects that are older than 1 year to S3 Glacier Flexible Retrieval. Configure the policy to delete objects that are older than 7 years.

C. Configure S3 Versioning on the bucket and use the S3 Intelligent-Tiering storage class. Configure a lifecycle policy for the bucket to transition objects that are older than 1 year to S3 Glacier Deep Archive. Configure the policy to deletes objects that are older than 7 years.

D. Configure S3 Object Lock on the bucket and use the S3 Intelligent-Tiering storage class.
Configure a lifecycle policy for the bucket to transition objects that are older than 1 year to S3 Glacier Deep Archive. Configure the policy to delete objects that are older than 7 years.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題6

A company ingests data from multiple data sources and stores the data in an Amazon S3 bucket.
An AWS Glue extract, transform, and load (ETL) job transforms the data and writes the transformed data to an Amazon S3 based data lake. The company uses Amazon Athena to query the data that is in the data lake.
The company needs to identify matching records even when the records do not have a common unique identifier.
Which solution will meet this requirement?

A. Train and use the AWS Glue PySpark Filter class in the ETL job.

B. Partition tables and use the ETL job to partition the data on a unique identifier.

C. Use Amazon Macie pattern matching as part of the ETL job.

D. Train and use the AWS Lake Formation FindMatches transform in the ETL job.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題7

A data engineer has a one-time task to read data from objects that are in Apache Parquet format in an Amazon S3 bucket. The data engineer needs to query only one column of the data.
Which solution will meet these requirements with the LEAST operational overhead?

A. Prepare an AWS Glue DataBrew project to consume the S3 objects and to query the required column.

B. Run an AWS Glue crawler on the S3 objects. Use a SQL SELECT statement in Amazon Athena to query the required column.

C. Configure an AWS Lambda function to load data from the S3 bucket into a pandas dataframe.
Write a SQL SELECT statement on the dataframe to query the required column.

D. Use S3 Select to write a SQL SELECT statement to retrieve the required column from the S3 objects.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題8

A data engineer needs to build an extract, transform, and load (ETL) job. The ETL job will process daily incoming .csv files that users upload to an Amazon S3 bucket. The size of each S3 object is less than 100 MB.
Which solution will meet these requirements MOST cost-effectively?

A. Write an AWS Glue Python shell job. Use pandas to transform the data.

B. Write a custom Python application. Host the application on an Amazon Elastic Kubernetes Service (Amazon EKS) cluster.

C. Write a PySpark ETL script. Host the script on an Amazon EMR cluster.

D. Write an AWS Glue PySpark job. Use Apache Spark to transform the data.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題9

A company hosts its applications on Amazon EC2 instances. The company must use SSL/TLS connections that encrypt data in transit to communicate securely with AWS infrastructure that is managed by a customer.
A data engineer needs to implement a solution to simplify the generation, distribution, and rotation of digital certificates. The solution must automatically renew and deploy SSL/TLS certificates.
Which solution will meet these requirements with the LEAST operational overhead?

A. Use Amazon Elastic Container Service (Amazon ECS) Service Connect.

B. Implement custom automation scripts in AWS Secrets Manager.

C. Use AWS Certificate Manager (ACM).

D. Store self-managed certificates on the EC2 instances.

正確答案: C

說明：（僅 VCESoft 成員可見）

最新的Snowflake SnowPro Advanced: Data Engineer Certification - DEA-C01免費考試真題

最新更新

站內鏈接

聯系我們