AWS Certified Data Analytics Test 6

Welcome to your AWS Certified Data Analytics - Test-6

Name

Phone

Q1. You are planning to use the AWS EMR service to create instances which make use of the Hadoop software. But apart from the Hadoop software , you also need some custom software to be installed on these systems. Which is the best way to get the custom software installed on instances which are launched as part of the cluster

Select 1 option(s):

A. Ensure that the EMR Cluster configuration has the location in S3 for the custom software

B. Ensure that the EMR Cluster Instance configuration has the location in S3 for the custom software

C. Use the Bootstrap actions to install the custom software

D. Use Cloudwatch agents to install the custom software

Q2. You are planning on migrating an on-premise Oracle Database to AWS MySQL. You want to create the schema beforehand on the AWS MySQL Instance. Which of the following is the easiest approaches in getting this done?

Select 1 option(s):

A. Use the AWS Schema Conversion Tool to generate the schema in the target database

B. Use the AWS Config Tool to generate the schema in the target database

C. Create scripts to generate the schema in the target database

D. Use the AWS Database Generation Tool to generate the schema in the target database

Q3. You currently have a Redshift cluster with automated snapshots. You need to maintain a particular snapshot for a period of 2 months. How can you achieve this?

Select 1 option(s):

A. Ensure that automated snapshots setting is set to 60 days

B. Send a request to AWS to increase the duration of the snapshot

C. Create another Redshift cluster from the automated snapshot

D. Create a manual snapshot from the automated snapshot

Q4. You currently have an orders table defined in Redshift. This orders table has a sort key defined on the columns orders_date. You are now planning on loading data into the Redshift table month wise. Which is the most efficient way to load this data.

Select 1 option(s):

A. Load the data using the LOAD command and ensure the data is loaded in sort key order

B. Load the data using the COPY command and ensure the data is loaded in sort key order

C. Load the data using the LOAD command directly because this will be the fastest.

D. Load the data using the COPY command directly because this will be the fastest.

Q5. You currently have a test environment which consists of a Redshift cluster. Now that the testing phase is complete , this cluster is going to be used for production use wherein the nodes are going to be used for prolonged periods of time. Which of the following steps can be taken to reduce the costs for the Redshift Cluster.

Select 1 option(s):

A. Use the On-demand nodes so that they can be shutdown whenever required.

B. Use Spot Instances because they are cheaper than On-Demand instances

C. Use Reserved instances for better overall discounts

D. Use Consolidating billing to reduce the costsA.

Q6. If you need to enable server side data encryption with Amazon Kinesis Data Firehose , which of the following can be used as the data source to ensure that the encryption can be possible

Select 1 option(s):

A. Kinesis streams

B. DynamoDB

C. Simple Storage Service

D. Redshift

Q7. You are trying to terminate an EMR Cluster but are unable to do. Which of the following could be a possible reason for this.

Select 1 option(s):

A. The underlying EC2 Instances have EBS Volumes attached.

B. The termination protection set on the cluster

C. There is an underlying snapshot created on the cluster

D. There are security groups specified on the underlying EC2 Instances

Q8. Your company has an enterprise application that requires key-value storage as the database. The data is expected to be about 100 GB the first month and grow to 2PB over the next couple of years. There are no other query requirements at this time. Which one of the below solutions would assist in this case.

Select 1 option(s):

A. HBase on HDFS

B. Hadoop with Spark

C. DynamoDB

D. AWS RDS

Q9. There is a redshift table created in AWS. There is a requirement to ensure that the table can be frequently used in join level queries. Which of the following distribution styles would you utilize for the table

Select 1 option(s):

A. PARTITION

B. EVEN

C. KEY

D. ALL

Q10. You have a defined a local secondary index for a DynamoDB table. You are then performing queries against the index , but the performance is not ideal as expected. Which of the following can reduce the performance of querying an index when using the Local Secondary Index

Select 1 option(s):

A. When querying a partition key that is not present in the LSI

