BDS-C00 Online Practice Questions and Answers

An online photo album app has a key design feature to support multiple screens (e.g, desktop, mobile phone, and tablet) with high-quality displays. Multiple versions of the image must be saved in different resolutions and layouts.

The image-processing Java program takes an average of five seconds per upload, depending on the image size and format. Each image upload captures the following image metadata: user, album, photo label, upload timestamp.

The app should support the following requirements:

1.

Hundreds of user image uploads per second

2.

Maximum image upload size of 10 MB

3.

Maximum image metadata size of 1 KB

4.

Image displayed in optimized resolution in all supported screens no later than one minute after image upload

Which strategy should be used to meet these requirements?

A. Write images and metadata to Amazon Kinesis. Use a Kinesis Client Library (KCL) application to run the image processing and save the image output to Amazon S3 and metadata to the app repository DB.

B. Write image and metadata RDS with BLOB data type. Use AWS Data Pipeline to run the image processing and save the image output to Amazon S3 and metadata to the app repository DB.

C. Upload image with metadata to Amazon S3, use Lambda function to run the image processing and save the images output to Amazon S3 and metadata to the app repository DB.

D. Write image and metadata to Amazon Kinesis. Use Amazon Elastic MapReduce (EMR) with Spark Streaming to run image processing and save the images output to Amazon S3 and metadata to app repository DB.

A customer needs to determine the optimal distribution strategy for the ORDERS fact table in its Redshift schema. The ORDERS table has foreign key relationships with multiple dimension tables in this schema.

How should the company determine the most appropriate distribution key for the ORDERS table?

A. Identify the largest and most frequently joined dimension table and ensure that it and the ORDERS table both have EVEN distribution.

B. Identify the largest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.

C. Identify the smallest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.

D. Identify the largest and the most frequently joined dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.

Managers in a company need access to the human resources database that runs on Amazon Redshift, to run reports about their employees. Managers must only see information about their direct reports.

Which technique should be used to address this requirement with Amazon Redshift?

A. Define an IAM group for each manager with each employee as an IAM user in that group, and use that to limit the access.

B. Use Amazon Redshift snapshot to create one cluster per manager. Allow the managers to access only their designated clusters.

C. Define a key for each manager in AWS KMS and encrypt the data for their employees with their private keys.

D. Define a view that uses the employee's manager name to filter the records based on current user names.

An advertising organization uses an application to process a stream of events that are received from

clients in multiple unstructured formats.

The application does the following:

Transforms the events into a single structured format and streams them to Amazon Kinesis for real-time

analysis.

Stores the unstructured raw events from the log files on local hard drivers that are rotated and uploaded to

Amazon S3.

The organization wants to extract campaign performance reporting using an existing Amazon redshift

cluster.

Which solution will provide the performance data with the LEAST number of operations?

A. Install the Amazon Kinesis Data Firehose agent on the application servers and use it to stream the log files directly to Amazon Redshift.

B. Create an external table in Amazon Redshift and point it to the S3 bucket where the unstructured raw

events are stored.

C. Write an AWS Lambda function that triggers every hour to load the new log files already in S3 to Amazon redshift.

D. Connect Amazon Kinesis Data Firehose to the existing Amazon Kinesis stream and use it to stream the event directly to Amazon Redshift.

An organization's data warehouse contains sales data for reporting purposes. data governance policies prohibit staff from accessing the customers' credit card numbers.

How can these policies be adhered to and still allow a Data Scientist to group transactions that use the same credit card number?

A. Store a cryptographic hash of the credit card number.

B. Encrypt the credit card number with a symmetric encryption key, and give the key only to the authorized Data Scientist.

C. Mask the credit card numbers to only show the last four digits of the credit card number.

D. Encrypt the credit card number with an asymmetric encryption key and give the decryption key only to the authorized Data Scientist.

The Trusted Advisor service provides insight regarding which four categories of an AWS account?

A. Security, fault tolerance, high availability, and connectivity

B. Security, access control, high availability, and performance

C. Performance, cost optimization, security, and fault tolerance

D. Performance, cost optimization, access control, and connectivity

Your company wants to start working with AWS, but has not yet opened an account. With which of the following services should you begin local development?

A. Amazon DynamoDB

B. Amazon Simple Queue Service

C. Amazon Simple Email Service

D. Amazon CloudSearch

In AWS, which security aspects are the customer's responsibility? Choose 4 answers

A. Life-Cycle management of IAM credentials

B. Security Group and ACL settings

C. Controlling physical access to compute resources

D. Path management on the EC2 instance's operating system

E. Encryption of EBS volumes

F. Decommissioning storage devices

A user has created an ELB with Auto Scaling. Which of the below mentioned offerings from ELB helps the user to stop sending new requests traffic from the load balancer to the EC2 instance when the instance is being deregistered while continuing in-flight requests?

A. ELB sticky session

B. ELB deregistration check

C. ELB connection draining

D. ELB auto registration Off

If I modify a DB Instance or the DB parameter group associated with the instance, should I reboot the instance for the changes to take effect?

A. No

B. Yes