Missed Practice Exam Questions

Question 1

What are some tool options for public online interactive data visualization at low cost?

Answer 1

HighChart and D3.js

Question 2

What is the data capacity limit in Aurora?

Answer 2

64TB

Question 3

What are some ways that HBase can integrate with S3?

Answer 3

Read replicas on S3, Store HBase StoreFiles and metadata on S3, Snapshots of HBase data on S3

Question 4

What needs to be done to ensure that all VPC flow logs for Redshift COPY and UNLOAD commands are logged?

Answer 4

Enable Enhanced VPC Routing (forces all commands to use the VPC)

Question 5

What visualization type should be used when there is multi-dimensional data that needs to be analyzed for outliers and trends?

Answer 5

Heatmap

Question 6

What should be done if you are using EMR with S3 data and you encounter consistency issues?

Answer 6

Enable EMRFS

Question 7

How should you implement a real-time, multi-AZ replica of a Redshift cluster?

Answer 7

Spin up separate Redshift clusters across AZs, use Kinesis Streams to simultaneously write data to each other, use Route53 to route users to the nearest cluster

Question 8

What two methods can be employed to outside access Kibana deployed within a VPC?

Answer 8

Setup an SSH tunnel with port forwarding to allow access on port 5601 or Set up a reverse proxy server between your browser and Elasticsearch Service

Question 9

What security option should be employed on an S3 bucket when you need to restrict user access at a file level?

Answer 9

SSE-KMS

Question 10

What is the maximum buffer time in Kinesis Firehose?

Answer 10

5 minutes

Question 11

Does Glue integrate with Elasticsearch?

Answer 11

No

Question 12

Which services should be avoided if requirements demand low maintenance?

Answer 12

Kinesis Data Streams, EMR

Question 13

Which IoT authentication protocol is most popular with mobile devices?

Answer 13

Cognito

Question 14

What are best practices for loading large amounts of data between S3 and Redshift regularly?

Answer 14

Split files into 1 to 124MB files, use GZIP compression, use a single COPY command, load data in the same order as your sort key

Question 15

What tool should be used for integrating data between relational databases and EMR?

Answer 15

Sqoop

Question 16

What security mechanisms are supported by EMR?

Answer 16

LUKS, KMS, SSE-KMS

Question 17

What are three ways that Pig integrates with S3?

Answer 17

Directly writing to HCatalog tables in S3, Loading customer JAR files from S3 using the REGISTER command, Submitting work on the EMR console using Pig scripts stored in S3

Question 18

Can Pig integrate with Glue?

Answer 18

No

Question 19

Does EMRFS offer a caching feature?

Answer 19

No

Question 20

What should be done when experiencing high costs and low speeds when using EMRFS?

Answer 20

Use S3DistCp as a preliminary step

Question 21

Can Athena access S3 data that is in Glacier?

Answer 21

No

Question 22

Where must encryption artifacts be stored when configuring in flight encryption between S3 and EMR?

Answer 22

S3

Question 23

In Kinesis Data Analytics, what are Stagger Windowed queries best for?

Answer 23

Data arriving at inconsistent times