Amazon BDS-C00 Exam Questions Instant Access

Question 1

A data engineer is running a DWH on a 25-node Redshift cluster of a SaaS service. The data engineer needs to build a dashboard that will be used by customers. Five big customers represent 80% of usage, and there is a long tail of dozens of smaller customers. The data engineer has selected the dashboarding tool.

How should the data engineer make sure that the larger customer workloads do NOT interfere with the smaller customer workloads?

AApply query filters based on customer-id that can NOT be changed by the user and apply distribution keys on customer id

BPlace the largest customers into a single user group with a dedicated query queue and place the rest of the customer into a different query queue

CPush aggregations into an RDS for Aurora instance. Connect the dashboard application to Aurora rather than Redshift for faster queries

DRoute the largest customers to a dedicated Redshift cluster, Raise the concurrency of the multi-tenant Redshift cluster to accommodate the remaining customers

Answer : B

https://docs.aws.amazon.com/redshift/latest/dg/c_workload_mngmt_classification.html

Question 2

A company operates an international business served from a single AWS region. The company wants to expand into a new country. The regulator for that country requires the Data Architect to maintain a log of financial transactions in the country within 24 hours of production transaction. The production application is latency insensitive. The new country contains another AWS region.

What is the most cost-effective way to meet this requirement?

AUse CloudFormation to replicate the production application to the new region

BUse Amazon CloudFront to serve application content locally in the country; Amazon CloudFront logs will satisfy the requirement

CContinue to serve customers from the existing region while using Amazon Kinesis to stream transaction data to the regulator

DUse Amazon S3 cross-region replication to copy and persist production transaction logs to a budget the new country's region

Answer : D

https://docs.aws.amazon.com/AmazonCloudFront/latest/DeveloperGuide/AccessLogs.html

Question 3

You have a web application that is currently running on a collection of micro instance types in a single AZ

behind a single load balancer. You have an Auto Scaling group configured to scale from 2 to 64 instances. When reviewing your CloudWatch metrics, you see that sometimes your Scaling group is running 64 micro instances. The web application is reading and writing to a DyanamoDB-configured backend and configured with 800 Write Capacity units and 800 Read Capacity units. Your customers are complaining that they are experiencing load times when viewing you website. You have investigated the DynamoDB CloudWatch metrics; you are under the provisioned read and Write Capacity units and there is no throttling.

How do you scale your service to improve the load times and ensure the principles of high availability?

AChange your Auto Scaling group configuration to include multiple AZs

BChange you Auto Scaling group configuration to include multiple AZs, and increase the number of Read Capacity units in your DynamoDB table by a factor of three, because you will need to be calling DynamoDB from three AZs

CAdd a second load balancer to your Auto Scaling group so that you can support more inbound connections per second

DChange your Auto Scaling group configuration to use larger instances and include multiple AZs instead of one

Answer : D

Question 4

There are thousands of text files on Amazon S3. The total size of the files is 1 PB. The files contain retail order information for the past 2 years. A data engineer needs to run multiple interactive queries to manipulate the data. The data Engineer has AWS access to spin up an Amazon EMR cluster. The data Engineer needs to use an application on the cluster to process this data and return the results in interactive time frame. Which application on the cluster should be the data engineer use?

AOozie

BApache Pig with Tachyon

CApache Hive

DPresto

Answer : D

Question 5

Fill in the blanks: _____ is a durable, block-level storage volume that you can attach to a single, running Amazon EC2 instance.

AAmazon S3

BAmazon EBS

CNone of these

DAll of these

Answer : B

Question 6

An organization is soliciting public feedback through a web portal that has been deployed to track the number of requests and other important data. As part of reporting and visualization, AmazonQuickSight connects to an Amazon RDS database to virtualize data. Management wants to understand some important metrics about feedback and how the feedback has changed over the last four weeks in a visual representation.

What would be the MOST effective way to represent multiple iterations of an analysis in Amazon QuickSight that would show how the data has changed over the last four weeks?

AUse the analysis option for data captured in each week and view the data by a date range.

BUse a pivot table as a visual option to display measured values and weekly aggregate data as a row dimension.

CUse a dashboard option to create an analysis of the data for each week and apply filters to visualize the data change.

DUse a story option to preserve multiple iterations of an analysis and play the iterations sequentially.

Answer : D

https://docs.aws.amazon.com/quicksight/latest/user/working-with-stories.html

Question 7

Amazon S3 doesn't automatically give a user who creates _____ permission to perform other actions on that bucket or object.

Aa file

Ba bucket or object

Ca bucket or file

Da object or file

Answer : B

Amazon AWS Certified Big Data - Specialty BDS-C00 Exam Questions