DEA-C01 試験問題を無料オンラインアクセス

A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. The ETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, and load data into Amazon Redshift.
The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python to orchestrate the jobs.
Which service will meet these requirements?

• A.AWS Step Functions
• B.Amazon EventBridge
• C.Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
• D.AWS Glue

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?

• A.Add a join column named store_id into the sort key for all the tables.
• B.Change the distribution style of the store location table to KEY distribution based on the column that has the highest dimension.
• C.Change the distribution style of the store location table from EVEN distribution to ALL distribution.
• D.Upgrade the Redshift reserved node to a larger instance size in the same instance family.

A data engineer needs to analyze time-sensitive sales data. The company stores the data in an Amazon S3 bucket. The data engineer uses AWS Glue Data Catalog to access the data.
When the data engineer performs the analysis, the data engineer notices that some records are missing or out of date.
What is the likely cause of these issues?

• A.The AWS Glue job schedules overlap with one another.
• B.AWS Glue Data Catalog is not up to date with the latest S3 partition changes.
• C.Versioning is not enabled on the S3 bucket.
• D.Incorrect IAM roles are assigned to the AWS Glue jobs.

A data engineer notices slow query performance on a highly partitioned table that is in Amazon Athena. The table contains daily data for the previous 5 years, partitioned by date.
The data engineer wants to improve query performance and to automate partition management.
Which solution will meet these requirements?

• A.Increase the processing capacity of Athena queries by allocating more compute resources.
• B.Reduce the number of partitions by changing the partitioning schema from daily to monthly granularity.
• C.Use an AWS Lambda function that runs daily. Configure the function to manually create new partitions in AWS Glue for each day's data.
• D.Use partition projection in Athena. Configure the table properties by using a date range from 5 years ago to the present.

A company has as JSON file that contains personally identifiable information (PII) data and non- PII data. The company needs to make the data available for querying and analysis.
The non-PII data must be available to everyone in the company. The PII data must be available only to a limited group of employees.
Which solution will meet these requirements with the LEAST operational overhead?

• A.Create two Amazon RDS PostgreSQL databases. Load the PII data and the non-PII data into the separate databases. Grant access to the databases based on the type of user.
• B.Store the JSON file in an Amazon S3 bucket. Configure AWS Glue to split the file into one file that contains the PII data and one file that contains the non-PII data. Store the output files in separate S3 buckets. Grant the required access to the buckets based on the type of user.
• C.Store the JSON file in an Amazon S3 bucket. Catalog the file schema in AWS Lake Formation.
  Use Lake Formation permissions to provide access to the required data based on the type of user.
• D.Store the JSON file in an Amazon S3 bucket. Use Amazon Macie to identify PII data and to grant access based on the type of user.