EN简体繁體日本語
ログイン
ホーム / AWS / DEA-C01
AWS · DEA-C01

DEA-C01 試験練習問題

AWS Certified Data Engineer – Associate

DEA-C01 の PDF 練習問題。資料の言語は 英語です。購入はこの試験のみで、自動更新はありません。

試験概要

DEA-C01 は「AWS Certified Data Engineer – Associate」の認定試験です。試験形式、時間、対応言語は以下をご確認ください。最新の出題範囲や受験条件は公式サイトをご参照ください。

試験コード
DEA-C01
公式の試験・資格名
AWS Certified Data Engineer – Associate
試験形式
Single-answer and multiple-response 問
試験時間
130 分
公式試験の問題数
65 問
受験可能な言語
英語、日本語、韓国語、簡体字中国語

公式試験の対応言語と練習問題ファイルの言語は異なります。試験の版と言語は公式の予約ページでご確認ください。

公式情報： 公式サイト
情報確認日：2026-10-20

対応言語

  • 英語
  • 簡体字中国語
購入前にお試し

最初の 20 問を無料プレビュー

全 366 問

題庫の元の順序で表示します。回答欄を開くと、正解と収録されている解説を確認できます。

問題の言語：英語。問題文・選択肢・正解・解説は元の題庫の言語で表示します。

免責事項：ExamPico の問題はすべてインターネット上の情報を整理したもので、学習参考用として提供しています。

問題 16

Question#16Topic1

A company uses an on-premises Microsoft SQL Server database to store financial transaction data. The company migrates the transaction data from the on-premises database to AWS at the end of each month. The company has noticed that the cost to migrate data from the on-premises database to an Amazon RDS for SQL Server database has increased recently.
The company requires a cost-effective solution to migrate the data to AWS. The solution must cause minimal downtown for the applications that access the database.
Which AWS service should the company use to meet these requirements?

  1. A. AWS Lambda
  2. B. AWS Database Migration Service (AWS DMS)
  3. C. AWS Direct Connect
  4. D. AWS DataSync
正解と解説を表示

正解

B

解説

AWS Database Migration Service (DMS) is specifically designed for migrating data from various sources, including on-premises databases, to AWS with minimal downtime and disruption to applications. It supports homogeneous migrations (e.g., SQL Server to SQL Server) as well as heterogeneous migrations (e.g., SQL Server to Amazon RDS for SQL Server).

問題 17

Question#17Topic1

A data engineer is building a data pipeline on AWS by using AWS Glue extract, transform, and load (ETL) jobs. The data engineer needs to process data from Amazon RDS and MongoDB, perform transformations, and load the transformed data into Amazon Redshift for analytics. The data updates must occur every hour.
Which combination of tasks will meet these requirements with the LEAST operational overhead? (Choose two.)

  1. A. Configure AWS Glue triggers to run the ETL jobs every hour.
  2. B. Use AWS Glue DataBrew to clean and prepare the data for analytics.
  3. C. Use AWS Lambda functions to schedule and run the ETL jobs every hour.
  4. D. Use AWS Glue connections to establish connectivity between the data sources and Amazon Redshift.
  5. E. Use the Redshift Data API to load transformed data into Amazon Redshift.
正解と解説を表示

正解

AD

解説

A - this is obvious and D -https://docs.aws.amazon.com/glue/latest/dg/console-connections.html

問題 18

Question#18Topic1

A company uses an Amazon Redshift cluster that runs on RA3 nodes. The company wants to scale read and write capacity to meet demand. A data engineer needs to identify a solution that will turn on concurrency scaling.
Which solution will meet this requirement?

  1. A. Turn on concurrency scaling in workload management (WLM) for Redshift Serverless workgroups.
  2. B. Turn on concurrency scaling at the workload management (WLM) queue level in the Redshift cluster.
  3. C. Turn on concurrency scaling in the settings during the creation of any new Redshift cluster.
  4. D. Turn on concurrency scaling for the daily usage quota for the Redshift cluster.
正解と解説を表示

正解

B

解説

Concurrency scaling in Amazon Redshift allows the cluster to automatically add and remove compute resources in response to workload demands. Enabling concurrency scaling at the workload management (WLM) queue level allows you to specify which queues can benefit from concurrency scaling based on the query workload.

問題 19

Question#19Topic1

A data engineer must orchestrate a series of Amazon Athena queries that will run every day. Each query can run for more than 15 minutes.
Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)

  1. A. Use an AWS Lambda function and the Athena Boto3 client start_query_execution API call to invoke the Athena queries programmatically.
  2. B. Create an AWS Step Functions workflow and add two states. Add the first state before the Lambda function. Configure the second state as a Wait state to periodically check whether the Athena query has finished using the Athena Boto3 get_query_execution API call. Configure the workflow to invoke the next query when the current query has finished running.
  3. C. Use an AWS Glue Python shell job and the Athena Boto3 client start_query_execution API call to invoke the Athena queries programmatically.
  4. D. Use an AWS Glue Python shell script to run a sleep timer that checks every 5 minutes to determine whether the current Athena query has finished running successfully. Configure the Python shell script to invoke the next query when the current query has finished running.
  5. E. Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to orchestrate the Athena queries in AWS Batch.
正解と解説を表示

正解

AB

解説

A. Lambda is a good option and it only trigger the athena not actually run it. No need 15 min for it. B. it mentioned a series of athena queries and it may means that one query should wait until the former one finished. B is the perfect way to do it. And lambda and step functions are very cost effective.

問題 20

Question#20Topic1

A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options.
The company's current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The company must maintain similar or better performance after the migration to AWS.
Which extract, transform, and load (ETL) service will meet these requirements?

  1. A. AWS Glue
  2. B. Amazon EMR
  3. C. AWS Lambda
  4. D. Amazon Redshift
正解と解説を表示

正解

B

解説

Glue is like the more good-looking one, but weaker brother of EMR. So when it's about petabyte scales, let EMR do the work and have Glue stay away from the action.

ダウンロードと個人利用

  • この試験の練習問題を、1・3・6・12か月のダウンロード期間で個別に購入できます。
  • お支払い確認後、作成状況がマイライブラリに表示されます。PDF の準備完了時にメールでお知らせします。
  • 期間内は再ダウンロードできます。期限後は新しい期間をご購入ください。
  • PDF は個人学習専用です。転売や公開共有は禁止されています。
  • 期限後も端末に保存済みのファイルを遠隔で削除することはありません。
資格試験の選び方