AWS Certified Data Analytics Test 5

Welcome to your AWS Certified Data Analytics - Test-5

Name

Phone

Q1. You need to move a Redshift cluster from one AWS account to another? Which of the below is the first step you would carry out in the entire process.

Select 1 option(s):

A. Create a manual snapshot of the Redshift cluster

B. Enable cross-region snapshot copy

C. Create a new Redshift cluster in the target region

D. Configure an IAM roles for the transfer

Q2. Which of the following API commands can be used to data into a Kinesis stream for Synchronous processing.

Select 1 option(s):

A. SendRecord

B. PutRecord

C. WriteRecord

D. SetRecord

Q3. Your company has a web site hosted in AWS. There is a requirement to analyze the clickstream data for the web site and this needs to be done in real time. Which of the below can be used to fulfil this requirement.

Select 1 option(s):

A. Publish the web clicks to Amazon SQS

B. Use the EMR service to ingest the data so that it can be analyzed at a later point in time.

C. Use the Amazon Kinesis service to process the data from a Kinesis stream

D. Use the Redshift service to ingest the data so that it can be analyzed at a later point in time.

Q4. Your company has a web site hosted in AWS. There is a requirement to analyze the clickstream data for the web site and this needs to be done in real time. Which of the below can be used to fulfil this requirement.

Select 1 option(s):

A. Publish the web clicks to Amazon SQS

B. Use the EMR service to ingest the data so that it can be analyzed at a later point in time.

C. Use the Amazon Kinesis service to process the data from a Kinesis agent

D. Use the Redshift service to ingest the data so that it can be analyzed at a later point in time.

Q5. There is a requirement to perform SQL querying along with complex queries on HDFS and S3 file systems. Which of the below tools can fulfil this requirement?

Select 1 option(s):

A. YARN

B. Presto

C. QuickSight

D. Kinesis

Q6. There is a requirement to perform SQL querying along with complex queries on HDFS and S3 file systems. Which of the below tools can fulfil this requirement?

Select 1 option(s):

A. YARN

B. Presto

C. QuickSight

D. Kinesis

Q7. Which of the following services can be used for monitoring and auditing S3 buckets. Choose 2 answers from the options given below

Select 2 option(s):

A. Cloudtrail

B. AWS Config

C. Cloudwatch

D. EMR

Q8. Which of the following options need to be incorporated in an EMR cluster for better security. Choose 3 answers from the options given below You have to do a security audit on an EMR cluster. Which of the following do you have to make sure are enabled? Choose the 3 correct answers:

Select 3 option(s):

A. Use SSL for data in transit between nodes in a cluster

B. Use Server side encryption on S3 using any one of the available encryption mechanisms

C. Ensure EBS Volumes are encrypted on the EC2 Instances

D. Use Hive encryption

Q9. Which of the following is not a performance factor when it comes to migrating databases using the AWS DB Migration service

Select 1 option(s):

A. Resource availability on the source

B. The resource capacity of the replication server

C. The VPC properties of the replication server

D. The number of objects to be migrated

Q10. There is a requirement to load a lot of data from your on-premise network on to AWS Redshift. Which of the below can be used for this data transfer. Choose 2 answers from the options given below.

Select 2 option(s):

A. Data Pipeline

B. Direct Connect

C. Snowball

D. Import/Export

Q11. Which of the following can be done to ensure the right compression settings are used for a Redshift table , if the compression settings are being entered manually?

Select 1 option(s):

A. Use Cloudwatch metrics to see how the data is being access

B. Use the Analyze compression command

C. Use Cloudwatch logs to see how the data is being access

D. Use the Evaluate compression command

Q12. You currently have a Redshift Cluster defined in AWS. The data is currently unencrypted in nature. You have now decided that the cluster needs to have encrypted data. How can you achieve this? Choose 2 answers from the options given below. Each answer forms part of the solution

Select 2 option(s):

A. Unload the data from the existing, source cluster

B. Reload the data in a new, target cluster with the chosen encryption setting

C. Make a backup of the data from the existing, source cluster

D. COPY the backup data to a new target cluster with the chosen encryption setting

Q13. A third party auditor is being brought in to review security processes and configurations for all of a company’s AWS accounts. Currently, the company does not use any on-premise identity provider. Instead, they rely on IAM accounts in each of their AWS accounts. The auditor needs read-only access to all AWS resources for each AWS account.Given the requirements, what is the best security method for architecting access for the security auditor? Choose the correct answer from the options below

Select 1 option(s):

A. Create an IAM user for each AWS account with read-only permission policies for the auditor, and disable each account when the audit is complete.

