Question 1

A data analyst is using Amazon QuickSight for data visualization across multiple datasets generated by applications. Each application stores files within a separate Amazon S3 bucket. AWS Glue Data Catalog is used as a central catalog across all application data in Amazon S3. A new application stores its data within a separate S3 bucket. After updating the catalog to include the new application data source, the data analyst created a new Amazon QuickSight data source from an Amazon Athena table, but the import into SPICE failed.
How should the data analyst resolve the issue?

Options :

A : Edit the permissions for the AWS Glue Data Catalog from within the Amazon QuickSight console.

B : Edit the permissions for the new S3 bucket from within the Amazon QuickSight console.

C : Edit the permissions for the AWS Glue Data Catalog from within the AWS Glue console.

D : Edit the permissions for the new S3 bucket from within the S3 console.

Answer: B

Question 2

A marketing company has an application that stores event data in an Amazon RDS database. The company is replicating this data to Amazon Redshift for reporting and business intelligence (BI) purposes. New event data is continuously generated and ingested into the RDS database throughout the day and captured by a change data capture (CDC) replication task in AWS Database Migration Service (AWS DMS). The company requires that the new data be replicated to Amazon Redshift in near-real time. Which solution meets these requirements?

Options :

A :

Use Amazon Kinesis Data Streams as the destination of the CDC replication task in AWS DMS. Use an AWS Glue streaming job to read changed records from Kinesis Data Streams and perform an upsert into the Redshift cluster.

B :

Use Amazon S3 as the destination of the CDC replication task in AWS DMS. Use the COPY command to load data into the Redshift cluster.

C :

Use Amazon DynamoDB as the destination of the CDC replication task in AWS DMS. Use the COPY command to load data into the Redshift cluster.

D :

Use Amazon Kinesis Data Firehose as the destination of the CDC replication task in AWS DMS. Use an AWS Glue streaming job to read changed records from Kinesis Data Firehose and perform an upsert into the Redshift cluster.

Answer: A

Question 3

A data analyst is designing an Amazon QuickSight dashboard using centralized sales data that resides in Amazon Redshift. The dashboard must be restricted so that a salesperson in Sydney. Australia, can see only the Australia view and that a salesperson in New York can see only United States (US) data.

What should the data analyst do to ensure the appropriate data security is in place?

Options :

A : Place the data sources for Australia and the US into separate SPICE capacity pools.

B : Set up an Amazon Redshift VPC security group for Australia and the US.

C : Deploy QuickSight Enterprise edition to implement row-level security (RLS) to the sales table.

D : Deploy QuickSight Enterprise edition and set up different VPC security groups for Australia and the US.

Answer: D

Question 4

A company with a video streaming website wants to analyze user behavior to make recommendations to users in real time Clickstream data is being sent to Amazon Kinesis Data Streams and reference data is stored in Amazon S3 The company wants a solution that can use standard SQL quenes The solution must also provide a way to look up pre-calculated reference data while making recommendations
Which solution meets these requirements?

Options :

A : Use an AWS Glue Python shell job to process incoming data from Kinesis Data Streams Use the Boto3 library to write data to Amazon Redshift

B : Use AWS Glue streaming and Scale to process incoming data from Kinesis Data Streams Use the AWS Glue connector to write data to Amazon Redshift

C : Use Amazon Kinesis Data Analytics to create an in-application table based upon the reference data Process incoming data from Kinesis Data Streams Use a data stream to write results to Amazon Redshift

D : Use Amazon Kinesis Data Analytics to create an in-application table based upon the reference data Process incoming data from Kinesis Data Streams Use an Amazon Kinesis Data Firehose delivery stream to write results to Amazon Redshift

Answer: D

Question 5

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

Confidently Practice Online with Free DAS-C01 Exam Cram

Buying Options: