AWS Certified Data Analytics Test 3

What is the most efficient way to build your real-time visualization for your management team?

Select 1 option(s):

Since the data warehouse you are creating houses Personally Identifiable Information (PII), you need to restrict access to your Redshift data warehouse tables. In the simplest way possible, how can you restrict access so that users only can retrieve the information they need at the most granular level?

Select 1 option(s):

Select 1 option(s):

You need to make sure your EMR cluster data is encrypted at rest. Which of the following options is NOT a valid encryption approach for EMR encryption at rest?

Select 1 option(s):

Because your company develops software solutions for the healthcare industry, you are required by Health Insurance Portability and Accountability Act (HIPAA) regulations to record all changes to your data stores for auditing purposes. To this end, you need to record each time your Elasticache Memcached cache engine scales out or in, adding and removing nodes based on changes to the demand on your system. How would you most efficiently implement this monitoring in your infrastructure?

Select 1 option(s):

Which option is the most efficient and performant method of migrating your database resources?

Select 1 option(s):

You have been instructed to start your DMS Change Data Capture (CDC) task from the starting point of 2 weeks after the acquisition migration began, which is May 15, 2020. What CDC task should you use to accomplish your ongoing replication activity?

Select 1 option(s):

Due to the high availability and response time requirements of your data lake you have decided to use EMR as your big data platform. What features of EMR can you use to make your EMR cluster highly available in the most cost effective manner?

Select 1 option(s):

You need to create Apache Spark applications and run interactive queries on your EMR cluster to gain insight into your company’s sales and partner performance with minimal effort. You also need to give your fellow data scientists access to create Apache Spark applications.
Which option gives you the simplest, most cost effective operation for your data processing solution?

Select 1 option(s):

You need data from your containers, their transport facility (plane, boat, truck) and other key data for your real-time analytics applications that attempt to solve the logistics optimization problem for each container. These applications also need to update the optimized routes based on real-time changes in route attributes, such as obstructions, etc.
How should you define your data processing solution so that it is highly available and provides real-time query capabilities across your very large data lake?

Select 1 option(s):

What option is the most efficient and most performant that gives you the transformation of your data for analysis at the processing rate you need?

Select 1 option(s):

Your data scientists have asked you to incorporate data from an additional data source. This will require you to add additional steps to your cluster. How would you accomplish this in the most efficient manner?

Select 1 option(s):

You have been tasked with producing a Pig program that allows your data scientists to generate reports detailing their food production by region and supplier. When you add your Pig program as a step in your EMR cluster you need to define what action to take on failure. Which of the following is NOT a valid action on failure?

Select 1 option(s):

Which option describes the most cost efficient way to manage this data collection system?

Select 1 option(s):

You have built a data collection system that leverages Kinesis Data Streams to gather the sensor data. You have also built Kinesis Consumer Library applications to consume the stream data and write it to S3.
You have noticed in your initial roll out of your data collection stream that on heavy transport activity days you experience hot shard conditions. What monitoring of your Kinesis Data Streams environment will help you best manage your shard scaling activities? (SELECT TWO)

Select 2 option(s):

Your management team wants the real-time analytics and real-time metrics analytics applications to be fault tolerant and also scale when volume increases or decreases, thereby saving your company money.
Which option will give you the appropriate data analysis solution for your scenario in the most cost effective manner?

Select 1 option(s):

You wish to build a data processing solution using Kinesis Data Streams and take advantage of the record aggregation and deaggregation features of Kinesis Data Streams producers and consumers. Your Kinesis Data stream will feed you Kinesis Data Analytics applications used to produce data analytics dashboards for your management team. You are also making an effort to use serverless technology whenever possible. Your staff is made up of highly proficient Python programmers.
Which option below gives you the best technology to build your data processing solution based on your staff profile and in the most cost effective manner?

Select 1 option(s):

You need to control access to your Kinesis Data Analytics application using authentication. Which option gives you the most secure and most cost effective way to authenticate your client users?

Select 1 option(s):

