最新的AWS Certified Data Engineer認證 Data-Engineer-Associate考試題庫

問題1

A company is building a data lake for a new analytics team. The company is using Amazon S3 for storage and Amazon Athena for query analysis. All data that is in Amazon S3 is in Apache Parquet format.
The company is running a new Oracle database as a source system in the company ' s data center. The company has 70 tables in the Oracle database. All the tables have primary keys. Data can occasionally change in the source system. The company wants to ingest the tables every day into the data lake.
Which solution will meet this requirement with the LEAST effort?

A. Create an AWS Glue connection to the Oracle database. Create an AWS Glue bookmark job to ingest the data incrementally and to write the data to Amazon S3 in Parquet format.

B. Create an Apache Sqoop job in Amazon EMR to read the data from the Oracle database. Configure the Sqoop job to write the data to Amazon S3 in Parquet format.

C. Create an Oracle database in Amazon RDS. Use AWS Database Migration Service (AWS DMS) to migrate the on-premises Oracle database to Amazon RDS. Configure triggers on the tables to invoke AWS Lambda functions to write changed records to Amazon S3 in Parquet format.

D. Create an AWS Database Migration Service (AWS DMS) task for ongoing replication. Set the Oracle database as the source. Set Amazon S3 as the target. Configure the task to write the data in Parquet format.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題2

A company is developing a log streaming pipeline that uses Amazon Data Firehose. The pipeline streams Amazon CloudWatch Logs data to an Amazon S3 bucket. The company ' s analytics team needs to use the data in audits. The pipeline must deliver only the relevant logs to the S3 bucket in a compatible format for the team ' s analysis.
Which solution will meet these requirements and maintain reliable performance?

A. Create a subscription filter in the CloudWatch Logs log group. Configure the filter to monitor the Firehose stream. Create an AWS Lambda function to convert the log files to the desired format.
Configure Firehose to invoke the Lambda function.

B. Tag the CloudWatch Logs log groups that the analytics team needs. Configure Firehose to ingest only the tagged log groups. Configure Firehose to write the output in the desired format.

C. Create a subscription filter in the CloudWatch Logs log group that uses the Firehose delivery stream as the destination. Create an AWS Lambda function that converts the log files to the desired format.
Configure Firehose to invoke the Lambda function.

D. Set the S3 bucket rules to allow logs from only specific timestamp ranges. Create an AWS Lambda function that converts the log files to the desired format. Use an S3 trigger to invoke the Lambda function.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題3

A data engineer must implement Amazon Redshift Serverless as a data warehouse for a company. The data engineer needs to integrate multiple Amazon Aurora MySQL databases into Amazon Redshift. The solution must maintain near real-time latency and minimize infrastructure management as much as possible.
Which solution will meet these requirements?

A. Use AWS Database Migration Service (AWS DMS) Serverless to ingest data into Amazon Redshift.

B. Create an AWS Lambda function to ingest data into Amazon Redshift.

C. Create a Python module for an AWS Glue job to standardize the data ingestion from Aurora MySQL into Amazon Redshift.

D. Set up a zero-ETL integration between the Aurora MySQL databases and Amazon Redshift Serverless.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題4

A company stores a large dataset in an Amazon S3 bucket. A data engineer frequently runs complex queries on the dataset by using Amazon Athena. The data engineer needs to optimize query performance and optimize costs for queries that are run multiple times with the same parameters.
Which solution will meet these requirements?

A. Use Amazon Redshift Spectrum to query the data in Amazon S3.

B. Use Amazon EMR to pre-process the data before running Athena queries.

C. Configure query result reuse settings in the Athena workgroup.

D. Convert the dataset to JSON format before running Athena queries.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題5

A mobile gaming company wants to capture data from its gaming app. The company wants to make the data available to three internal consumers of the data. The data records are approximately 20 KB in size.
The company wants to achieve optimal throughput from each device that runs the gaming app. Additionally, the company wants to develop an application to process data streams. The stream-processing application must have dedicated throughput for each internal consumer.
Which solution will meet these requirements?

A. Configure the mobile app to call the PutRecordBatch API operation to send data to Amazon Data Firehose. Submit an AWS Support case to turn on dedicated throughput for the company ' s AWS account. Allow each internal consumer to access the stream.

B. Configure the mobile app to call the PutRecords API operation to send data to Amazon Kinesis Data Streams. Use the enhanced fan-out feature with a stream for each internal consumer.

C. Configure the mobile app to call the PutRecords API operation to send data to Amazon Kinesis Data Streams. Host the stream-processing application for each internal consumer on Amazon EC2 instances.Configure auto scaling for the EC2 instances.

D. Configure the mobile app to use the Amazon Kinesis Producer Library (KPL) to send data to Amazon Data Firehose. Use the enhanced fan-out feature with a stream for each internal consumer.

正確答案: B

說明：（僅 VCESoft 成員可見）

問題6

A data engineer needs to use an Amazon QuickSight dashboard that is based on Amazon Athena queries on data that is stored in an Amazon S3 bucket. When the data engineer connects to the QuickSight dashboard, the data engineer receives an error message that indicates insufficient permissions.
Which factors could cause to the permissions-related errors? (Choose two.)

A. There is no connection between QuickSgqht and Athena.

B. QuickSiqht does not have access to the S3 bucket.

C. There is no 1AM role assigned to QuickSiqht.

D. QuickSight does not have access to decrypt S3 data.

E. The Athena tables are not cataloged.

正確答案: B,D

說明：（僅 VCESoft 成員可見）

問題7

A data engineer uses Amazon Redshift to run resource-intensive analytics processes once every month. Every month, the data engineer creates a new Redshift provisioned cluster. The data engineer deletes the Redshift provisioned cluster after the analytics processes are complete every month. Before the data engineer deletes the cluster each month, the data engineer unloads backup data from the cluster to an Amazon S3 bucket.
The data engineer needs a solution to run the monthly analytics processes that does not require the data engineer to manage the infrastructure manually.
Which solution will meet these requirements with the LEAST operational overhead?

A. Use Amazon Redshift Serverless to automatically process the analytics workload.

B. Use Amazon Step Functions to pause the Redshift cluster when the analytics processes are complete and to resume the cluster to run new processes every month.

C. Use AWS CloudFormation templates to automatically process the analytics workload.

D. Use the AWS CLI to automatically process the analytics workload.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題8

A data engineer must ingest a source of structured data that is in .csv format into an Amazon S3 data lake.
The .csv files contain 15 columns. Data analysts need to run Amazon Athena queries on one or two columns of the dataset. The data analysts rarely query the entire file.
Which solution will meet these requirements MOST cost-effectively?

A. Create an AWS Glue extract, transform, and load (ETL) job to read from the .csv structured data source. Configure the job to write the data into the data lake in Apache Parquet format.

B. Use an AWS Glue PySpark job to ingest the source data into the data lake in Apache Avro format.

C. Create an AWS Glue extract, transform, and load (ETL) job to read from the .csv structured data source. Configure the job to ingest the data into the data lake in JSON format.

D. Use an AWS Glue PySpark job to ingest the source data into the data lake in .csv format.

正確答案: A

說明：（僅 VCESoft 成員可見）

最新的Amazon AWS Certified Data Engineer - Associate (DEA-C01) - Data-Engineer-Associate免費考試真題

最新更新

站內鏈接

聯系我們