DAS-C01 Free Practice Test

A marketing company is using Amazon EMR clusters for its workloads. The company manually installs third party libraries on the clusters by logging in to the master nodes. A data analyst needs to create an automated solution to replace the manual process.
Which options can fulfill these requirements? (Choose two.)

1. A. Place the required installation scripts in Amazon S3 and execute them using custom bootstrap actions.
2. B. Place the required installation scripts in Amazon S3 and execute them through Apache Spark in Amazon EMR.
3. C. Install the required third-party libraries in the existing EMR master nod
4. D. Create an AMI out of that master node and use that custom AMI to re-create the EMR cluster.
5. E. Use an Amazon DynamoDB table to store the list of required application
6. F. Trigger an AWS Lambda function with DynamoDB Streams to install the software.
7. G. Launch an Amazon EC2 instance with Amazon Linux and install the required third-party libraries on the instanc
8. H. Create an AMI and use that AMI to create the EMR cluster.

Correct Answer: AE
https://aws.amazon.com/about-aws/whats-new/2017/07/amazon-emr-now-supports-launching-clusters-with-cust https://docs.aws.amazon.com/de_de/emr/latest/ManagementGuide/emr-plan-bootstrap.html

A company has a data warehouse in Amazon Redshift that is approximately 500 TB in size. New data is imported every few hours and read-only queries are run throughout the day and evening. There is a particularly heavy load with no writes for several hours each morning on business days. During those hours, some queries are queued and take a long time to execute. The company needs to optimize query execution and avoid any downtime.
What is the MOST cost-effective solution?

1. A. Enable concurrency scaling in the workload management (WLM) queue.
2. B. Add more nodes using the AWS Management Console during peak hour
3. C. Set the distribution style to ALL.
4. D. Use elastic resize to quickly add nodes during peak time
5. E. Remove the nodes when they are not needed.
6. F. Use a snapshot, restore, and resize operatio
7. G. Switch to the new target cluster.

Correct Answer: A
https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html

A mortgage company has a microservice for accepting payments. This microservice uses the Amazon DynamoDB encryption client with AWS KMS managed keys to encrypt the sensitive data before writing the data to DynamoDB. The finance team should be able to load this data into Amazon Redshift and aggregate the values within the sensitive fields. The Amazon Redshift cluster is shared with other data analysts from different business units.
Which steps should a data analyst take to accomplish this task efficiently and securely?

1. A. Create an AWS Lambda function to process the DynamoDB strea
2. B. Decrypt the sensitive data using the same KMS ke
3. C. Save the output to a restricted S3 bucket for the finance tea
4. D. Create a finance table in Amazon Redshift that is accessible to the finance team onl
5. E. Use the COPY command to load the data from Amazon S3 to the finance table.
6. F. Create an AWS Lambda function to process the DynamoDB strea
7. G. Save the output to a restricted S3 bucket for the finance tea
8. H. Create a finance table in Amazon Redshift that is accessible to the finance team onl
9. I. Use the COPY command with the IAM role that has access to the KMS key to load the data from S3 to the finance table.
10. J. Create an Amazon EMR cluster with an EMR_EC2_DefaultRole role that has access to the KMS key.Create Apache Hive tables that reference the data stored in DynamoDB and the finance table in Amazon Redshif
11. K. In Hive, select the data from DynamoDB and then insert the output to the finance table in Amazon Redshift.
12. L. Create an Amazon EMR cluste
13. M. Create Apache Hive tables that reference the data stored inDynamoD
14. N. Insert the output to the restricted Amazon S3 bucket for the finance tea
15. O. Use the COPY command with the IAM role that has access to the KMS key to load the data from Amazon S3 to the finance table in Amazon Redshift.

Correct Answer: B

A company analyzes historical data and needs to query data that is stored in Amazon S3. New data is
generated daily as .csv files that are stored in Amazon S3. The company’s analysts are using Amazon Athena to perform SQL queries against a recent subset of the overall data. The amount of data that is ingested into Amazon S3 has increased substantially over time, and the query latency also has increased.
Which solutions could the company implement to improve query performance? (Choose two.)

1. A. Use MySQL Workbench on an Amazon EC2 instance, and connect to Athena by using a JDBC or ODBC connecto
2. B. Run the query from MySQL Workbench instead of Athena directly.
3. C. Use Athena to extract the data and store it in Apache Parquet format on a daily basi
4. D. Query the extracted data.
5. E. Run a daily AWS Glue ETL job to convert the data files to Apache Parquet and to partition the converted file
6. F. Create a periodic AWS Glue crawler to automatically crawl the partitioned data on a daily basis.
7. G. Run a daily AWS Glue ETL job to compress the data files by using the .gzip forma
8. H. Query the compressed data.
9. I. Run a daily AWS Glue ETL job to compress the data files by using the .lzo forma
10. J. Query the compressed data.

Correct Answer: BC

A company receives data from its vendor in JSON format with a timestamp in the file name. The vendor uploads the data to an Amazon S3 bucket, and the data is registered into the company’s data lake for analysis and reporting. The company has configured an S3 Lifecycle policy to archive all files to S3 Glacier after 5 days.
The company wants to ensure that its AWS Glue crawler catalogs data only from S3 Standard storage and ignores the archived files. A data analytics specialist must implement a solution to achieve this goal without changing the current S3 bucket configuration.
Which solution meets these requirements?

1. A. Use the exclude patterns feature of AWS Glue to identify the S3 Glacier files for the crawler to exclude.
2. B. Schedule an automation job that uses AWS Lambda to move files from the original S3 bucket to a new S3 bucket for S3 Glacier storage.
3. C. Use the excludeStorageClasses property in the AWS Glue Data Catalog table to exclude files on S3 Glacier storage
4. D. Use the include patterns feature of AWS Glue to identify the S3 Standard files for the crawler to include.

Correct Answer: A