B. When querying for a projected attribute

C. When querying for a non-projected attribute

D. When querying for a different sort key value

Q11. Which of the following can be used to move extremely large amounts of data to AWS with up to 100 PB per device

Select 1 option(s):

A. AWS Snowmobile

B. AWS Snowball

C. AWS Import/Export

D. AWS S3 Export

Q12. Which of the following is true with regards to the current limitation on AWS Kinesis shards. Choose 2 answers from the options below

Select 2 option(s):

A. Each shard can support up to 5 transactions per second for reads

B. Each shard can support up to 10 transactions per second for reads

C. The maximum total data read rate is 1 MB per second

D. The maximum total data read rate is 2 MB per second

Q13. What is the current maximum total data read rate for a Kinesis shard

Select 1 option(s):

A. 1 MB per second

B. 2 MB per second

C. 5 MB per second

D. 10 MB per second

Q14. While using an Amazon Aurora DB Cluster you are getting the below error

ERROR 3 (HY000): Error writing file ‘/rdsdbdata/tmp/XXXXXXXX’ (Errcode: 28 – No space left on device)
What could be done to resolve this error

Select 1 option(s):

A. Add more EBS storage to the under EC2 Instances

B. Use optimized EBS storage instead of SSD

C. Use a different underlying instance type

D. Use Instance store volumes instead

Q15. Which of the following of DynamoDB is an index with a partition key and a sort key that can be different from those on the base table

Select 1 option(s):

A. Global Primary Index

B. Global Secondary Index

C. Local Primary Index

D. Local Secondary Index

Q16. Which of the below mechanisms is not used for authentication of IoT devices for AWS IoT

Select 1 option(s):

A. KMS

B. IAM users, groups, and roles

C. X.509 certificates

D. Amazon Cognito identities

Q17. If there is a requirement for Redshift for performance-intensive workloads which of the following instance types should be used for the underlying nodes.

Select 2 option(s):

A. DS1 Node type

B. DC1 Node type

C. DS2 Node type

D. DC2 Node type

Q18. Which of the following in a DynamoDB-compatible caching service?

Select 1 option(s):

A. Redis

B. Memcache

C. DAX

D. DynaCache

Q19. Which of the following activities can be used to copy data from Amazon S3 to Amazon Redshift?

Select 1 option(s):

A. S3CopyActivity

B. RedshiftCopyActivity

C. S3RedshiftCopyActivity

D. EmrActivity

Q20. To which of the following can Kinesis consumers store their results in? Choose 3 answers from the options given below

Select 3 option(s):

A. Amazon S3

B. DynamoDB

C. Glacier

D. Amazon Redshift

Q21. Which of the following is used by the AWS Athena service in partitioning data?

Select 1 option(s):

A. EMR

B. Hive

C. D3.js

D. Logstash

Q22. You have just created a Redshift cluster in AWS. You are trying to use SQL Client tools from an EC2 Instance, but you are not able to connect to the Redshift Cluster. What must you do to ensure that you are able to connect to the Redshift Cluster from the EC2 Instance?

Select 1 option(s):

A. Install Redshift client tools on the EC2 Instance first.

B. Modify the VPC Security Groups

C. Use the AWS CLI instead of the Redshift client tools.

D. Modify the NACL on the subnet

Q23. Amazon Athena is known to be highly available and durable. What is the underlying data store for Amazon Athena that makes it so highly available and durable

Select 1 option(s):

A. Amazon DynamoDB

B. Amazon S3

C. Amazon Redshift

D. Amazon EMR

Q24. You need to use AWS services which would meet the following requirements

a) Ability to load streaming data
b) Ability to have scalable private connections to on-premise data centers
Which of the below mentioned services would meet this requirement. Choose 2 answers from the options given below

Select 2 option(s):

A. Data Migration Services

B. Direct Connect

C. Kinesis Firehose

D. Snowball

