AWS Certified Data Analytics Test 4

Welcome to your AWS Certified Data Analytics - Test-4

Name

Phone

Q1. You currently have an EC2 instance with EBS volumes that stores a large amount of files. It takes a long time for an application to process the files. Which of the following options can be used to ensure the right storage option is used and to also ensure high availability of the application.

Select 1 option(s):

A. S3 to store I/O files. SQS to distribute elaboration commands to a group of hosts working in parallel. Auto scaling to dynamically size the group of hosts depending on the length of the SQS queue

B. EBS with Provisioned IOPS (PIOPS) to store I/O files. SNS to distribute elaboration commands to a group of hosts working in parallel Auto Scaling to dynamically size the group of hosts depending on the number of SNS notifications

C. S3 to store I/O files, SNS to distribute evaporation commands to a group of hosts working in parallel. Auto scaling to dynamically size the group of hosts depending on the number of SNS notifications

D. EBS with Provisioned IOPS (PIOPS) to store I/O files SQS to distribute elaboration commands to a group of hosts working in parallel. Use Auto Scaling to dynamically size the group of hosts depending on the length of the SQS queue.

Q2. Which of the following can be used for storing log files generated from an EMR cluster?

Select 1 option(s):

A. Amazon S3

B. Amazon Glacier

C. Amazon DynamoDB

D. Amazon Cloudtrail

Q3. There is a fleet of EC2 Instances hosted in AWS. The logs from the EC2 Instances need to be published. These logs then need to be scanned on a regular basis for any errors so that if any errors do persist , a relevant application patch can be deployed on these EC2 Instances. Which of the below would you implement to fulfil this requirement. Choose 2 answers from the options below. Each answer forms part of the solution.

Select 2 option(s):

A. Send the logs from the EC2 Instances to AWS Kinesis

B. Send the logs from the EC2 Instances to AWS Cloudwatch Logs

C. Use AWS EMR to analyze the logs

D. Use consumers to analyze the logs

Q4. Which of the following is not a supported data sources for Amazon QuickSight

Select 1 option(s):

A. Amazon DynamoDB

B. Amazon Athena

C. Amazon Redshift

D. Amazon S3

Q5. Which of the below 3 things can you achieve with the Cloudwatch logs service

Select 3 option(s):

A. Record API calls for your AWS account and delivers log files containing API calls to your Amazon S3 bucket

B. Send the log data to AWS Lambda for custom processing or to load into other systems

C. St D. Stream the log data into Amazon Elasticsearch in near real-time with CloudWatch Logs subscriptions.ream the log data to Amazon Kinesis

D. Stream the log data into Amazon Elasticsearch in near real-time with CloudWatch Logs subscriptions.

Q6. Your company is currently running an EMR cluster which is used to perform a processing task every day from 6pm to 11pm. But the senior management has noticed that the cluster is being billed for the entire day. Which of the following configurations for the cluster can help reduce the costs for the cluster.

Select 1 option(s):

A. Use the Autoscaling service to scale up and scale down nodes based on demand.

B. Use transient clusters in EMR

C. Use Reserved instances in the EMR cluster to save on costs

D. Use Spot instances in the EMR cluster to save on costs

Q7. There is a requirement to migrate 3TB of data to AWS. There is a restriction of the time to migrate the data and there is a limitation of only a 100MBit line to the AWS Cloud. What is the best solution to use to migrate the data to the cloud?

Select 1 option(s):

A. Amazon Import/Export

B. Amazon S3

C. Amazon Storage Gateway

D. Amazon Direct Connect

Q8. You are in the process of designing a system which is going to make use of the EMR service. The EMR system will be used to process highly confidential data. Which of the following options can be used to encrypt data at rest. Choose 2 answers from the options given below.

Select 2 option(s):

A. LUKS

B. TLS

C. SSL

D. SS3-KMS

Q9. A Company has created an e-commerce site using DynamoDB and is designing a products table that includes items purchased and the users who purchased the item. When creating a primary key on a table which of the following would be the best attribute for the primary key? Select the BEST possible answer.

