AWS Certified Data Analytics Test 8

Which of the following options would be the most cost-effective solution for anomaly detection?

Select 1 option(s):

Weather station A has 20 sensors with each unique ID
Weather station B has 10 sensors with each unique ID
Onsite engineers strategically determined the placement and orientation of the weather stations. The company plans to use Amazon Kinesis Data Streams to collect data from each sensor.
A single Kinesis data stream with two shards was created based on the total data throughput gathered from the initial testing. The partition keys were created based on the two station names. A bottleneck on data coming from Station A has been spotted during the dry-run. However, there were no problems with Station B. Upon checking, it was inferred that the currently allocated throughput for the Kinesis Data Streams is still greater than the total stream throughput of the sensor data.
Which solution will resolve the bottleneck issue without increasing the overall cost?

Select 1 option(s):

Which among these steps will enable collection and enrichment based on the requirements stated above?

Select 1 option(s):

What should be done to fulfill this requirement?

Select 1 option(s):

Given that data arrives at inconsistent intervals, a Data Analyst must aggregate them so that related records fall into the same time-restricted window.
Which type of windowed query should be used?

Select 1 option(s):

How can the company efficiently set up a data logging system within AWS?

Select 1 option(s):

Which actions should the Data Analyst do to resolve this issue quickly? (Select TWO.)

Select 2 option(s):

How can the startup meet these requirements?

Select 1 option(s):

How can the team solve the problem while keeping the cost as low as possible?

Select 1 option(s):

Which solution achieves these requirements with the least operational overhead?

Select 1 option(s):

Which of the following is the most cost-effective solution for scheduling and executing the batch process?

Which of the following is NOT a best practice when choosing the best distribution style?

Select 1 option(s):

Which of the following is the most cost-effective solution to optimize query execution and avoid any downtime?

Select 1 option(s):

Which of the actions should the Data Analysts take to adjust the cluster performance?

Select 1 option(s):

What is the most likely reason for the returned classification string?

Select 1 option(s):

Which of the following is the most efficient way to expose the Hive metastore with minimal effort?

Select 1 option(s):

The manager received a report that the application increased its latency during peak times. Upon initial investigation, there are no ProvisionedThroughputExceededException errors found on the KCL logs and the CPU Utilization of the instances didn’t exceed its limit. The Data Analyst is instructed to implement a solution that will resolve the latency problem.
Which of the following is the best approach to solve this issue?

Select 1 option(s):

What solution will allow the company to meet these requirements?

Select 1 option(s):

Which solution will meet these requirements?

Select 1 option(s):

Which of the following actions will help improve the data loading times?

Select 1 option(s):

Historical weather data is approximately 25 TB uncompressed.
Every 30 minutes, there will be single-row inserts (Low volume)
Thousands of aggregation queries each day (High volume)
There is a need to perform multiple complex joins.
A small subset of the columns in a table is usually involved when querying data.
Which storage service will provide the MOST suitable solution?

Select 1 option(s):

Which of the following MOST likely explains why some data are inaccessible?

Select 1 option(s):

The IT operations team generates an hourly performance report that uses the data for the current month.
The accounting team needs to run a financial health check report daily based on last month’s data and an investor report monthly for the previous 12 months.
The management team wants a visual data dashboard that automatically updates itself based on the last 30 days of data as soon as it gets committed in the backend.
Which of the following is the most cost-effective solution that meets all the above requirements?

Select 1 option(s):

Which of the following is the most cost-effective solution to implement?

Select 1 option(s):

What is most likely causing the issue?

Select 1 option(s):

The firm wants to use Amazon Athena to study data changes over time that are stored in those files. Also, the cost of running Athena queries must be optimized.
Which steps will have the MOST impact on lowering the costs? (Select TWO.)

Select 2 option(s):

Which of the following options could help fulfill this task?

Select 1 option(s):

Which of the following are most likely causing the latency? (Select TWO)

Select 2 option(s):

What should the manager do to achieve this?

Select 1 option(s):

The group plans to build an Amazon S3 data lake to store metrics in .csv format and query data through Amazon Athena. As the data lake grows, the group wants to improve query performance by optimizing their storage solution.
Which optimization methods could be done to satisfy these requirements? (Select THREE.)

Select 3 option(s):

Which of the following can be done to achieve this requirement with the least amount of effort?

Select 1 option(s):

Which set of steps should the data engineer do?

Select 1 option(s):

Which of the following is the FASTEST way to accomplish this?

Select 1 option(s):

Which of the following methods is the most cost-efficient solution for the new process?

Select 1 option(s):

Which method meets these requirements?

Select 1 option(s):

Support Open Database Connectivity (ODBC) connections
Manage metadata that allows federation for access control
Perform ETL batch workloads using PySpark and Scala
As much as possible, the operational management of the solution should be limited.
Which of the following combinations of services can satisfy the requirements? (Select THREE.)

Select 3 option(s):

Which of the following options will provide optimal performance and a cost-effective solution based on the requirements?

Select 1 option(s):

The Data Analyst later observed that every time the stream was resharded, the out-of-order records from the same user ID arrived from different shards.
What is most likely causing the issue and how should the Data Analyst fix this?

Select 1 option(s):

The administrator was tasked to enforce role-based access controls for the data lake. Junior Data Analysts from each unit should only have read access to their data. Senior Data Analysts, on the other hand, is allowed to have access in all business units, but for specific columns only.
Which solution will minimize operational overhead and reduce overall costs while meeting the required access patterns?

Select 1 option(s):

Select 1 option(s):

Which configuration will allow the cluster to access the encrypted data?

Select 1 option(s):

Which of the following should be implemented to achieve this requirement?

Select 1 option(s):

An Amazon Redshift cluster is also used as the data warehouse and is currently used by various departments. The data analyst team needs to build a loading workflow and process them without compromising the sensitive data.
What should they do to achieve this task?

Select 1 option(s):

Which is the MOST suitable solution for the scenario?

Select 1 option(s):

Which encryption method should the company use?

Select 1 option(s):

During configuration, one of the members has launched Amazon QuickSight in the Singapore Region. The group is experiencing issues associating Amazon QuickSight from the Singapore Region to the cluster in N. Virginia Region.
Which of the following configurations should be performed to solve the issue?

Select 1 option(s):

How can the Data Analyst secure this table and allow only privileged users to read the columns containing confidential data with the least maintenance overhead?

Select 1 option(s):

Which of the following options would encrypt the EMR cluster’s root volumes?

Select 1 option(s):

Which of the following actions will help meet the EMR compliance requirements with the least amount of effort?

Select 1 option(s):

Which steps should be followed to achieve their goal?

Select 1 option(s):

Which steps should the Data Analyst take to enable logging in the cluster and meet the requirements in the most efficient manner and with the least maintenance overhead? (Select THREE.)

Select 3 option(s):

How can the data engineer meet these requirements in the shortest amount of time and in the MOST cost-effective manner?

Select 1 option(s):

Which of the following is the best approach to satisfy this requirement?

Select 1 option(s):

Needs to support transformations of 500 GB data with varying file formats being loaded in Amazon S3 at a scheduled time every day.
Needs to support one-time transformations of terabytes of data archived in the Amazon S3 data lake.
The company seeks a cost-effective solution that meets the requirement.
Which combination of solutions should the company implement? (Select THREE.)

Select 3 option(s):

Which configuration must be done to recover missing data in case of application error?

Select 1 option(s):

Which of the following should be implemented to meet the above requirements?

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):