Q25. You need to transfer data from an on-premise MySQL database to Amazon Aurora. Which of the following service is the ideal service to fulfil this requirement.

Select 1 option(s):

A. AWS Kinesis

B. AWS Data Pipeline

C. AWS RDS

D. AWS Data Migration Service

Q26. Which of the following services can be used to automate the movement and transformation of data in AWS?

Select 1 option(s):

A. AWS DynamoDB

B. AWS DataPipeline

C. AWS Redshift

D. AWS ElasticSearch

Q27. Where does the query results from Athena get stored?

Select 1 option(s):

A. In DynamoDB

B. In Amazon S3

C. In AWS EMR

D. In a separate Athena repository

Q28. Which of the following operations are available for scaling a Redshift Cluster

Select 1 option(s):

A. Scale the cluster in or out by changing the number of nodes

B. Scale the cluster up or down by specifying a different node type

C. Use the snapshot and restore operations to make a copy of an existing cluster. Then, resize the new cluster

D. All of the above

Q29. You need real-time reporting on logs that are being generated from your applications. In addition, you need anomaly detection. The processing latency needs to as less as possible. Out of the below options , choose 2 answers that would be able to fulfil this requirement.

Select 2 option(s):

A. AWS Firehose

B. Apache Spark

C. MLib

D. Athena

Q30. Which of the following is an open source deep learning framework?

Select 1 option(s):

A. Jupyter

B. D3.js

C. AWS ML

D. Apache MXNet

Q31. Your application requires long-term storage for backups and other data that you need to keep readily available but with lower cost. Which S3 storage option should you use?

Select 1 option(s):

A. AWS S3 Standard - Infrequent Access

B. AWS S3 Standard

C. AWS Glacier

D. AWS Reduced Redundancy Storage

Q32. You are currently using a Redshift table which stores data for an order processing system. This table has witnessed a large number of update/delete operations over a period of time. Recently you have noticed that the performance on the table has degraded. What can be done to improve the performance of the Redshift table?

Select 1 option(s):

A. Increase the Read and Write capacity units for the table

B. Add another table and start adding data to that table

C. Perform the vacuum operation for the table

D. Perform the cleanup operations for the table

Q33. Which of the following commands can be used to transfer data from DynamoDB to Redshift?

Select 1 option(s):

A. COPY

B. EXPORT

C. UNLOAD

D. DistCp

Q34. You currently have data in DynamoDB tables. You have a requirement to perform complex data analysis queries on the data stored in the DynamoDB tables. How can this be achieved?

Select 1 option(s):

A. Query the DynamoDB tables , since it support complex queries.

B. Copy the data on AWS EMR and then perform the complex queries

C. Copy the data on AWS Quicksight and then perform the complex queries

D. Copy the data on AWS Redshift and then perform the complex queries

Q35. Which of the following is a business analytics service provided by AWS?

Select 1 option(s):

A. Microstrategy

B. PowerBI

C. QuickSight

D. Business Objects

Q36. Which of the following services can be used as a business analytics service that can be used to build visualizations

Select 1 option(s):

A. AWS Quicksight

B. AWS Visualizer

C. AWS EMR

D. AWS Kinesis

Q37. You currently work for a company that looks at baggage handling. There are GPS devices located on the baggage delivery units to deliver the coordinates of the unit every 10 seconds. You need to process these coordinates in real-time from multiple sources. Which tool should you use to digest the data

Select 1 option(s):

A. Amazon EMR

B. Amazon SQS

C. AWS Data Pipeline

D. Amazon Kinesis

Q38. A company releases new features with high frequency while demanding high application availability. As part of the application’s testing, logs from each updated Amazon EC2 instance of the application need to be analyzed in near real-time, to ensure that the application is working flawlessly after each deployment. Which of the following methods should you use for shipping and analyzing the logs in a highly available manner?

Select 1 option(s):

A. Ship the logs to Amazon S3 for durability and use Amazon Redshift to analyze the logs in a batch manner each hour

