vuthanhdatt's Second Brain

Associate-DEA-C01_20

5 min read

Questions and Answers

Question bJ6E8kIO7b33d7CbFEsf

Question

The company stores a large volume of customer records in Amazon S3. To comply with regulations, the company must be able to access new customer records immediately for the first 30 days after the records are created. The company accesses records that are older than 30 days infrequently.

The company needs to cost-optimize its Amazon S3 storage.

Which solution will meet these requirements MOST cost-effectively?

Choices

  • A: Apply a lifecycle policy to transition records to S3 Standard Infrequent-Access (S3 Standard-IA) storage after 30 days.
  • B: Use S3 Intelligent-Tiering storage.
  • C: Transition records to S3 Glacier Deep Archive storage after 30 days.
  • D: Use S3 Standard-Infrequent Access (S3 Standard-IA) storage for all customer records.

Question TcRlNES5HPHOzT6ZKdOt

Question

A data engineer is using Amazon QuickSight to build a dashboard to report a company’s revenue in multiple AWS Regions. The data engineer wants the dashboard to display the total revenue for a Region, regardless of the drill-down levels shown in the visual.

Which solution will meet these requirements?

Choices

  • A: Create a table calculation.
  • B: Create a simple calculated field.
  • C: Create a level-aware calculation - aggregate (LAC-A) function.
  • D: Create a level-aware calculation - window (LAC-W) function.

Question 7KlSZPZC5mmoUD2akw3W

Question

A retail company stores customer data in an Amazon S3 bucket. Some of the customer data contains personally identifiable information (PII) about customers. The company must not share PII data with business partners.

A data engineer must determine whether a dataset contains PII before making objects in the dataset available to business partners.

Which solution will meet this requirement with the LEAST manual intervention?

Choices

  • A: Configure the S3 bucket and S3 objects to allow access to Amazon Macie. Use automated sensitive data discovery in Macie.
  • B: Configure AWS CloudTrail to monitor S3 PUT operations. Inspect the CloudTrail trails to identify operations that save PII.
  • C: Create an AWS Lambda function to identify PII in S3 objects. Schedule the function to run periodically.
  • D: Create a table in AWS Glue Data Catalog. Write custom SQL queries to identify PII in the table. Use Amazon Athena to run the queries.

Question xDMzs7cotEhbPjnbo485

Question

A data engineer needs to create an empty copy of an existing table in Amazon Athena to perform data processing tasks. The existing table in Athena contains 1,000 rows.

Which query will meet this requirement?

Choices

  • A: CREATE TABLE new_table - LIKE old_table;
  • B: CREATE TABLE new_table - AS SELECT *

FROM old_table - WITH NO DATA;

  • C: CREATE TABLE new_table - AS SELECT * FROM old_table;
  • D: CREATE TABLE new_table - as SELECT *

FROM old_cable - WHERE 1=1;

Question xGpZWnbhxMlWVmKrvMt7

Question

A company has a data lake in Amazon S3. The company collects AWS CloudTrail logs for multiple applications. The company stores the logs in the data lake, catalogs the logs in AWS Glue, and partitions the logs based on the year. The company uses Amazon Athena to analyze the logs.

Recently, customers reported that a query on one of the Athena tables did not return any data. A data engineer must resolve the issue.

Which combination of troubleshooting steps should the data engineer take? (Choose two.)

Choices

  • A: Confirm that Athena is pointing to the correct Amazon S3 location.
  • B: Increase the query timeout duration.
  • C: Use the MSCK REPAIR TABLE command.
  • D: Restart Athena.
  • E: Delete and recreate the problematic Athena table.

Graph View