B. Configure an on-premise AD server and enable SAML and identify federation for single sign-on to each AWS account.

C. Create an IAM role with read-only permissions to all AWS services in each AWS account. Create one auditor IAM account and add a permissions policy that allows the auditor to assume the ARN role for each AWS account that has an assigned role.

D. Create a custom identity broker application that allows the auditor to use existing Amazon credentials to log into the AWS environments.

Q14. Your application currently use DynamoDB as the data store. You also have a test environment where you perform load tests on your application. There is a constant need to reset the data in the DynamoDB tables. How can this be achieved. Choose 2 answers from the options below. Each answer forms part of the solution.

Select 2 option(s):

A. Use the DynamoDB export feature to copy the data before the test begins

B. Use the DynamoDB import feature to copy the data after the test ends.

C. Use the AWS Data Pipeline to export data from a DynamoDB table to a file in an Amazon S3 bucket before the test begins

D. Use the AWS Data Pipeline to import data from a DynamoDB table from the file in an Amazon S3 bucket after the test ends

Q15. You have a series of locations in S3 where files need to be copied onto AWS Redshift. Which of the following can be used to specify the location of the files that need to be copied

Select 1 option(s):

A. Define a configuration file in Redshift with the location of the files

B. Create an event in S3 with the list of files to be copied

C. Create a manifest file with the list of files to be copied

D. Ensure the metadata for the bucket has the list of files that need to be copied

Q16. In order to efficiently insert or update data into a Redshift table , which of the following must be carried out

Select 1 option(s):

A. Setup a staging table

B. Use the Single merge command

C. Use the Upsert command

D. Issue the Insert command

Q17. You currently have Kinesis streams that are attached to an application. There are separate streams for separate consumers or clients. Each client needs to be billed separately and have a separate invoice. How can this be achieved.

Select 1 option(s):

A. Use Consolidated billing

B. Use Cloudwatch metrics to see the utilization and split the costs accordingly.

C. Use Cloudtrail to see the utilization and split the costs accordingly.

D. Tag the streams with each stream relevant to the client

Q18. You have created a DynamoDB table for an application that needs to support thousands of users. You need to ensure that each user can only access their own data in a particular table. Many users already have accounts with a third-party identity provider, such as Facebook, Google, or Login with Amazon. How would you implement this requirement. Choose 2 answers from the options given below

Select 2 option(s):

A. Create an IAM User for all users so that they can access the application.

B. Use Web identity federation and register your application with a third-party identity provider such as Google, Amazon, or Facebook.

C. Create an IAM role which has specific access to the DynamoDB table.

D. Use a third-party identity provider such as Google, Facebook or Amazon so users can become an AWS IAM User with access to the application.

Q19. Which of the following features in AWS IoT Core allows you can create a persistent, virtual version, or “shadow,” of each device?

Select 1 option(s):

A. Device Registries

B. Device copies

C. Device shadows

D. Device Mobile

Q20. Which of the following statements on resizing Redshift clusters is false?

Select 1 option(s):

A. One can use the resize operation with an existing cluster

B. One can use the snapshot and restore operations to make a copy of an existing cluster and then resize the new cluster.

C. You can continue to perform read and write operations as the cluster is being resized.

D. You can scale the cluster in or out by changing the number of nodes

Q21. Which of the following in IAM best practises is relevant to the term of “granting only the permissions required to perform a task”

Select 1 option(s):

A. Creating IAM users

B. Least privilege

C. Policy rotation

D. Creating IAM Groups

Q22. When configuring AWS Kinesis streams as the source for a Kinesis Data Firehose delivery stream which of the following API calls can be used to add data to the Kinesis Data Firehose delivery stream. Choose 2 answers from the options given below

Select 2 option(s):

A. PutRecord

B. PutRecords

C. PutRecordBatch

D. SendRecord

Q23. When working with DynamoDB tables, which of the following is a recommended best practice for getting the best throughput for your table

Select 1 option(s):

A. Create multiple partition keys for the table

B. Ensure the table has a sort key defined

C. Ensure the workload spread evenly across the partition key values

D. Ensure the workload spread evenly across the sort key values

Q24. When using IoT enabled devices to work with AWS IoT , which of the following is a recommendation.

Select 1 option(s):

A. All traffic to and from AWS IoT must be encrypted over Transport Layer Security (TLS)

B. The device should have an entry in the thing registry

C. Messages from the device should be sent in JSON format

D. Each device has a thing shadow to store and retrieve state information

Q25. Which of the following can be used along with Amazon EMR to perform SQL like queries on the data stored in EMR.

Select 1 option(s):

A. Hive

B. SQS

C. Redshift