Which option gives the optimal data visualization solution for your needs that is the most cost efficient?

Select 1 option(s):

The streaming data is captured in a Kinesis Data stream which outputs to a Kinesis Data Analytics SQL application. Your Kinesis Data Analytics SQL application transforms the exercise data by merging exercise frequency with exercise session choice and exercise premature exit, for example. You then use a Lambda function for your destination of your Kinesis Data Analytics SQL application where you want to further transform the data to prepare it for use in your DynamoDB database.
However, when you test your Kinesis Data Analytics SQL application Lambda destination you notice that your Lambda function fails to process your streaming records. What might be the root cause of your problem?

Select 1 option(s):

You and your team are in the process of creating your EMR cluster that you’ll use to populate your S3 data lake. Your team lead has emphasized that the cluster must be integrated with your corporate Active Directory domain for authentication of user access to the EMR cluster. You need to have your users access your EMR cluster with their domain user account when they use SSH to connect to your cluster or work with your data analytics applications.
Which option gives you the corporate Active Directory domain authentication for user access that is required for data lake in the most efficient manner?

Select 1 option(s):

You have built a data lake in S3 where you collect all trading data in CSV formatted files in a ‘daily_trading’ prefix in your ‘trading’ bucket. You are using Athena to query the trading files in your S3 data lake, where the files list for the daily_trading prefix looks like this:
            20200604-trades.csv
            20200603-trades.csv
            20200602-trades.csv
            …
In your attempt to build your table for the 20200604-trades.csv data in Athena you run your Glue crawler to crawl data in a specified path as such: include s3://trading/daily_trading/20200604-trades.csv
When you query the resulting table in the Athena query editor you find that the table is in your Glue catalog database but returns no rows when you run a select * on it. What may be the root of the problem?

Select 1 option(s):

You have used Glue to crawl your data sources and populate your Glue data catalog. You have also built views of your data in Athena that you wish to store as new tables in a columnar format so that you can have very fast performance when your management team wishes to run these views repeatedly.
What happens in Athena when you create a table from a view?

Select 1 option(s):

You also have several in-house data stores that you need to periodically load into your S3 data lake. To that end you are creating a Glue ETL job. The Glue ETL job also needs to encrypt its target data and CloudWatch logs. Which of the following options is the most efficient method to achieve this end goal?

Select 1 option(s):

What is the best way to accomplish the example data cleansing goal?

Select 1 option(s):

Due to the sensitive nature of your firm’s data stored in your data lake, you need to make sure your data is encrypted at rest in your S3 buckets. You are in the process of writing a Glue crawler to crawl your various siloed systems in preparation for running Glue ETL jobs to extract your data to your S3 data lake.
You need to make sure your Glue crawler and ETL jobs use the appropriate security settings so that your resulting S3 data files are encrypted. Which option gives you the appropriate security for your data in S3?

Select 1 option(s):

Due to the sensitive nature of the data, all the data in your S3 data lake is encrypted at rest. How will you ensure that the data you query from your data lake using Athena is encrypted from beginning to end when used in the Athena service?

Select 1 option(s):

To supply the equity data you are building a data processing solution that needs to provide real-time and batch data feeds to your traders in the most efficient manner. These data feeds need to be processed, transformed, aggregated, etc. Which of the following options meets your data processing solution requirements?

Select 1 option(s):

You have the Kinesis Agent running on your web servers gathering your server log data. You have 10 shards set up in your Kinesis Data Stream. You are processing your log data using a Spark Streaming application that you and your team are writing. Which of the following is NOT true about the operational characteristics of your collection system?

Select 1 option(s):

You now wish to load this data into your DynamoDB tables to use as the data source for your recommendation engine feature. However, you need to first clean your streaming data, for example by removing any duplicate records for a particular user in the stream. You have decided to incorporate the AWS Glue ML Transforms feature into your Glue ETL job to perform this task.
When you are configuring your ML Transform task run properties, which task worker type should you choose?

Select 1 option(s):