DAS-C01 Free Practice Test

A retail company leverages Amazon Athena for ad-hoc queries against an AWS Glue Data Catalog. The data analytics team manages the data catalog and data access for the company. The data analytics team wants to separate queries and manage the cost of running those queries by different workloads and teams. Ideally, the data analysts want to group the queries run by different users within a team, store the query results in individual Amazon S3 buckets specific to each team, and enforce cost constraints on the queries run against the Data Catalog.
Which solution meets these requirements?

1. A. Create IAM groups and resource tags for each team within the compan
2. B. Set up IAM policies that controluser access and actions on the Data Catalog resources.
3. C. Create Athena resource groups for each team within the company and assign users to these group
4. D. Add S3 bucket names and other query configurations to the properties list for the resource groups.
5. E. Create Athena workgroups for each team within the compan
6. F. Set up IAM workgroup policies that control user access and actions on the workgroup resources.
7. G. Create Athena query groups for each team within the company and assign users to the groups.

Correct Answer: C
https://aws.amazon.com/about-aws/whats-new/2019/02/athena_workgroups/

A company analyzes its data in an Amazon Redshift data warehouse, which currently has a cluster of three dense storage nodes. Due to a recent business acquisition, the company needs to load an additional 4 TB of user data into Amazon Redshift. The engineering team will combine all the user data and apply complex calculations that require I/O intensive resources. The company needs to adjust the cluster's capacity to support the change in analytical and storage requirements.
Which solution meets these requirements?

1. A. Resize the cluster using elastic resize with dense compute nodes.
2. B. Resize the cluster using classic resize with dense compute nodes.
3. C. Resize the cluster using elastic resize with dense storage nodes.
4. D. Resize the cluster using classic resize with dense storage nodes.

Correct Answer: C

A medical company has a system with sensor devices that read metrics and send them in real time to an Amazon Kinesis data stream. The Kinesis data stream has multiple shards. The company needs to calculate the average value of a numeric metric every second and set an alarm for whenever the value is above one threshold or below another threshold. The alarm must be sent to Amazon Simple Notification Service (Amazon SNS) in less than 30 seconds.
Which architecture meets these requirements?

1. A. Use an Amazon Kinesis Data Firehose delivery stream to read the data from the Kinesis data stream with an AWS Lambda transformation function that calculates the average per second and sends the alarm to Amazon SNS.
2. B. Use an AWS Lambda function to read from the Kinesis data stream to calculate the average per second and sent the alarm to Amazon SNS.
3. C. Use an Amazon Kinesis Data Firehose deliver stream to read the data from the Kinesis data stream and store it on Amazon S3. Have Amazon S3 trigger an AWS Lambda function that calculates the average per second and sends the alarm to Amazon SNS.
4. D. Use an Amazon Kinesis Data Analytics application to read from the Kinesis data stream and calculatethe average per secon
5. E. Send the results to an AWS Lambda function that sends the alarm to Amazon SNS.

Correct Answer: D

A power utility company is deploying thousands of smart meters to obtain real-time updates about power consumption. The company is using Amazon Kinesis Data Streams to collect the data streams from smart meters. The consumer application uses the Kinesis Client Library (KCL) to retrieve the stream data. The company has only one consumer application.
The company observes an average of 1 second of latency from the moment that a record is written to the stream until the record is read by a consumer application. The company must reduce this latency to 500 milliseconds.
Which solution meets these requirements?

1. A. Use enhanced fan-out in Kinesis Data Streams.
2. B. Increase the number of shards for the Kinesis data stream.
3. C. Reduce the propagation delay by overriding the KCL default settings.
4. D. Develop consumers by using Amazon Kinesis Data Firehose.

Correct Answer: C
The KCL defaults are set to follow the best practice of polling every 1 second. This default results in average propagation delays that are typically below 1 second.

An ecommerce company is migrating its business intelligence environment from on premises to the AWS Cloud. The company will use Amazon Redshift in a public subnet and Amazon QuickSight. The tables already are loaded into Amazon Redshift and can be accessed by a SQL tool.
The company starts QuickSight for the first time. During the creation of the data source, a data analytics specialist enters all the information and tries to validate the connection. An error with the following message occurs: “Creating a connection to your data source timed out.”
How should the data analytics specialist resolve this error?

1. A. Grant the SELECT permission on Amazon Redshift tables.
2. B. Add the QuickSight IP address range into the Amazon Redshift security group.
3. C. Create an IAM role for QuickSight to access Amazon Redshift.
4. D. Use a QuickSight admin user for creating the dataset.

Correct Answer: A
Connection to the database times out
Your client connection to the database appears to hang or time out when running long queries, such as a COPY command. In this case, you might observe that the Amazon Redshift console displays that the query has completed, but the client tool itself still appears to be running the query. The results of the query might be missing or incomplete depending on when the connection stopped.