D. Kinesis

Q26. You need to use the graphing tools available in Amazon Quicksight. Which of the following would you use for comparing measure values over time?

Select 1 option(s):

A. Scatter Plot

B. Bar Charts

C. Pivot Table

D. Line charts

Q27. You are using QuickSight to identify demand vs supply trends over multiple months. Which type of visualization do you choose?

Select 1 option(s):

A. Scatter Plot

B. Bar Charts

C. Pivot Table

D. Line Chart

Q28. 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

Q29. Which of the following commands can be used to transfer the results of a query in Redshift to Amazon S3?

Select 1 option(s):

A. COPY

B. EXPORT

C. UNLOAD

D. DistCp

Q30. Which of the following is done to create machine learning models in the AWS ML service

Select 1 option(s):

A. Creation of test models in the Machine Learning Designer

B. Creation of training data

C. Usage of existing blueprints in AWS Machine Learning

D. Using external blueprints in AWS Machine Learning

Q31. You are planning on loading a huge amount of data into a Redshift Cluster. You are not sure if the load will succeed or fail. Which of the below options can help see if an error would occur during the load process.

Select 1 option(s):

A. Use the IMPORT Command

B. Use the IMPORT command with the NOLOAD option

C. Use the COPY Command

D. Use the COPY command with the NOLOAD option

Q32. Which of the following commands can be used to see the impact of a query on a Redshift Table?

Select 1 option(s):

A. EXECUTE

B. EXPLAIN

C. TRY

D. PLAN

Q33. Your company is planning on creating an application that is going to make use of Amazon Kinesis. The stream records are going to be stored directly in S3. Which of the following is a recommended design approach with regards to this requirement

Select 1 option(s):

A. Create a consumer application using the KCL library to store the records in S3.

B. Create a DynamoDB stream to store the records in S3.

C. Use the events trigger in S3 to store the stream records

D. Use Kinesis Data Firehose delivery stream to stream the records to S3.

Q34. In AWS Cloudsearch , in order to ensure that data is searchable, in which formats should documents be represented as. Choose 2 answers from the options given below

Select 2 option(s):

A. XML

B. YAML

C. TXT

D. JSON

Q35. Which of the following methods can be used to disable automated snapshots in Redshift

Select 1 option(s):

A. Set the Snapshot Enabled flag to false

B. Set the retention period to zero

C. Set the retention period to 365

D. Set Automated Snapshots to false

Q36. There is a requirement to export data from DynamoDB tables to S3. How can this be achieved in the easiest way possible.

Select 1 option(s):

A. Configure an AWS Lambda function to copy data onto S3.

B. Configure DynamoDB streams to copy data onto S3

C. Configure AWS Data Pipeline to copy data onto S3

D. Configure AWS Import/Export to copy data onto S3

Q37. You are currently making use of the AWS Kinesis service for an application. You are currently looking at ways to cut down the cost if possible for the Kinesis based application if possible. Which of the following can be used to achieve this. Choose 2 answers from the options given below. Each answer forms part of the solution

Select 2 option(s):

A. Use Cloudwatch metrics to define those Kinesis shards which are “hot” shards

B. Use Cloudwatch metrics to define those Kinesis shards which are “cold” shards

C. Consider splitting shards wherever possible

D. Consider merging shards wherever possible

Q38. Which of the following is not a node type in Amazon EMR?

Select 1 option(s):

A. Master Node

B. Primary Node

C. Core Node

D. Task Node

Q39. You currently have a Kinesis stream configured in AWS. During the monitoring session you can see that certain records are being skipped. Where should you start searching to analyze the underlying issue?

Select 1 option(s):

A. Check that the streams have been tagged properly

B. Check the code for processRecords method

C. Check the limit for the GetRecords parameter

D. Check the limit for the PutRecords parameter

Q40. Which of the following is where the metadata definition is stored in the Aws Glue service

Select 1 option(s):

A. Config file

B. Table

C. Schema

D. Item

Q41. In an AWS EMR Cluster which of the following nodes is responsible for running the YARN ResourceManager service.

Select 1 option(s):

A. Master Node

B. Task Node

C. Core Node

D. Primary Node

Q42. When using the Kinesis Producer Library , which of the following can be used to increase the throughput of the number of records sent. Choose 2 answers from the options given below

Select 2 option(s):

A. Aggregation

B. Collection

C. Streaming

D. Sharding

Q43. Which of the following can be used to monitor EMR Clusters and give reports of the performance of the cluster as a whole?

Select 1 option(s):

A. Ganglia

B. Cloudwatch logs

C. Cloudtrail

D. AWS Config

