Question 1

A company has a marketing department and a finance department. The departments are storing data in Amazon S3 in their own AWS accounts in AWS Organizations. Both departments use AWS Lake Formation to catalog and secure their dat
a. The departments have some databases and tables that share common names.
The marketing department needs to securely access some tables from the finance department.
Which two steps are required for this process? (Choose two.)

Options :

A : The finance department grants Lake Formation permissions for the tables to the external account for the marketing department.

B : The finance department creates cross-account IAM permissions to the table for the marketing department role.

C : The marketing department creates an IAM role that has permissions to the Lake Formation tables.

Answer: A,B

Question 2

An operations team notices that a few AWS Glue jobs for a given ETL application are failing. The AWS Glue jobs read a large number of small JSON files from an Amazon S3 bucket and write the data to a different S3 bucket in Apache Parquet format with no major transformations. Upon initial investigation, a data engineer notices the following error message in the History tab on the AWS Glue console: ''Command Failed with Exit Code 1.''
Upon further investigation, the data engineer notices that the driver memory profile of the failed jobs crosses the safe threshold of 50% usage quickly and reaches 90--95% soon after. The average memory usage across all executors continues to be less than 4%.
The data engineer also notices the following error while examining the related Amazon CloudWatch Logs.
What should the data engineer do to solve the failure in the MOST cost-effective way?

Options :

A : Change the worker type from Standard to G.2X.

B : Modify the AWS Glue ETL code to use the 'groupFiles': 'inPartition' feature.

C : Increase the fetch size setting by using AWS Glue dynamics frame.

D : Modify maximum capacity to increase the total maximum data processing units (DPUs) used.

Answer: B

Question 3

A company leverages Amazon Athena for ad-hoc queries against data stored in Amazon S3. The company wants to implement additional controls to separate query execution and query history among users, teams, or applications running in the same AWS account to comply with internal security policies.
Which solution meets these requirements?

Options :

A : Create an S3 bucket for each given use case, create an S3 bucket policy that grants permissions to appropriate individual IAM users. and apply the S3 bucket policy to the S3 bucket.

B : Create an Athena workgroup for each given use case, apply tags to the workgroup, and create an IAM policy using the tags to apply appropriate permissions to the workgroup.

C : Create an IAM role for each given use case, assign appropriate permissions to the role for the given use case, and add the role to associate the role with Athena.

D : Create an AWS Glue Data Catalog resource policy for each given use case that grants permissions to appropriate individual IAM users, and apply the resource policy to the specific tables used by Athena.

Answer: B

Question 4

A company has a mobile app that has millions of users. The company wants to enhance the mobile app by including interactive data visualizations that show user trends. The data for visualization is stored in a large data lake with 50 million rows. Data that is used in the visualization should be no more than two hours old. Which solution will meet these requirements with the LEAST operational overhead?

Options :

A :

Run an hourly batch process that renders user-specific data visualizations as static images that are stored in Amazon S3.

B :

Precompute aggregated data hourly. Store the data in Amazon DynamoDB. Render the data by using the D3.js JavaScript library.

C :

Embed an Amazon QuickSight Enterprise edition dashboard into the mobile app by using the QuickSight Embedding SDK. Refresh data in SPICE hourly.

D :

Run Amazon Athena queries behind an Amazon API Gateway API. Render the data by using the D3.js JavaScript library.

Answer: A

Question 5

A manufacturing company has many loT devices in different facilities across the world The company is using Amazon Kinesis Data Streams to collect the data from the devices
The company's operations team has started to observe many WnteThroughputExceeded exceptions The operations team determines that the reason is the number of records that are being written to certain shards The data contains device ID capture date measurement type, measurement value and facility ID The facility ID is used as the partition key
Which action will resolve this issue?

Options :

A : Change the partition key from facility ID to a randomly generated key

B : Increase the number of shards

C : Archive the data on the producers' side

D : Change the partition key from facility ID to capture date

Answer: B

Smartly Prepare Exam with Free Online DAS-C01 Practice Test

Buying Options: