AWS Certified Data Analytics Test 7

Welcome to your AWS Certified Data Analytics - Test-7

Name

Phone

Q1. There is a requirement for a vendor to have access to an S3 bucket in your account. The vendor already has an AWS account. How can you provide access to the vendor on this bucket.

Select 1 option(s):

A. Create a new IAM user and grant the relevant access to the vendor on that bucket.

B. Create a new IAM group and grant the relevant access to the vendor on that bucket.

C. Create a cross-account role for the vendor account and grant that role access to the S3 bucket.

D. Create an S3 bucket policy that allows the vendor to read from the bucket from their AWS account.

Q2. Your company currently has an order processing system in AWS. There are EC2 Instances in place to pick up the orders from the application and EC2 Instances in an Autoscaling Group to process the orders. Which of the following additional components can ideally be used to ensure that the EC2 Processing instances are correctly scaled based on demand.

Select 1 option(s):

A. Use Cloudwatch metrics to understand the load capacity on the processing servers and then scale the capacity accordingly.

B. Use SQS queues to decouple the architecture. Scale the processing servers based on the queue length.

C. Use SQS queues to decouple the architecture. Scale the processing servers based on notifications sent from the SQS queues.

D. Use Cloudwatch metrics to understand the load capacity on the processing servers. Ensure SNS is used to scale up the servers based on notifications.

Q3. You host a site in AWS which sells online courses. You are trying to determine which is the best price the courses would be sold for? You want to use the Amazon Machine Learning service for this. Which of the following Learning Models would be beneficial for this.

Select 1 option(s):

A. Binary Classification Model

B. Single Classification Model

C. Multiclass Classification Model

D. Regression Model

Q4. When a database is created in Amazon Aurora what are the 2 types of instances created. Choose 2 answers from the options given below

Select 2 option(s):

A. Primary Instance

B. Backup Instance

C. Initial Instance

D. Aurora Replica

Q5. Your company maintains an ecommerce site in AWS. They want to use AWS Machine learning to see how units of a particular product will sell. Which machine learning model would you use for this purpose

Select 1 option(s):

A. Binary classification

B. Simple classification

C. multiclass classification

D. Regression classification

Q6. You currently have a SQL database defined in the Azure platform. You need to migrate this data to AWS RDS. Which of the below services can be used to fulfil this requirement

Select 1 option(s):

A. AWS DataPipeline

B. AWS Data Migration

C. AWS Kinesis

D. AWS Kinesis Firehose

Q7. An application, basically a mobile application needs access for each user to store data in a DynamoDB table. What is the best method for granting each mobile device that ensures the application has access DynamoDB tables for storage when required? Choose the correct answer from the options below

Select 1 option(s):

A. During the install and game configuration process, have each user create an IAM credential and assign the IAM user to a group with proper permissions to communicate with DynamoDB.

B. Create an IAM group that only gives access to your application and to the DynamoDB tables. Then, when writing to DynamoDB, simply include the unique device ID to associate the data with that specific user.

C. Create an IAM role with the proper permission policy to communicate with the DynamoDB table. Use web identity federation, which assumes the IAM role using AssumeRoleWithWebIdentity, when the user signs in, granting temporary security credentials using STS.

D. Create an Active Directory server and an AD user for each mobile application user. When the user signs in to the AD sign-on, allow the AD server to federate using SAML 2.0 to IAM and assign a role to the AD user which is the assumed with AssumeRoleWithSAML.

Q8. You’ve created a mobile application that serves data stored in an Amazon DynamoDB table. Your primary concern is scalability of the application and being able to handle millions of visitors and data requests. As part of your application, the customer needs access to the data located in the DynamoDB table. Given the application requirements, what would be the best method for designing the application? Choose the correct answer from the options below

Select 1 option(s):

A. Configure an on-premise AD server utilizing SAML 2.0 to manage the application users inside of the on-premise AD server and write code that authenticates against the LD serves. Grant a role assigned to the STS token to allow the end-user to access the required data in the DynamoDB table.

B. Let the users sign into the app using a third party identity provider such as Amazon, Google, or Facebook. Use the AssumeRoleWith API call to assume the role containing the proper permissions to communicate with the DynamoDB table. Write the application in JavaScript and host the JavaScript interface in an S3 bucket.

C. Let the users sign into the app using a third party identity provider such as Amazon, Google, or Facebook. Use the AssumeRoleWithWebIdentity API call to assume the role containing the proper permissions to communicate with the DynamoDB table. Write the application in a server-side language using the AWS SDK and host the application in an S3 bucket for scalability.

D. Let the users sign in to the app using a third party identity provider such as Amazon, Google, or Facebook. Use the AssumeRoleWithWebIdentity API call to assume the role containing the proper permissions to communicate with the DynamoDB table. Write the application in JavaScript and host the JavaScript interface in an S3 bucket.

Q9. You have a requirement to have a data store in AWS. The further following requirements have to be in place for this data store

1) Complex SQL queries and transactions
2) Fixed schema
Which of the following would fulfil this requirement

Select 1 option(s):

A. Amazon S3

B. Amazon Kinesis

C. Amazon DynamoDB

D. Amazon RDS

Q10. What are the 2 types of nodes in a Redshift Cluster? Choose 2 answers from the options given below

Select 2 option(s):

A. Primary Node

B. Leader Node

C. Compute Node

D. Secondary Node

Q11. You are currently designing a Redshift table in AWS. You are responsible for ensuring maximum efficiency when queries are run against the tables in Redshift. The tables will be performing multiple joins based on Customer ID. Also each table would be storing around a million rows. Which of the following distribution styles should be used when designing the table.

Select 1 option(s):

A. Even

B. Key

C. None

D. All

Q12. You are currently designing a Redshift table in AWS. The data in this table will not be changed frequently. Also this table will not participate in any joins. Which of the following distribution style should be preferable for this table

Select 1 option(s):

A. Even

B. Key

C. None

D. All

Q13. Which of the following can be used to enable developers to quickly get started with deep learning in the cloud

Select 1 option(s):

A. Amazon EMR

B. TensorFlow

C. Amazon Redshift

D. Amazon DynamoDB

Q14. Your EMR cluster uses twelve m4.large instances and runs 24 hours per day, but it is only used for processing and reporting during business hours. Which options can you use reduce the costs? Choose 2 answers from the options given below

Select 2 option(s):

A. Use Autoscaling to scale in and scale out the cluster whenever required.

B. Use Reserved Instances for the task nodes

C. Migrate the data from HDFS to S3 using S3DispCp and turn off the cluster when not in use

D. Use Spot instances for tasks nodes when needed

Q15. A company has a Redshift cluster for petabyte-scale data warehousing. The data within the cluster is easily reproducible from additional data stored on Amazon S3. The company wants to reduce the overall total cost of running this Redshift cluster. Which scenario would best meet the needs of the running cluster, while still reducing total overall ownership of the cluster? Choose the correct answer from the options below

Select 1 option(s):

A. Instead of implementing automatic daily backups, write a CLI script that creates manual snapshots every few days. Copy the manual snapshot to a secondary AWS region for disaster recovery situations.

B. Enable automated snapshots but set the retention period to a lower number to reduce storage costs

C. Implement daily backups, but do not enable multi-region copy to save data transfer costs.

D. Disable automated and manual snapshots on the cluster

Q16. An application is currently using the Elastic Search service in AWS. Which of the following features of the Elastic Search service allows for backups of a cluster’s data and state

Select 1 option(s):

A. Indexing

B. Automated snapshots

C. Elastic Search Copy

D. Elastic Search Migrate

Q17. You have a collection of sensors that write data to a Kinesis stream. The default stream settings are used for the kinesis stream. Every third day you have decided to send the data to S3 from the stream. When you analyze the data in S3 , you can see that only the 3rd day’s data is present in the stream. What is the underlying cause for this?

Select 1 option(s):

A. The sensors are probably failing to send the data on time.

B. The versioning enabled on the buckets is causing only the newest version to be available

C. Data records are only accessible for a default of 24 hours from the time they are added to a stream.

D. The right access permissions are not present in the Kinesis streams

Q18. Which of the following can be used to obtain higher-quality models using Amazon Machine Learning?

Select 2 option(s):

A. Using Regularization

B. Conducting Evaluations

C. Using constant data sources

D. Tagging data models

Q19. You are managing the development of an application that uses DynamoDB to store JSON data. You have already set the Read and Write capacity of the DynamoDB table. You are unsure of the amount of the traffic that will be received by the application during the deployment time. How can you ensure that the DynamoDB is not highly throttled and does not become a bottleneck for the application? Choose 2 answers from the options below.

Select 2 option(s):

A. Monitor the ConsumedReadCapacityUnits and ConsumedWriteCapacityUnits metric using Cloudwatch.

B. Monitor the SystemErrors metric using Cloudwatch

C. Create a Cloudwatch alarm which would then send a trigger to AWS Lambda to increase the Read and Write capacity of the DynamoDB table.