Select 1 option(s):

A. user_id where there are many users to few products

B. product_id where there are few products to many users

C. category_id where there are few categories to many products

D. None of the above

Q10. You need to visualize data from Spark and Hive running on an EMR cluster. Which of the options is best for an interactive and collaborative notebook for data exploration?

Select 1 option(s):

A. Kinesis Analytics

B. Hive

C. Zeppelin

D. D3.js

Q11. You are trying to use Amazon Quicksight along with data stored in S3. You are not able to configure S3 as the data source. Which of the below are possible causes for the underlying issue? Choose 2 correct answers.

Select 2 option(s):

A. The relevant S3 bucket does not have a valid manifest file

B. Amazon Quicksight is not authorized to access the S3 bucket

C. Versioning is not enabled for the bucket

D. MFA is not enabled for the bucket

Q12. You have an S3 bucket defined in AWS. You expect a large number of GET and PUT requests on this bucket. You could expect around 200 PUT and 400 GET requests per second on the S3 bucket during a promotion period for your web site. In such a case , what could be a good design consideration to ensure optimal performance when accessing the objects in the bucket

Select 1 option(s):

A. Use different S3 bucket names

B. Define the buckets in different availability zones

C. Ensure the object names have appropriate key names

D. Ensure the buckets have appropriate names

Q13. When defining a DynamoDB table which of the following are important factors to define during the design stage to ensure that the table performs efficiently. Choose 2 answers from the options given below

Select 2 option(s):

A. The table storage

B. The table read capacity

C. The table write capacity

D. The table triggers

Q14. You have an ecommerce application hosted in AWS. This application sells items online to customers. You want to use the Amazon Machine Learning Model to see the probability of a person buying a particular product. Which of the following models can be used for this purpose.

Select 1 option(s):

A. Binary

B. Regression

C. Categorical

D. Simple

Q15. When troubleshooting slowness on an EMR cluster , which of the following node types does not need to be investigated for issues.

Select 1 option(s):

A. Master Node

B. Leader Node

C. Core Nodes

D. Task Nodes

Q16. Which of the following can be used for query optimization after data has been ingested into a Redshift Table

Select 1 option(s):

A. Run a query with sample data so that the optimizer can generate up-to-date data statistics

B. Run the ANALYZE command so that the optimizer can generate up-to-date data statistics

C. Run the EXPLAIN command so that the optimizer can generate up-to-date data statistics

D. You don’t need to run anything since all queries are already built for optimization by AWS.

Q17. You are planning on using the AWS IoT Rules service to allow IoT enabled devices to write information to AWS DynamoDB. Which of the following actions must be done to ensure that the rules will work as intended.

Select 1 option(s):

A. Ensure that the devices are recorded as users in IAM

B. Ensure that the IoT devices are defined in the Amazon VPC.

C. Ensure that the IoT devices are defined in the AWS Config

D. Ensure that the right IAM permissions to AWS DynamoDB is given

Q18. Which of the following AWS services cannot be connected with the Amazon Kinesis Connector Library?

Select 1 option(s):

A. AWS Elasticsearch

B. Amazon Redshift

C. Amazon DynamoDB

D. Amazon EMR

Q19. Your company has decided to use AWS quicksight for visualization. The CEO wants to see the target goals for each department of the company. During the design phase it has been decided that the UI would have each department represented via a rectangle with the height of the rectangle defining the goal. In such a case which of the following in Quicksight would help build this visualization properly

Select 1 option(s):

A. Heat Maps

B. Scatter Plots

C. Tree Map

D. KPI's

Q20. You need to store large digital video files and need a fast, fully-managed, data warehouse service that is simple and cost-effective to analyze all your data efficiently using your existing business intelligence tools. Which of the following can be used for this. Choose 2 answers from the options given below

Select 2 option(s):

A. Store the digital video files in Redshift

B. Store the digital video files in S3

C. Keep the reference location of the video file in Redshift

D. Keep the reference location of the video file in S3

Q21. Which of the following is not a scalar type for data types in DynamoDB?

Select 1 option(s):

