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

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

Once a month, a company receives a 100 MB .csv file compressed with gzip. The file contains 50,000 property listing records and is stored in Amazon S3 Glacier. The company needs its data analyst to query a subset of the data for a specific vendor.
What is the most cost-effective solution?

1. A. Load the data into Amazon S3 and query it with Amazon S3 Select.
2. B. Query the data from Amazon S3 Glacier directly with Amazon Glacier Select.
3. C. Load the data to Amazon S3 and query it with Amazon Athena.
4. D. Load the data to Amazon S3 and query it with Amazon Redshift Spectrum.

Correct Answer: A

A data analyst runs a large number of data manipulation language (DML) queries by using Amazon Athena with the JDBC driver. Recently, a query failed after It ran for 30 minutes. The query returned the following message Java.sql.SGLException: Query timeout
The data analyst does not immediately need the query results However, the data analyst needs a long-term solution for this problem
Which solution will meet these requirements?

1. A. Split the query into smaller queries to search smaller subsets of data.
2. B. In the settings for Athena, adjust the DML query timeout limit
3. C. In the Service Quotas console, request an increase for the DML query timeout
4. D. Save the tables as compressed .csv files

Correct Answer: A

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?

1. 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
2. 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
3. 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
4. D. Use Amazon Kinesis Data Analytics to create an in-application table based upon the reference dataProcess incoming data from Kinesis Data Streams Use an Amazon Kinesis Data Firehose delivery stream to write results to Amazon Redshift

Correct Answer: D

A market data company aggregates external data sources to create a detailed view of product consumption in different countries. The company wants to sell this data to external parties through a subscription. To achieve this goal, the company needs to make its data securely available to external parties who are also AWS users.
What should the company do to meet these requirements with the LEAST operational overhead?

1. A. Store the data in Amazon S3. Share the data by using presigned URLs for security.
2. B. Store the data in Amazon S3. Share the data by using S3 bucket ACLs.
3. C. Upload the data to AWS Data Exchange for storag
4. D. Share the data by using presigned URLs for security.
5. E. Upload the data to AWS Data Exchange for storag
6. F. Share the data by using the AWS Data Exchange sharing wizard.

Correct Answer: A