AWS-Certified-Data-Analytics-Specialty Free Practice Test

A company that produces network devices has millions of users. Data is collected from the devices on an hourly basis and stored in an Amazon S3 data lake.
The company runs analyses on the last 24 hours of data flow logs for abnormality detection and to
troubleshoot and resolve user issues. The company also analyzes historical logs dating back 2 years to discover patterns and look for improvement opportunities.
The data flow logs contain many metrics, such as date, timestamp, source IP, and target IP. There are about 10 billion events every day.
How should this data be stored for optimal performance?

1. A. In Apache ORC partitioned by date and sorted by source IP
2. B. In compressed .csv partitioned by date and sorted by source IP
3. C. In Apache Parquet partitioned by source IP and sorted by date
4. D. In compressed nested JSON partitioned by source IP and sorted by date

Correct Answer: A

A banking company wants to collect large volumes of transactional data using Amazon Kinesis Data Streams for real-time analytics. The company uses PutRecord to send data to Amazon Kinesis, and has observed network outages during certain times of the day. The company wants to obtain exactly once semantics for the entire processing pipeline.
What should the company do to obtain these characteristics?

1. A. Design the application so it can remove duplicates during processing be embedding a unique ID in each record.
2. B. Rely on the processing semantics of Amazon Kinesis Data Analytics to avoid duplicate processing of events.
3. C. Design the data producer so events are not ingested into Kinesis Data Streams multiple times.
4. D. Rely on the exactly one processing semantics of Apache Flink and Apache Spark Streaming included in Amazon EMR.

Correct Answer: A

A large financial company is running its ETL process. Part of this process is to move data from Amazon S3 into an Amazon Redshift cluster. The company wants to use the most cost-efficient method to load the dataset into Amazon Redshift.
Which combination of steps would meet these requirements? (Choose two.)

1. A. Use the COPY command with the manifest file to load data into Amazon Redshift.
2. B. Use S3DistCp to load files into Amazon Redshift.
3. C. Use temporary staging tables during the loading process.
4. D. Use the UNLOAD command to upload data into Amazon Redshift.
5. E. Use Amazon Redshift Spectrum to query files from Amazon S3.

Correct Answer: AC

A company is building an analytical solution that includes Amazon S3 as data lake storage and Amazon Redshift for data warehousing. The company wants to use Amazon Redshift Spectrum to query the data that is stored in Amazon S3.
Which steps should the company take to improve performance when the company uses Amazon Redshift Spectrum to query the S3 data files? (Select THREE )
Use gzip compression with individual file sizes of 1-5 GB

1. A. Use a columnar storage file format
2. B. Partition the data based on the most common query predicates
3. C. Split the data into KB-sized files.
4. D. Keep all files about the same size.
5. E. Use file formats that are not splittable

Correct Answer: BCD

A manufacturing company wants to create an operational analytics dashboard to visualize metrics from equipment in near-real time. The company uses Amazon Kinesis Data Streams to stream the data to other applications. The dashboard must automatically refresh every 5 seconds. A data analytics specialist must design a solution that requires the least possible implementation effort.
Which solution meets these requirements?

1. A. Use Amazon Kinesis Data Firehose to store the data in Amazon S3. Use Amazon QuickSight to build the dashboard.
2. B. Use Apache Spark Streaming on Amazon EMR to read the data in near-real tim
3. C. Develop a custom application for the dashboard by using D3.js.
4. D. Use Amazon Kinesis Data Firehose to push the data into an Amazon Elasticsearch Service (Amazon ES) cluste
5. E. Visualize the data by using a Kibana dashboard.
6. F. Use AWS Glue streaming ETL to store the data in Amazon S3. Use Amazon QuickSight to build the dashboard.

Correct Answer: B