A. Number

B. Map

C. String

D. Binary

Q22. You to create an Amazon Machine Learning model to predict how many inches of snow will fall in an area based on the historical snowfall data. What type of modeling will you use?

Select 1 option(s):

A. Simple

B. Binary

C. Categorical

D. Regression

Q23. Your redshift cluster has 2 ds1.XL nodes. How many files would you normally split your data into for loading into the Redshift cluster

Select 1 option(s):

A. 2

B. 4

C. 8

D. 12

Q24. You are currently managing an application that use the KCL library to read a Kinesis stream. You have noticed that you are getting a ProvisionedThroughputExceededException in Cloudwatch from the stream. What must you do to rectify this error?

Select 1 option(s):

A. Use more Kinesis streams

B. Add more shards to your Kinesis Stream

C. Use Kinesis Firehouse to the application

D. Add more applications that use the KCL library

Q25. When a new DynamoDB table is created with 6000 Read capacity units and 2000 write capacity units, how many partitions will be initially created?

Select 1 option(s):

A. 2

B. 4

C. 8

D. 10

Q26. Which one of the following statements are false when it comes to using EBS volumes with an EMR Cluster

Select 1 option(s):

A. Amazon EBS Volumes attached to an EMR Cluster can persist even after the cluster has been terminated.

B. You can't snapshot an EBS volume and then restore it within Amazon EMR

C. An encrypted EBS root storage volume is supported only when using a custom AMI

D. A 10 GB EBS root volume is already attached to an EC2 Instance which is part of the EMR cluster.

Q27. Which of the following storage types can be used with Amazon EMR. Choose 3 answers from the options given below

Select 3 option(s):

A. Amazon Glacier

B. Local file system

C. HDFS

D. EMRFS

Q28. Which of the following node types are recommended when launching Redshift clusters.

Select 1 option(s):

A. Accelerated Computing

B. Dense Storage

C. Memory Optimized

D. General Purpose

Q29. Which of the following should not be used when you need a persistent storage option in AWS

Select 1 option(s):

A. AWS DynamoDB

B. AWS Kinesis

C. AWS RDS

D. AWS Aurora

Q30. You have a requirement to provision 3000 Read Capacity Units and 1000 Write capacity units for a DynamoDB s. How many partitions do you need initially?

Select 1 option(s):

A. 8

B. 4

C. 2

D. 1

Q31. Which of the below components is used to pump data into a Kinesis Stream.

Select 1 option(s):

A. Producers

B. Consumers

C. Kinesis Firehose

D. Shards

Q32. You have a requirement to send records from multiple logs stored on multiple application servers hosted on Linux EC2 Instances. There is a requirement to also transform the records and store them on S3 , but also ensure that the original records are maintained. Which of the following can be steps for the implementation process which can satisfy these requirements

Select 2 option(s):

A. Configure AWS Cloudwatch agents to copy transformed data on S3

B. Use Kinesis Firehose to stream transformed data on S3

C. Use Kinesis Firehose to stream original data to a backup S3

D. Configure AWS Cloudwatch agents to copy the original data onto a backup S3

Q33. An application stores its data as different buckets in S3. The access to these buckets need to be based on single-sign on which used Microsoft Active Directory. Which of the following implementation techniques can be used?

Select 1 option(s):

A. Create bucket policies based on the groups defined in Microsoft AD

B. Use IAM federation and ensure the access is given based on the user’s group defined in AD

C. Use Impersonation to ensure the user can access the required bucket.

D. Use Active Directory connector to ensure the access can be provided based on the user’s permission defined in Microsoft AD

Q34. Which of the following statements on AWS Snowball is incorrect?

Select 1 option(s):

A. You can import data between your on-premises data storage locations and Amazon S3.

B. You can export data between your on-premises data storage locations and Amazon S3.

C. You need to explicitly consider encryption since this does not come out of the box

D. You can perform local data transfers between your on-premises data center and a Snowball device.

Q35. In AWS Datapipeline , what are the 2 types of computational resource supported.

Select 2 option(s):

A. EC2 Resources