D. Create a Cloudwatch alarm which would then send a trigger to AWS Lambda to create a new DynamoDB table.

Q20. You are designing an application which is going to be using DynamoDB for data storage. The application is going to be processing a high number of read operations.

Which of the following design aspects can actually help minimize the impact of the read operations on the DynamoDB target table?

Select 1 option(s):

A. Deploy a secondary DynamoDB target table to absorb the read operation

B. Deploy a secondary RDS database to absorb the read operation

C. Deploy an Elastic Cache Solution

D. Deploy a read replica of the DynamoDB table

Q21. If there is a need to run 2 types of queries using Redshift , how could that be achieved. Let’s say that you have long running and short running queries. How can you ensure that the short running queries also get a chance to run in Redshift?

Select 1 option(s):

A. Tag the queries and assign them to the Redshift node.

B. Create Users Groups and assign the queries to the User Groups accordingly

C. Create a data distribution style for the queries

D. Choose the appropriate sort keys when designing the queries

Q22. Which of the following use the bulk API to upload data into your Amazon Elastic Search domain?

Select 1 option(s):

A. Amazon EMR

B. Logstash

C. Kibana

D. Node.js

Q23. There is a requirement to perform ad-hoc SQL queries on structured data. The data itself comes in constantly at a high velocity. What services should you use? Choose 2 answers from the options given below

Select 2 option(s):

A. AWS Kinesis Firehose

B. AWS Redshift

C. AWS Kinesis Streams

D. AWS DynamoDB

Q24. You need to perform ad-hoc SQL queries on structured data. Data comes in constantly at a high velocity. What services should you use?

Select 1 option(s):

A. EMR + Redshift

B. Kinesis Streams and RDS

C. Kinesis Firehose and Redshift

D. EMR using Hive

Q25. You are building a game high score table in DynamoDB. You will store each user’s highest score for each game, with many games, all of which have relatively similar usage levels and numbers of players. You need to be able to look up the highest score for any game. What’s the best DynamoDB key structure?

Select 1 option(s):

A. HighestScore as the hash / only key.

B. GameID as the hash key, HighestScore as the range key.

C. GameID as the hash / only key.

D. GameID as the range / only key.

Q26. Which of the following statements about Redshift database encryption is false.

Select 1 option(s):

A. In Amazon Redshift, you can enable database encryption for your clusters to help protect data at rest

B. When encryption is enabled , it is also enabled for the snapshots created

C. When encryption is enabled , the system metadata is also encrypted

D. Encryption is enable by default for a cluster

Q27. Which of the following are open source tools which can be used on top of Hadoop for SQL like queries. Choose 2 answers from the options given below

Select 2 option(s):

A. Impala

B. HBase

C. Ganglia

D. Hive

Q28. You are designing a Redshift table which will be used to store data from multiple IoT enabled camera’s. The data which will be stored is the CameraID , the timestamp and the picture taken by the camera. Which of the following attributes would be preferable to store as the sort key for the Redshift table

Select 1 option(s):

A. CameraID

B. The timestamp

C. The image

D. Combination of CameraID and timestamp

Q29. Which open-source Web interface provides you with a easy way to run scripts, manage the Hive metastore, and view HDFS

Select 1 option(s):

A. Ganglia

B. Zeppelin

C. HUE

D. Quicksight

Q30. Which of the following can be used to analyze storage access patterns in your buckets stored in S3. Choose 2 answers from the options given below

Select 2 option(s):

A. Use the S3 analytics feature

B. Use Cloudwatch logs

C. Use AWS Config

D. Use Amazon QuickSight

Q31. What is the purpose of the Hadoop Encrypted Shuffle feature?

Select 1 option(s):

A. The data in transit between the nodes in a cluster is encrypted

B. The encryption keys used in a cluster are shuffled at regular intervals

C. The files are shuffled across nodes in a cluster

D. The EC2 Instances are shuffled across the cluster for better performance

Q32. An EMR cluster is running in AWS that uses EMRFS on S3 for the data. The data in S3 is constantly changing and you need to ensure the updated data is reflected in EMRFS? How can this be achieved.

Select 1 option(s):

A. Consider using EBS Volumes to store the data instead.

B. Enable versioning on the S3 bucket.

C. Enable Consistent Views

D. Enable recycling on the EMR cluster

Q33. You have just developed a new mobile application that handles analytics workloads on large scale datasets that are stored on Amazon Redshift. Consequently, the application needs to access Amazon Redshift tables. Which of the below methods would be the best, both practically and security-wise, to access the tables? Choose the correct answer from the options below

