Home / Amazon / BDS-C00

Amazon BDS-C00 Practice Test - Questions Answers, Page 8

Question list

List of questions

Question 71

(0)

An Operations team continuously monitors the number of visitors to a website to identify any potential system problems. The number of website visitors varies throughout the day. The site is more pop

Question 72

(0)

An organization would like to run analytics on their Elastic Load Balancing logs stored in Amazon S3 and join this data with other tables in Amazon S3. The users are currently using a BI tool connec

Question 73

(0)

An organization has added a clickstream to their website to analyze traffic. The website is sending each page request with the PutRecord API call to an Amazon Kinesis stream by using the page name a

Question 74

(0)

An organization currently runs a large Hadoop environment in their data center and is in the process of creating an alternative Hadoop environment on AWS, using Amazon EMR. They generate around 20

Question 75

(0)

An organization is developing a mobile social application and needs to collect logs from all devices on which it is installed. The organization is evaluating the Amazon Kinesis Data Streams to push

Question 76

(0)

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 ev

Question 77

(0)

An organization is designing an Amazon DynamoDB table for an application that must meet the following requirements: Item size is 40 KB Read/write ratio 2000/500 sustained, respectively Heavily rea

Question 78

(0)

An organization needs to store sensitive information on Amazon S3 and process it through Amazon EMR. Data must be encrypted on Amazon S3 and Amazon EMR at rest and in transit. Using Thrift Server, t

Question 79

(0)

Multiple rows in an Amazon Redshift table were accidentally deleted. A System Administrator is restoring the table from the most recent snapshot. The snapshot contains all rows that were in the tabl

Question 80

(0)

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 adh

Related questions

A travel website needs to present a graphical quantitative summary of its daily bookings to website visitors for marketing purposes. The website has millions of visitors per day, but wants to control costs by implementing the least-expensive solution for this visualization. What is the most cost-effective solution?

Multiple rows in an Amazon Redshift table were accidentally deleted. A System Administrator is restoring the table from the most recent snapshot. The snapshot contains all rows that were in the table before the deletion. What is the SIMPLEST solution to restore the table without impacting users?

An organization currently runs a large Hadoop environment in their data center and is in the process of creating an alternative Hadoop environment on AWS, using Amazon EMR. They generate around 20 TB of data on a monthly basis. Also on a monthly basis, files need to be grouped and copied to Amazon S3 to be used for the Amazon EMR environment. They have multiple S3 buckets across AWS accounts to which data needs to be copied. There is a 10G AWS Direct Connect setup between their data center and AWS, and the network team has agreed to allocate

An organization is currently using an Amazon EMR long-running cluster with the latest Amazon EMR release for analytic jobs and is storing data as external tables on Amazon S3. The company needs to launch multiple transient EMR clusters to access the same tables concurrently, but the metadata about the Amazon S3 external tables are defined and stored on the long-running cluster. Which solution will expose the Hive metastore with the LEAST operational effort?

A customer has an Amazon S3 bucket. Objects are uploaded simultaneously by a cluster of servers from multiple streams of data. The customer maintains a catalog of objects uploaded in Amazon S3 using an Amazon DynamoDB table. This catalog has the following fileds: StreamName, TimeStamp, and ServerName, from which ObjectName can be obtained. The customer needs to define the catalog to support querying for a given stream or server within a defined time range. Which DynamoDB table scheme is most efficient to support these queries?

A gas company needs to monitor gas pressure in their pipelines. Pressure data is streamed from sensors placed throughout the pipelines to monitor the data in real time. When an anomaly is detected, the system must send a notification to open valve. An Amazon Kinesis stream collects the data from the sensors and an anomaly Kinesis stream triggers an AWS Lambda function to open the appropriate valve. Which solution is the MOST cost-effective for responding to anomalies in real time?

A company uses Amazon Redshift for its enterprise data warehouse. A new on-premises PostgreSQL OLTP DB must be integrated into the data warehouse. Each table in the PostgreSQL DB has an indexed last_modified timestamp column. The data warehouse has a staging layer to load source data into the data warehouse environment for further processing. The data lag between the source PostgreSQL DB and the Amazon Redshift staging layer should NOT exceed four hours. What is the most efficient technique to meet these requirements?