B. Redshift Resources

C. S3 Resources

D. EMR Cluster Resources

Q36. Which of the following is not a supported database for the AWS Data Pipeline service

Select 1 option(s):

A. A JDBC database

B. AWS DynamoDB

C. AWS RDS

D. AWS Redshift

Q37. Which of the following is not a lambda blueprint which is available when it comes to transformation using Kinesis data firehose.

Select 1 option(s):

A. Apache Log to JSON

B. Syslog Log to JSON

C. Processing Cloudwatch Logs

D. Processing Cloudtrail logs

Q38. From which of the below data sources can input data be present when it needs to read by the AWS Machine Learning service. Choose 3 answers from the options given below

Select 3 option(s):

A. Amazon Redshift

B. Amazon RDS

C. Amazon S3

D. Amazon DynamoDB

Q39. You are designing an application which will consist of web servers hosted in EC2 and data stored in DynamoDB. The data stored for the week will be accessed frequently. After a week the data will be accessed less frequently. What would be the ideal way to design the DynamoDB tables? Choose 2 answers from the options given below

Select 2 option(s):

A. After a week, choose to store the week’s data from DynamoDB to S3.

B. Delete the table on a week by week basis and create a new one for the new week.

C. Ensure that an attribute is specified in the table to specify the week where the data is stored.

D. Increase the Read and write capacity for the table on a week by week basis as the items increase on a weekly basis

Q40. Which of the following Machine Learning models is used to predict values that can only have one of two states, such as true or false

Select 1 option(s):

A. Simple

B. Regression

C. MultiClass

D. Binary

Q41. Where does AWS Redshift store the snapshots created?

Select 1 option(s):

A. On EBS volumes stored on the Redshift nodes

B. In AWS S3

C. In a separate Redshift cluster

D. In AWS Glacier for lower cost.

Q42. When the PutRecord API call is made to put a record in the Kinesis stream , what is returned from the API call. Choose 2 answers from the options below

Select 2 option(s):

A. Shard ID

B. Stream ID

C. Sequence number

D. Stream number

Q43. Which of the following features of EMR allow for EMR Clusters to ensure that the read-after-write consistency is checked for objects stored in S3.

Select 1 option(s):

A. S3 View

B. Consistent View

C. Read-after-write View

D. Check View

Q44. Which of the following software is used by Amazon Athena for partitioning data?

Select 1 option(s):

A. Apache Hive

B. Presto

C. Gangalia

D. Quicksight

Q45. To which of the nodes in an EMR Cluster do log files pertinent to the cluster get written to?

Select 1 option(s):

A. Master Node

B. Task Nodes

C. Primary Nodes

D. Core Nodes

Q46. Which of the following services is a fully-managed service that can be used to build machine learning models at any scale

Select 1 option(s):

A. AWS Fargate

B. AWS SageMaker

C. AWS Polly

D. AWS Greengrass

Q47. You currently have a set of Redshift clusters running workloads in AWS. You need to know the connections which are being established to the Redshift clusters. How can you get this information?

Select 1 option(s):

A. This is not available out of the box. You need to create another Redshift cluster to store the logs and then ensure the log configuration variable of the source cluster points to the new cluster.

B. Enable cloudwatch logs to get the required connection information

C. Check the Amazon S3 location , because Redshift logs get stored there.

D. Check the Amazon Glacier location , because Redshift logs get stored there.

Q48. There is a requirement to use Machine learning tools on top of the Amazon EMR Clusters. Which of the following software’s can meet this requirement

Select 1 option(s):

A. Apache Hive

B. Apache Mahout

C. Apache Presto

D. Apache Hue

Q49. You are planning on loading a 500 GB file into a Redshift cluster which has 10 nodes. Which of the following is a preferable method to load the data.

Select 1 option(s):

A. Compress the file using gz compression.

B. Split the file into 500 smaller files.

C. Split the file into 50 files of equal size

D. Split the file into 10 files of equal size

Q50. Your application is using the KCL library on EC2 Instances to work with Kinesis shards. Which of the following can be used to scale up processing in your application. Choose 3 answers from the options given below

Select 3 option(s):

A. Increasing the instance size of the underlying EC2 Instances.

B. Increasing the number of instances up to the maximum number of open shards

C. Adding an ELB in front of the EC2 Instances

D. Increasing the number of shards

Q51. When loading encrypted files from Amazon S3 into Redshift , which of the following is not a supported types of Amazon S3 encryption for the COPY command

Select 1 option(s):

A. Server-side encryption with customer-provided keys

B. Server-side encryption with Amazon S3-managed keys

C. Server-side encryption with AWS KMS-managed keys

D. Client-side encryption using a client-side symmetric master key

Q52. Which of the following is not a data type node available for transfer of data using the AWS Data Pipeline

Select 1 option(s):

A. DynamoDBDataNode

B. RedshiftDataNode

C. S3DataNode

D. GlacierDataNode

Q53. Which of the following is not a condition that needs to be met by the local secondary index for a DynamoDB table

Select 1 option(s):

A. The partition key is the same as that of its base table

B. The partition key is different from that of the base table

C. The sort key consists of exactly one scalar attribute.

D. The sort key of the base table is projected into the index, where it acts as a non-key attribute.

Q54. You are working with DynamoDB streams. You need to ensure that the streams put the entire item in the DynamoDB table as it appears before it was modified. Which of the following stream record views would you choose

Select 1 option(s):

A. KEYS_ONLY

B. NEW_IMAGE

C. OLD_IMAGE

D. NEW_AND_OLD_IMAGES

Q55. There is a requirement to collect, process, and analyze video streams in real time. Which of the below services can be used for this requirement

Select 1 option(s):

A. Amazon EMR

B. Amazon Redshift

C. Amazon DynamoDB

D. Amazon Kinesis

Q56. Which of the following is incorrect when it comes to pull and push based approach for data ingestion.

Select 1 option(s):

A. The pull based approach can be made using dedicated pollers running the popular Splunk Add-on for AWS to pull data from various AWS services such as Amazon CloudWatch or Amazon S3

B. The push based approach can be done by streaming directly from AWS.

C. The pull-based approach offers data delivery guarantees such as retries and checkpointing out of the box

D. The pull based approach is less of a maintenance overhead when compared to the push based approach.

Q57. A web application emits multiple types of events to Amazon Kinesis Streams for operational reporting. Critical events must be captured immediately before processing can continue, but informational events do not need to delay processing. What is the most appropriate solution to record these different types of events

Select 1 option(s):

A. Log all events using the Kinesis Producer Library.

B. Log critical events using the Kinesis Producer Library, and log informational events using the PutRecords API method.

C. Log critical events using the PutRecords API method, and log informational events using the Kinesis Producer Library.

D. Log all events using the PutRecords API method.

Q58. Which of the following is false when it comes to the definition of the Global and Local secondary index for DynamoDB tables?

Select 1 option(s):

A. The primary key of a global secondary index can consist of just the partition key

B. The primary key of a local secondary index must consist of both the partition key and sort key

C. Queries on global secondary indexes support eventual consistency and strong consistency.

D. Queries on local secondary indexes support eventual consistency and strong consistency.

Q50. You currently have an application that is making use of Kinesis Data streams. You have noticed that there are lot of provisioned throughput errors coming from DynamoDB. Which of the following can be a cause of this. Choose 2 answers from the options given below

Select 2 option(s):

A. The Kinesis stream consists of a few shards , hence the data is not being provisioned properly

B. The Kinesis stream consists of too many shards

C. The application is carrying out frequent checkpointing

D. The application is not carrying out frequent checkpointing

Q60. There is a requirement to convert an on-premise Oracle database to AWS Aurora. Which of the following make up the steps that are involved in the conversion?

Choose 3 answers from the options given below.

Select 3 option(s):

A. Convert database schema and code using AWS Schema Conversion Tool

B. Use AWS DataPipeline to transfer the data from Oracle to AWS Aurora

C. Migrate data from the source database to the target database using AWS Database Migration Service

D. Perform post-migration activities