B. Ship the logs to Amazon CloudWatch Logs and use Amazon EMR to analyze the logs in a batch manner each hour

C. Ship the logs to an Amazon Kinesis stream and have the consumers analyze the logs in a live manner

D. Ship the logs to a large Amazon EC2 instance and analyze the logs in a live manner

Q39. You work for a startup that tracks commercial deliver IoT enabled devices via GPS. You receive coordinates are transmitted from each device once every 6 seconds. You need to process these coordinates in real-time from multiple sources. Which tool should you use to digest the data?

Select 1 option(s):

A. Amazon EMR

B. Amazon SQS

C. AWS Data Pipeline

D. Amazon Kinesis

Q40. Which of the below is a fully managed service that can be used to deliver real-time streaming data to S3.

Select 1 option(s):

A. EMR

B. Redshift

C. Kinesis Firehose

D. RDS

Q44. When estimating the cost of using EMR, which of the following parameters should you consider. Choose 3 answers from the options given below

Select 3 option(s):

A. The price of the EMR service

B. The price of the underlying EC2 Instances

C. The price of the underlying VPC

D. The price of EBS storage if used.

Q45. Which of the below services can be used to move large amounts of data into and out if AWS S3.

Select 1 option(s):

A. AWS Kinesis

B. AWS SQS

C. AWS IoT

D. AWS EMR

Q46. There is a requirement to analyze a large set of data updates from Kinesis and DynamoDB. Which of the following tools can be used for this purpose.

Select 1 option(s):

A. Elasticsearch

B. EMR

C. Quicksight

D. Redshift

Q47. You need to search through the logs stored in the Cloudwatch logs service. Which of the following services can be used for this purpose.

Select 1 option(s):

A. Elastic Map Reduce

B. Elastic Cache

C. Cloudtrail

D. Elasticsearch

Q48. There is a requirement to analyze a large set of data updates from Kinesis and DynamoDB. Which Big Data tool would be ideal for this scenario?

Choose the correct answer:

Select 1 option(s):

A. EMR

B. Elasticsearch

C. Redshift

D. SQS

Q49. You have a set of web servers that deliver their logs to Cloudwatch Logs. There is a requirement to perform a search on Cloudwatch logs for certain types of errors. Which of the below services would be recommended for this requirement

Select 1 option(s):

A. Elastic Map Reduce

B. AWS Redshift

C. AWS Elastic Search

D. AWS Config

Q50. A company is building an application that needs to have a NoSQL backend store. Initially there is a notion that 1000 reads and writes per minute will occur on the database. And later , when the application becomes more popular, the I/O requirement could move to 10,000 reads and writes per minute. Which of the following data stores would be ideal for the application

Select 1 option(s):

A. Amazon EMR

B. Amazon DynamoDB

C. Amazon Redshift

D. Amazon RDS

Q51. You are configuring a number of IoT devices with AWS IoT. You are planning on using the current Google credentials already in place for authentication. Which of the following is recommended for this sort of authentication

Select 1 option(s):

A. Using Amazon Cognito

B. Using X.509 certificates

C. Using IAM Users

D. Using IAM Roles

Q52. Which of the following serverless service can be used to run ad-hoc queries for data in S3

Select 1 option(s):

A. EMR

B. Athena

C. SQS

D. Redshift

Q53. Which of the following can be used to improve efficiency when using the Kinesis Producer library? Choose 2 answers from the options given below

Select 2 option(s):

A. Using more shards

B. Aggregation

C. Using Collections

D. Using Server side encryption

Q54. What is the term given to a group of data records in a stream in AWS Kinesis

Select 1 option(s):

A. Consumer

B. Batch

C. Shard

D. Group Stream

Q55. You currently have web servers that put data from their log files onto Kinesis streams. In this scenario what role are the web servers playing

Select 1 option(s):

A. The consumers role

B. The producers role

C. The data stream role

D. The stream role

Q56. You are working with a Kinesis Stream. What is used to group data by shard within a stream?