Select 1 option(s):

A. Create an IAM user and generate encryption keys for that user. Create a policy for RedShift read-only access. Embed the keys in the application.

B. Create a HSM client certificate in Redshift and authenticate using this certificate.

C. Create a RedShift read-only access policy in IAM and embed those credentials in the application.

D. Use roles that allow a web identity federated user to assume a role that allows access to the RedShift table by providing temporary credentials.

Q34. You have a requirement for creating a visualization application that would be based on sales of products from your company from various regions. Which of the following can be used to create a fully serverless application model. Choose 3 answers from the options given below

Select 3 option(s):

A. AWS DynamoDB

B. Java

C. D3.js

D. AWS S3

Q35. A company is currently managing their data workload in Amazon Aurora. They are looking at encrypting the data at rest. Which of the following can be used for managing the encryptions keys. Choose 2 answers from the options given below

Select 2 option(s):

A. S3-SSE

B. Client side encryption

C. AWS KMS

D. AWS CloudHSM

Q36. Which of the following services are not supported when creating AWS IoT Rule actions? Choose 2 answers from the options given below

Select 2 option(s):

A. AWS Aurora

B. AWS DynamoDB

C. AWS Redshift

D. AWS Cloudwatch

Q37. You are developing an application that makes use of the KCL library. Which of the following can be used to reduce the kinesis related costs for your application. Choose 3 answers from the options given below

Select 3 option(s):

A. Batching

B. Collection

C. Compression

D. Aggregation

Q38. What is the concurrency level of the number of queries that can run per queue in Redshift

Select 1 option(s):

A. 2

B. 5

C. 10

D. 20

Q39. Which of the following component for the AWS Machine learning service is used to generate predictions using the patterns extracted from the input data

Select 1 option(s):

A. Data Sources

B. Models

C. Evaluations

D. Patterns

Q40. Which of the following is not a best practise when it comes to designing queries in Redshift

Select 1 option(s):

A. Avoid using select *, because this can slow down queries

B. Use cross-joins wherever possible , because this can speed up queries.

C. Use a CASE Expression to perform complex aggregations

D. Use subqueries in cases where one table in the query is used only for predicate conditions

Q41. Which of the following refers to a single action on multiple items in a Kinesis stream

Select 1 option(s):

A. Batching

B. Collection

C. Compression

D. Aggregation

Q42. You need a cost effective solution to store a large collection of video files and have a data warehouse that can keep a track of the data. Which of the following would form the solution required to fulfil the requirements. Choose 2 answers from the options given below. Each answer forms part of the solution

Select 2 option(s):

A. Store the collection of video files in AWS Redshift

B. Store the reference location for the video files in AWS Redshift

C. Store the collection of video files in S3

D. Store the reference location for the video files in AWS Kinesis

Q43. You have an application defined in AWS that makes use of Kinesis streams. Some of the data from the streams then need to be archived and some of them need to be put in a data store that is easily searchable. Which 2 services can be used to fulfil this requirement? Choose 2 answers from the options given below

Select 2 option(s):

A. Use AWS S3 for archiving the data from the streams.

B. Use AWS Kinesis Firehose for archiving the data from the streams.

C. Use Elastic Search for storing the data which needs to be easily searchable.

D. Use DynamoDB for storing the data which needs to be easily searchable.

Q44. Which of the below components of a Redshift cluster, if down, can render the Redshift cluster as unavailable?

Select 1 option(s):

A. Shards

B. Data Node

C. Leader Node

D. Task Nodes

Q45. Your company stores very sensitive data on Redshift, which needs to be encrypted with keys that are fully controlled by your company. Which of the following services should you use to fulfil this requirement?

Select 1 option(s):

A. S3-KMS

B. AWS CloudHSM

C. AWS KMS

D. On-premise HSM

Q46. A company has many employees who need to run internal applications that access the company’s AWS resources. These employees already have user credentials in the company’s current identity authentication system, which does not support SAML 2.0. The company does not want to create a separate IAM user for each company employee.

How should the SSO setup be designed? Choose the 2 correct answers from the options below

Select 2 option(s):

A. Create an IAM user to share based off of employee roles in the company.

B. Create a custom identity broker application which authenticates the employees using the existing system, uses the GetFederationToken API call and passes a permission policy to gain temporary access credentials from STS.

C. Create a custom identity broker application which authenticates employees using the existing system and uses the AssumeRole API call to gain temporary, role-based access to AWS.

