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

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.

A company has developed an Apache Hive script to batch process data stared in Amazon S3. The script needs to run once every day and store the output in Amazon S3. The company tested the script, and it completes within 30 minutes on a small local three-node cluster.
Which solution is the MOST cost-effective for scheduling and executing the script?

1. A. Create an AWS Lambda function to spin up an Amazon EMR cluster with a Hive execution ste
2. B. Set KeepJobFlowAliveWhenNoSteps to false and disable the termination protection fla
3. C. Use Amazon CloudWatch Events to schedule the Lambda function to run daily.
4. D. Use the AWS Management Console to spin up an Amazon EMR cluster with Python Hu
5. E. Hive, and Apache Oozi
6. F. Set the termination protection flag to true and use Spot Instances for the core nodes of the cluste
7. G. Configure an Oozie workflow in the cluster to invoke the Hive script daily.
8. H. Create an AWS Glue job with the Hive script to perform the batch operatio
9. I. Configure the job to run once a day using a time-based schedule.
10. J. Use AWS Lambda layers and load the Hive runtime to AWS Lambda and copy the Hive script.Schedule the Lambda function to run daily by creating a workflow using AWS Step Functions.

Correct Answer: C

A data engineer is using AWS Glue ETL jobs to process data at frequent intervals The processed data is then copied into Amazon S3 The ETL jobs run every 15 minutes. The AWS Glue Data Catalog partitions need to be updated automatically after the completion of each job
Which solution will meet these requirements MOST cost-effectively?

1. A. Use the AWS Glue Data Catalog to manage the data catalog Define an AWS Glue workflow for the ETL process Define a trigger within the workflow that can start the crawler when an ETL job run is complete
2. B. Use the AWS Glue Data Catalog to manage the data catalog Use AWS Glue Studio to manage ETL job
3. C. Use the AWS Glue Studio feature that supports updates to the AWS Glue Data Catalog during job runs.
4. D. Use an Apache Hive metastore to manage the data catalog Update the AWS Glue ETL code to include the enableUpdateCatalog and partitionKeys arguments.
5. E. Use the AWS Glue Data Catalog to manage the data catalog Update the AWS Glue ETL code to include the enableUpdateCatalog and partitionKeys arguments.

Correct Answer: A

A technology company is creating a dashboard that will visualize and analyze time-sensitive data. The data will come in through Amazon Kinesis Data Firehose with the butter interval set to 60 seconds. The dashboard must support near-real-time data.
Which visualization solution will meet these requirements?

1. A. Select Amazon Elasticsearch Service (Amazon ES) as the endpoint for Kinesis Data Firehos
2. B. Set up a Kibana dashboard using the data in Amazon ES with the desired analyses and visualizations.
3. C. Select Amazon S3 as the endpoint for Kinesis Data Firehos
4. D. Read data into an Amazon SageMaker Jupyter notebook and carry out the desired analyses and visualizations.
5. E. Select Amazon Redshift as the endpoint for Kinesis Data Firehos
6. F. Connect Amazon QuickSight with SPICE to Amazon Redshift to create the desired analyses and visualizations.
7. G. Select Amazon S3 as the endpoint for Kinesis Data Firehos
8. H. Use AWS Glue to catalog the data and Amazon Athena to query i
9. I. Connect Amazon QuickSight with SPICE to Athena to create the desired analyses and visualizations.

Correct Answer: A