An organization is designing an application architecture. The application will have over 100 TB of data and will support transactions that arrive at rates from hundreds per second to tens of thousands per second, depending on the day of the week and time of day. All transaction data, must be durably and reliably stored. Certain read operations must be performed with strong consistency. Which solution meets these requirements?

A medical record filing system for a government medical fund is using an Amazon S3 bucket to archive documents related to patients. Every patient visit to a physician creates a new file, which can add up millions of files each month. Collection of these files from each physician is handled via a batch process that runs everу night using AWS Data Pipeline. This is sensitive data, so the data and any associated metadata must be encrypted at rest. Auditors review some files on a quarterly basis to see whether the records are maintained according to regulations. Auditors must be able to locate any physical file in the S3 bucket for a given date, patient, or physician. Auditors spend a significant amount of time location such files. What is the most cost- and time-efficient collection methodology in this situation?

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?

Question 71

An Operations team continuously monitors the number of visitors to a website to identify any potential system problems. The number of website visitors varies throughout the day. The site is more popular in the middle of the day and less popular at night.

Which type of dashboard display would be the MOST useful to allow staff to quickly and correctly identify system problems?

A vertical stacked bar chart showing today's website visitors and the historical average number of website visitors.

An overlay line chart showing today's website visitors at one-minute intervals and also the historical average number of website visitors.

A single KPI metric showing the statistical variance between the current number of website visitors and the historical number of website visitors for thecurrent time of day.

A scatter plot showing today's website visitors on the X-axis and the historical average number of website visitors on the Y-axis.

Show Answer Comment (0)

Question 72

An organization would like to run analytics on their Elastic Load Balancing logs stored in Amazon S3 and join this data with other tables in Amazon S3. The users are currently using a BI tool connecting with JDBC and would like to keep using this BI tool.

Which solution would result in the LEAST operational overhead?

Trigger a Lambda function when a new log file is added to the bucket to transform and load it into Amazon Redshift. Run the VACUUM command on theAmazon Redshift cluster every night.

Launch a long-running Amazon EMR cluster that continuously downloads and transforms new files from Amazon S3 into its HDFS storage. Use Presto toexpose the data through JDBC.

Trigger a Lambda function when a new log file is added to the bucket to transform and move it to another bucket with an optimized data structure. UseAmazon Athena to query the optimized bucket.

Launch a transient Amazon EMR cluster every night that transforms new log files and loads them into Amazon Redshift.

Show Answer Comment (0)

Question 73

An organization has added a clickstream to their website to analyze traffic. The website is sending each page request with the PutRecord API call to an Amazon Kinesis stream by using the page name as the partition key. During peak spikes in website traffic, a support engineer notices many ProvisionedThroughputExcededException events in the application logs.

What should be done to resolve the issue in the MOST cost-effective way?

Create multiple Amazon Kinesis streams for page requests to increase the concurrency of the clickstream.

Increase the number of shards on the Kinesis stream to allow for more throughput to meet the peak spikes in traffic.

Modify the application to use on the Kinesis Producer Library to aggregate requests before sending them to the Kinesis stream.

Attach more consumers to the Kinesis stream to process records in parallel, improving the performance on the stream.

Show Answer Comment (0)

Question 74

An organization currently runs a large Hadoop environment in their data center and is in the process of creating an alternative Hadoop environment on AWS, using Amazon EMR.

They generate around 20 TB of data on a monthly basis. Also on a monthly basis, files need to be grouped and copied to Amazon S3 to be used for the Amazon

EMR environment. They have multiple S3 buckets across AWS accounts to which data needs to be copied. There is a 10G AWS Direct Connect setup between their data center and AWS, and the network team has agreed to allocate

Use an offline copy method, such as an AWS Snowball device, to copy and transfer data to Amazon S3.

Configure a multipart upload for Amazon S3 on AWS Java SDK to transfer data over AWS Direct Connect.

Use Amazon S3 transfer acceleration capability to transfer data to Amazon S3 over AWS Direct Connect.

Setup S3DistCop tool on the on-premises Hadoop environment to transfer data to Amazon S3 over AWS Direct Connect.

Show Answer Comment (0)

Question 75