Select 1 option(s):

A. Partition Key

B. Record Id

C. Hash Key

D. Sequence Number

Q57. An application is currently writing a large number of records to a DynamoDB table in one region. There is a requirement for a secondary application to just take in the changes to the DynamoDB table every 2 hours and process the updates accordingly. Which of the following is an ideal way to ensure the secondary application can get the relevant changes from the DynamoDB table.

Select 1 option(s):

A. Insert a timestamp for each record and then scan the entire table for the timestamp as per the last 2 hours.

B. Create another DynamoDB table with the records modified in the last 2 hours.

C. Use DynamoDB streams to monitor the changes in the DynamoDB table.

D. Transfer the records to S3 which were modified in the last 2 hours

Q58. When using Autoscaling with EMR, which of the following properties of Autoscaling can ensure that when a scale out activity happens , enough time is given for the entire cluster to stabilize based on the new instance addition

Select 1 option(s):

A. Evaluation Period

B. Cooldown period

C. Timeout period

D. ScaleUp period

Q59. Which of the following statements are true about secondary indexes in DynamoDB. Choose 2 answers from the options given below

Select 2 option(s):

A. For the global secondary index , the partition key and sort key can be different from those on the base table

B. For the global secondary index , the partition key and sort key cannot be different from those on the base table

C. For the local secondary index , the partition key is the same as the base table.

D. For the local secondary index , the partition key is different from the base table.

Q60. There is a requirement for EC2 Instances in your private subnet to access DynamoDB tables. How can this be achieved.

Select 1 option(s):

A. Convert the private subnet to a public subnet since this is the only way for the access to be achieved

B. Attach a virtual private gateway to the VPC

C. Use a VPC endpoint

D. There is no way for instances in a private subnet to access DynamoDB tables

AWS Certified Data Analytics Test 6

Q2. You are planning on migrating an on-premise Oracle Database to AWS MySQL. You want to create the schema beforehand on the AWS MySQL Instance. Which of the following is the easiest approaches in getting this done?

Q3. You currently have a Redshift cluster with automated snapshots. You need to maintain a particular snapshot for a period of 2 months. How can you achieve this?

Q4. You currently have an orders table defined in Redshift. This orders table has a sort key defined on the columns orders_date. You are now planning on loading data into the Redshift table month wise. Which is the most efficient way to load this data.

Q6. If you need to enable server side data encryption with Amazon Kinesis Data Firehose , which of the following can be used as the data source to ensure that the encryption can be possible

Q7. You are trying to terminate an EMR Cluster but are unable to do. Which of the following could be a possible reason for this.

Q9. There is a redshift table created in AWS. There is a requirement to ensure that the table can be frequently used in join level queries. Which of the following distribution styles would you utilize for the table

Q10. You have a defined a local secondary index for a DynamoDB table. You are then performing queries against the index , but the performance is not ideal as expected. Which of the following can reduce the performance of querying an index when using the Local Secondary Index

Q11. Which of the following can be used to move extremely large amounts of data to AWS with up to 100 PB per device

Q12. Which of the following is true with regards to the current limitation on AWS Kinesis shards. Choose 2 answers from the options below

Q13. What is the current maximum total data read rate for a Kinesis shard

Q14. While using an Amazon Aurora DB Cluster you are getting the below error

Q15. Which of the following of DynamoDB is an index with a partition key and a sort key that can be different from those on the base table

Q16. Which of the below mechanisms is not used for authentication of IoT devices for AWS IoT

Q17. If there is a requirement for Redshift for performance-intensive workloads which of the following instance types should be used for the underlying nodes.

Q18. Which of the following in a DynamoDB-compatible caching service?

Q19. Which of the following activities can be used to copy data from Amazon S3 to Amazon Redshift?

Q20. To which of the following can Kinesis consumers store their results in? Choose 3 answers from the options given below

Q21. Which of the following is used by the AWS Athena service in partitioning data?