D. Configure an AD server which synchronizes from the company's current Identity Provide and configures SAML-based single sign-on which will then use the AssumeRoleWithSAML API calls to generate credentials for the employees.

Q47. Which of the following is a tool which can be used for transferring data between Amazon S3, Hadoop, HDFS, and RDBMS databases

Select 1 option(s):

A. Sqoop

B. Hive

C. HUE

D. Ganglia

Q48. Which of the following is a self-serviced tool which can be used to build real-time applications using streaming data

Select 1 option(s):

A. Kinesis

B. Kinesis Firehose

C. SQS

D. Kafka

Q49. You have two teams using Redshift to analyze data of a massive application, each query issued by the first team takes approximately 1-2 hours to analyze the data while other team takes very short time to analyze the data. You don’t want the second team’s queries to wait until the already running long queries are completed. How will you solve the problem in most economical way? Choose an answer from the options below.

Select 1 option(s):

A. Create a read replica of the Red shift instance and run second team’s queries on read replica

B. Start another Redshift cluster from snapshot for the second team if current Redshift cluster is busy processing long queries

C. Pause long queries and resume the queries afterwards

D. Create two separate workload management groups and assign them to respective teams

Q50. Which of the following can be used for encryption of databases in AWS Redshift. Choose 2 answers from the options given below

Select 2 option(s):

A. AWS KMS

B. LUKS

C. S3-SSE

D. AWS Cloud HSM

Q51. Which of the following are examples of Columnar databases?

Select 2 option(s):

A. Amazon DynamoDB

B. Amazon Redshift

C. Apache HBase

D. Amazon EMR

Q52. You are doing a load testing exercise on your application hosted on AWS. While testing your Amazon RDS MySQL DB instance, you notice that when you hit 100% CPU utilization on it, your application becomes non- responsive. Your application is read-heavy. What are methods to scale your data tier to meet the application’s needs? Choose three answers from the options given below

Select 3 option(s):

A. Add Amazon RDS DB read replicas, and have your application direct read queries to them.

B. Add your Amazon RDS DB instance to an Auto Scaling group and configure your CloudWatch metric based on CPU utilization.

C. Use an Amazon SQS queue to throttle data going to the Amazon RDS DB instance.

D. Use ElastiCache in front of your Amazon RDS DB to cache common queries.

E. Shard your data set among multiple Amazon RDS DB instances.

F. Enable Multi-AZ for your Amazon RDS DB instance.

Q53. Which of the following is used by the Spark Streaming tool to consume data from Amazon Kinesis

Select 1 option(s):

A. Amazon Firehose

B. Amazon Kinesis Producer Library

C. Amazon Kinesis Consumer Library

D. Amazon Kinesis Client Library

Q54. Your application generates a 1 KB JSON payload that needs to be queued and delivered to EC2 instances for applications. At the end of the day, the application needs to replay the data for the past 24 hours. Which of the following services would you use for this requirement?

Select 1 option(s):

A. SQS

B. Kinesis

C. Kinesis Firehose

D. SNS

Q55. Which of the following full managed service can be used to deliver real-time streaming data to S3.

Select 1 option(s):

A. EMR

B. Amazon Kinesis

C. Amazon Kinesis Firehose

D. Redshift

Q56. You need to store a large volume of data. The data needs to be readily accessible for a short period, but then needs to be archived indefinitely after that. What is a cost-effective solution that an help fulfil this requirement.

Select 1 option(s):

A. Keep all your data in S3 since this is a durable storage.

B. Store your data in Amazon S3, and use lifecycle policies to archive to Amazon Glacier

C. Store your data in an EBS volume, and use lifecycle policies to archive to Amazon Glacier.

D. Store your data in Amazon S3, and use lifecycle policies to archive to S3-Infrequently Access

Q57. You need to perform ad-hoc analysis on log data, including searching quickly for specific error codes and reference numbers. Which should you evaluate first?

Select 1 option(s):

A. AWS Elasticsearch Service

B. AWS RedShift

C. AWS EMR

D. AWS DynamoDB

Q58. Which of the following file formats are supported in Athena by default?

Select 3 option(s):

A. CSV

B. JSON

C. Adobe Acrobat

D. Apache Parquet

Q59. What is the default retention period for a Kinesis stream?

Select 1 option(s):

A. 1 day

B. 3 days

C. 5 days

D. 7 days

Q60. Which of the following interfaces of the Kinesis connector library is used to persists records in the stream to other AWS services

Select 1 option(s):

A. ITransformer

B. IFilter

C. IBuffer

D. IEmitter