An organization is developing a mobile social application and needs to collect logs from all devices on which it is installed. The organization is evaluating the Amazon Kinesis Data Streams to push logs and Amazon EMR to process data. They want to store data on HDFS using the default replication factor to replicate data among the cluster, but they are concerned about the durability of the data. Currently, they are producing 300 GB of raw data daily, with additional spikes during special events. They will need to scale out the Amazon EMR cluster to match the increase in streamed data. Which solution prevents data loss and matches compute demand?

Use multiple Amazon EBS volumes on Amazon EMR to store processed data and scale out the Amazon EMR cluster as needed.

Use the EMR File System and Amazon S3 to store processed data and scale out the Amazon EMR cluster as needed.

Use Amazon DynamoDB to store processed data and scale out the Amazon EMR cluster as needed.

use Amazon Kinesis Data Firehose and, instead of using Amazon EMR, stream logs directly into Amazon Elasticsearch Service.

Show Answer Comment (0)

Question 76

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?

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

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

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

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

Show Answer Comment (0)

Question 77

An organization is designing an Amazon DynamoDB table for an application that must meet the following requirements: Item size is 40 KB

Read/write ratio 2000/500 sustained, respectively

Heavily read-oriented and requires low latencies in the order of milliseconds

The application runs on an Amazon EC2 instance

Access to the DynamoDB table must be secure within the VPC

Minimal changes to application code to improve performance using write-through cache Which design options will BEST meet these requirements?

Size the DynamoDB table with 10000 RCUs/20000 WCUs, implement the DynamoDB Accelerator (DAX) for read performance, use VPC endpoints forDynamoDB, and implement an IAM role on the EC2 instance to secure DynamoDBaccess.

Size the DynamoDB table with 20000 RCUs/20000 WCUs, implement the DynamoDB Accelerator (DAX) for read performance, leverage VPC endpoints forDynamoDB, and implement an IAM user on the EC2 instance to secureDynamoDB access.

Size the DynamoDB table with 10000 RCUs/20000 WCUs, implement Amazon ElastiCache for read performance, set up a NAT gateway on VPC for the EC2instance to access DynamoDB, and implement an IAM role on the EC2instance to secure DynamoDB access.

Size the DynamoDB table with 20000 RCUs/20000 WCUs, implement Amazon ElastiCache for read performance, leverage VPC endpoints for DynamoDB,and implement an IAM user on the EC2 instance to secure DynamoDB access.

Show Answer Comment (0)

Question 78

An organization needs to store sensitive information on Amazon S3 and process it through Amazon EMR. Data must be encrypted on Amazon S3 and Amazon EMR at rest and in transit. Using Thrift Server, the Data Analysis team users HIVE to interact with this data. The organization would like to grant access to only specific databases and tables, giving permission only to the SELECT statement.

Which solution will protect the data and limit user access to the SELECT statement on a specific portion of data?

Configure Transparent Data Encryption on Amazon EMR. Create an Amazon EC2 instance and install Apache Ranger. Configure the authorization on thecluster to use Apache Ranger.

Configure data encryption at rest for EMR File System (EMRFS) on Amazon S3. Configure data encryption in transit for traffic between Amazon S3 andEMRFS. Configure storage and SQL base authorization on HiveServer2.

Use AWS KMS for encryption of data. Configure and attach multiple roles with different permissions based on the different user needs.

Configure Security Group on Amazon EMR. Create an Amazon VPC endpoint for Amazon S3. Configure HiveServer2 to use Kerberos authentication on thecluster.

Show Answer Comment (0)

Question 79

What is the SIMPLEST solution to restore the table without impacting users?

Restore the snapshot to a new Amazon Redshift cluster, then UNLOAD the table to Amazon S3. In the original cluster, TRUNCATE the table, then load thedata from Amazon S3 by using a COPY command.

Use the Restore Table from a Snapshot command and specify a new table name DROP the original table, then RENAME the new table to the original tablename.

Restore the snapshot to a new Amazon Redshift cluster. Create a DBLINK between the two clusters in the original cluster, TRUNCATE the destination table,then use an INSERT command to copy the data from the new cluster.

Use the ALTER TABLE REVERT command and specify a time stamp of immediately before the data deletion. Specify the Amazon Resource Name of thesnapshot as the SOURCE and use the OVERWRITE REPLACE option.

Show Answer Comment (0)

Question 80

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?

Store a cryptographic hash of the credit card number.

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

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

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

Show Answer Comment (0)

Total 85 questions

5 6 7 8 9

Go to page: of 9