Q44. Which of the following mechanisms can be used to protect data at rest in the Simple Storage Service? Choose 2 answers from the options given below

Select 2 option(s):

A. SSE-S3

B. SSE-KMS

C. HTTPS

D. SSL

Q45. Which of the following is the default input data format for Amazon EMR?

Select 1 option(s):

A. JSON

B. XML

C. Text

D. HTML

Q46. Which of the following commands in Redshift is efficient in loading large amounts of data

Select 1 option(s):

A. INSERT

B. UPDATE

C. COPY

D. LOAD

Q47. Which of the following SQL function statements can be used in Redshift to specify a result when there are multiple conditions.

Select 1 option(s):

A. If expression

B. If/then expression

C. If/then/else expression

D. Case expression

Q48. Which of the following facilitates the sending and receiving of messages with AWS IoT devices?

Select 1 option(s):

A. AWS SNS

B. Message Broker

C. AWS SQS

D. AWS IoT Publisher

Q49. The AWS IoT Core Device Gateway has support for which of the below protocols. Choose 2 answers from the options given below

Select 2 option(s):

A. PPP

B. MQTT

C. Websockets

D. IKE

Q50. Which of the following can be used in AWS Redshift to prioritize selected short-running queries ahead of longer-running queries

Select 1 option(s):

A. Transfer Acceleration

B. Short query acceleration

C. Long query acceleration

D. AWS query acceleration

Q51. You need to filter and transform incoming messages coming from a smart sensor you have connected with AWS. Once messages are received, you need to store them as time series data in DynamoDB. Which AWS service can you use?

Select 1 option(s):

A. Kinesis

B. Redshift

C. IoT Rules Engine

D. IoT Device Shadow

Q52. Which of the following is incorrect when it comes to the Kinesis client library?

Select 1 option(s):

A. It can be used to connect to a stream

B. You can create a stream using the KCL

C. You can enumerate the shards in the stream

D. You can pull data records from the stream

Q53. Which of the following is the term given to the data in Machine Learning where you already know the target answers

Select 1 option(s):

A. Labeled data

B. Completed data

C. Factual data

D. Primary data

Q54. You work for a company that deals with credit card based transactions. You have to identify potential fraudulent credit card transactions using Amazon Machine Learning. You have been given historical labeled data that you can use to create your model. You will also need to the ability to tune the model you pick. Which model type should you use for this sort of requirement?

Select 1 option(s):

A. Binary

B. Simple

C. Categorical

D. Regression

Q50. Which of the following services can be used for transformation of incoming source data in Amazon Kinesis Data Firehose

Select 1 option(s):

A. AWS EMR

B. AWS IoT

C. AWS Lambda

D. AWS Machine Learning

Q56. Your company has a set of web servers hosted on EC2 Instances. There is a requirement to push the logs from these web servers onto a suitable storage device for subsequent analysis. Which of the following can be steps for the implementation process which can satisfy these requirements

Select 2 option(s):

A. Install and configure the Kinesis agents on the web servers

B. Install and configure the Cloudwatch agent on the web servers

C. Ensure that Kinesis Firehose is setup to take the data and send it across to Redshift for further processing

D. Ensure that Kinesis Firehose is setup to take the data and send it across to EMR for further processing

Q57. Which of the following can be used to manage notebook documents using a web browse

Select 1 option(s):

A. Jupyter

B. D3.js

C. EMR

D. Quicksight

Q58. When planning for the Instance type for EMR nodes , which of the following generally does not need a high configuration in terms of both computing and memory.

Select 1 option(s):

A. Master Node

B. Task Nodes

C. Core Nodes

D. Both Core and Master Nodes

Q59. You are planning on using AWS Data Pipeline to transfer data from DynamoDB to S3. The DynamoDB tables gets populated by an application. The application generates tables based on orders made to particular products. How can you ensure that the Data pipeline is triggered only when data is actually written to a DynamoDB table by the application?

Select 1 option(s):

A. Configure the application to send an SNS notification to AWS DataPipeline once data has been written

B. Configure an SQS queue with the application sending messages to the queue once the table data is available and data pipeline reading the data subsequently

C. Configure DynamoDB streams to notify AWS Data Pipeline once data is available

D. Use the preconditions available in AWS DataPipeline

Q60. You are trying to connect to the master node for your EMR cluster. Which of the following must be checked to ensure that the connection is successful

Select 1 option(s):

A. Check the Inbound rules for the Security Group for the master node.

B. Check the Outbound rules for the Security Group for the master node.

C. Ensure that the master node is launched in a private subnet

D. This is not possible because you are not allowed to connect to the master node in an EMR cluster