Q22. You have just created a Redshift cluster in AWS. You are trying to use SQL Client tools from an EC2 Instance, but you are not able to connect to the Redshift Cluster. What must you do to ensure that you are able to connect to the Redshift Cluster from the EC2 Instance?

Q23. Amazon Athena is known to be highly available and durable. What is the underlying data store for Amazon Athena that makes it so highly available and durable

Q24. You need to use AWS services which would meet the following requirements

Q25. You need to transfer data from an on-premise MySQL database to Amazon Aurora. Which of the following service is the ideal service to fulfil this requirement.

Q26. Which of the following services can be used to automate the movement and transformation of data in AWS?

Q27. Where does the query results from Athena get stored?

Q28. Which of the following operations are available for scaling a Redshift Cluster

Q29. You need real-time reporting on logs that are being generated from your applications. In addition, you need anomaly detection. The processing latency needs to as less as possible. Out of the below options , choose 2 answers that would be able to fulfil this requirement.

Q30. Which of the following is an open source deep learning framework?

Q31. Your application requires long-term storage for backups and other data that you need to keep readily available but with lower cost. Which S3 storage option should you use?

Q33. Which of the following commands can be used to transfer data from DynamoDB to Redshift?

Q34. You currently have data in DynamoDB tables. You have a requirement to perform complex data analysis queries on the data stored in the DynamoDB tables. How can this be achieved?

Q35. Which of the following is a business analytics service provided by AWS?

Q36. Which of the following services can be used as a business analytics service that can be used to build visualizations

Q39. You work for a startup that tracks commercial deliver IoT enabled devices via GPS. You receive coordinates are transmitted from each device once every 6 seconds. You need to process these coordinates in real-time from multiple sources. Which tool should you use to digest the data?

Q40. Which of the below is a fully managed service that can be used to deliver real-time streaming data to S3.

Q41. Which of the following services can AWS Kinesis firehose load streaming data into?

Q42. Which of the following can be used by an organization for archival of data for long periods of time

Q43. You need to store data quickly in a cost-effective manner. At the moment, the amount of data that is going to be processed in the coming months is not known. All that is known as this moment is that there can be burst of processing capabilities required during this time frame.

Q44. When estimating the cost of using EMR, which of the following parameters should you consider. Choose 3 answers from the options given below

Q45. Which of the below services can be used to move large amounts of data into and out if AWS S3.

Q46. There is a requirement to analyze a large set of data updates from Kinesis and DynamoDB. Which of the following tools can be used for this purpose.

Q47. You need to search through the logs stored in the Cloudwatch logs service. Which of the following services can be used for this purpose.

Q48. There is a requirement to analyze a large set of data updates from Kinesis and DynamoDB. Which Big Data tool would be ideal for this scenario?

Q49. You have a set of web servers that deliver their logs to Cloudwatch Logs. There is a requirement to perform a search on Cloudwatch logs for certain types of errors. Which of the below services would be recommended for this requirement

Q51. You are configuring a number of IoT devices with AWS IoT. You are planning on using the current Google credentials already in place for authentication. Which of the following is recommended for this sort of authentication

Q52. Which of the following serverless service can be used to run ad-hoc queries for data in S3

Q53. Which of the following can be used to improve efficiency when using the Kinesis Producer library? Choose 2 answers from the options given below

Q54. What is the term given to a group of data records in a stream in AWS Kinesis

Q55. You currently have web servers that put data from their log files onto Kinesis streams. In this scenario what role are the web servers playing

Q56. You are working with a Kinesis Stream. What is used to group data by shard within a stream?

Q58. When using Autoscaling with EMR, which of the following properties of Autoscaling can ensure that when a scale out activity happens , enough time is given for the entire cluster to stabilize based on the new instance addition

Q59. Which of the following statements are true about secondary indexes in DynamoDB. Choose 2 answers from the options given below

Q60. There is a requirement for EC2 Instances in your private subnet to access DynamoDB tables. How can this be achieved.