AWS Certified Big Data - Specialty practice test

1. Question 1 · 1

   A data engineer in a manufacturing company is designing a data processing platform that receives a large volume of unstructured data. The data engineer must populate a well-structured star schema in Amazon Redshift. What is the most efficient architecture strategy for this purpose?

   Choose one answer.

   • Transform the unstructured data using Amazon EMR and generate CSV data. COPY the CSV data into the analysis schema within Redshift.
   • Load the unstructured data into Redshift, and use string parsing functions to extract structured data for inserting into the analysis schema.
   • When the data is saved to Amazon S3, use S3 Event Notifications and AWS Lambda to transform the file contents. Insert the data into the analysis schema on Redshift.
   • Normalize the data using an AWS Marketplace ETL tool, persist the results to Amazon S3, and use AWS Lambda to INSERT the data into Redshift.

2. Question 2 · 1

   A company has several teams of analysts. Each team of analysts has their own cluster. The teams need to run SQL queries using Hive, Spark-SQL, and Presto with Amazon EMR. The company needs to enable a centralized metadata layer to expose the Amazon S3 objects as tables to the analysts. Which approach meets the requirement for a centralized metadata layer?

   Choose one answer.

   • EMRFS consistent view with a common Amazon DynamoDB table
   • Bootstrap action to change the Hive Metastore to an Amazon RDS database
   • s3distcp with the outputManifest option to generate RDS DDL
   • Naming scheme support with automatic partition discovery from Amazon S3

3. Question 3 · 1

   An administrator needs to manage a large catalog of items from various external sellers. The administrator needs to determine if the items should be identified as minimally dangerous, dangerous, or highly dangerous based on their textual descriptions. The administrator already has some items with the danger attribute, but receives hundreds of new item descriptions every day without such classification. The administrator has a system that captures dangerous goods reports from customer support team of from user feedback. What is a cost-effective architecture to solve this issue?

   Choose one answer.

   • Build a set of regular expression rules that are based on the existing examples, and run them on the DynamoDB Streams as every new item description is added to the system.
   • Build a Kinesis Streams process that captures and marks the relevant items in the dangerous goods reports using a Lambda function once more than two reports have been filed.
   • Build a machine learning model to properly classify dangerous goods and run it on the DynamoDB Streams as every new item description is added to the system.
   • Build a machine learning model with binary classification for dangerous goods and run it on the DynamoDB Streams as every new item description is added to the system.

4. Question 4 · 1

   A company receives data sets coming from external providers on Amazon S3. Data sets from different providers are dependent on one another. Data sets will arrive at different times and in no particular order. A data architect needs to design a solution that enables the company to do the following: ✑ Rapidly perform cross data set analysis as soon as the data becomes available ✑ Manage dependencies between data sets that arrive at different times Which architecture strategy offers a scalable and cost-effective solution that meets these requirements?

   Choose one answer.

   • Maintain data dependency information in Amazon RDS for MySQL. Use an AWS Data Pipeline job to load an Amazon EMR Hive table based on task dependencies and event notification triggers in Amazon S3.
   • Maintain data dependency information in an Amazon DynamoDB table. Use Amazon SNS and event notifications to publish data to fleet of Amazon EC2 workers. Once the task dependencies have been resolved, process the data with Amazon EMR.
   • Maintain data dependency information in an Amazon ElastiCache Redis cluster. Use Amazon S3 event notifications to trigger an AWS Lambda function that maps the S3 object to Redis. Once the task dependencies have been resolved, process the data with Amazon EMR.
   • Maintain data dependency information in an Amazon DynamoDB table. Use Amazon S3 event notifications to trigger an AWS Lambda function that maps the S3 object to the task associated with it in DynamoDB. Once all task dependencies have been resolved, process the data with Amazon EMR.

5. Question 5 · 1

   A media advertising company handles a large number of real-time messages sourced from over 200 websites in real time. Processing latency must be kept low. Based on calculations, a 60-shard Amazon Kinesis stream is more than sufficient to handle the maximum data throughput, even with traffic spikes. The company also uses an Amazon Kinesis Client Library (KCL) application running on Amazon Elastic Compute Cloud (EC2) managed by an Auto Scaling group. Amazon CloudWatch indicates an average of 25% CPU and a modest level of network traffic across all running servers. The company reports a 150% to 200% increase in latency of processing messages from Amazon Kinesis during peak times. There are NO reports of delay from the sites publishing to Amazon Kinesis. What is the appropriate solution to address the latency?

   Choose one answer.

   • Increase the number of shards in the Amazon Kinesis stream to 80 for greater concurrency.
   • Increase the size of the Amazon EC2 instances to increase network throughput.
   • Increase the minimum number of instances in the Auto Scaling group.
   • Increase Amazon DynamoDB throughput on the checkpoint table.

6. Question 6 · 1

   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 the product 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?

   Choose one answer.

   • Use CloudFormation to replicate the production application to the new region.
   • Use Amazon CloudFront to serve application content locally in the country; Amazon CloudFront logs will satisfy the requirement.
   • Continue to serve customers from the existing region while using Amazon Kinesis to stream transaction data to the regulator.
   • Use Amazon S3 cross-region replication to copy and persist production transaction logs to a bucket in the new countrys region.

7. Question 7 · 1

   An administrator needs to design the event log storage architecture for events from mobile devices. The event data will be processed by an Amazon EMR cluster daily for aggregated reporting and analytics before being archived. How should the administrator recommend storing the log data?

   Choose one answer.

   • Create an Amazon S3 bucket and write log data into folders by device. Execute the EMR job on the device folders.
   • Create an Amazon DynamoDB table partitioned on the device and sorted on date, write log data to table. Execute the EMR job on the Amazon DynamoDB table.
   • Create an Amazon S3 bucket and write data into folders by day. Execute the EMR job on the daily folder.
   • Create an Amazon DynamoDB table partitioned on EventID, write log data to table. Execute the EMR job on the table.

8. Question 8 · 1

   A data engineer wants to use an Amazon Elastic Map Reduce for an application. The data engineer needs to make sure it complies with regulatory requirements. The auditor must be able to confirm at any point which servers are running and which network access controls are deployed. Which action should the data engineer take to meet this requirement?

   Choose one answer.

   • Provide the auditor IAM accounts with the SecurityAudit policy attached to their group.
   • Provide the auditor with SSH keys for access to the Amazon EMR cluster.
   • Provide the auditor with CloudFormation templates.
   • Provide the auditor with access to AWS DirectConnect to use their existing tools.

9. Question 9 · 1

   A social media customer has data from different data sources including RDS running MySQL, Redshift, and Hive on EMR. To support better analysis, the customer needs to be able to analyze data from different data sources and to combine the results. What is the most cost-effective solution to meet these requirements?

   Choose one answer.

   • Load all data from a different database/warehouse to S3. Use Redshift COPY command to copy data to Redshift for analysis.
   • Install Presto on the EMR cluster where Hive sits. Configure MySQL and PostgreSQL connector to select from different data sources in a single query.
   • Spin up an Elasticsearch cluster. Load data from all three data sources and use Kibana to analyze.
   • Write a program running on a separate EC2 instance to run queries to three different systems. Aggregate the results after getting the responses from all three systems.

10. Question 10 · 1

    An Amazon EMR cluster using EMRFS has access to petabytes of data on Amazon S3, originating from multiple unique data sources. The customer needs to query common fields across some of the data sets to be able to perform interactive joins and then display results quickly. Which technology is most appropriate to enable this capability?

    Choose one answer.

    • Presto
    • MicroStrategy
    • Pig
    • R Studio

11. Question 11 · 1

    A game company needs to properly scale its game application, which is backed by DynamoDB. Amazon Redshift has the past two years of historical data. Game traffic varies throughout the year based on various factors such as season, movie release, and holiday season. An administrator needs to calculate how much read and write throughput should be provisioned for DynamoDB table for each week in advance. How should the administrator accomplish this task?

    Choose one answer.

    • Feed the data into Amazon Machine Learning and build a regression model.
    • Feed the data into Spark Mlib and build a random forest modest.
    • Feed the data into Apache Mahout and build a multi-classification model.
    • Feed the data into Amazon Machine Learning and build a binary classification model.

12. Question 12 · 1

    A large oil and gas company needs to provide near real-time alerts when peak thresholds are exceeded in its pipeline system. The company has developed a system to capture pipeline metrics such as flow rate, pressure, and temperature using millions of sensors. The sensors deliver to AWS IoT. What is a cost-effective way to provide near real-time alerts on the pipeline metrics?

    Choose one answer.

    • Create an AWS IoT rule to generate an Amazon SNS notification.
    • Store the data points in an Amazon DynamoDB table and poll if for peak metrics data from an Amazon EC2 application.
    • Create an Amazon Machine Learning model and invoke it with AWS Lambda.
    • Use Amazon Kinesis Streams and a KCL-based application deployed on AWS Elastic Beanstalk.

13. Question 13 · 1

    A company is using Amazon Machine Learning as part of a medical software application. The application will predict the most likely blood type for a patient based on a variety of other clinical tests that are available when blood type knowledge is unavailable. What is the appropriate model choice and target attribute combination for this problem?

    Choose one answer.

    • Multi-class classification model with a categorical target attribute.
    • Regression model with a numeric target attribute.
    • Binary Classification with a categorical target attribute.
    • K-Nearest Neighbors model with a multi-class target attribute.

14. Question 14 · 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?

    Choose one answer.

    • Apply query filters based on customer-id that can NOT be changed by the user and apply distribution keys on customer-id.
    • Place the largest customers into a single user group with a dedicated query queue and place the rest of the customers into a different query queue.
    • Push aggregations into an RDS for Aurora instance. Connect the dashboard application to Aurora rather than Redshift for faster queries.
    • Route the largest customers to a dedicated Redshift cluster. Raise the concurrency of the multi-tenant Redshift cluster to accommodate the remaining customers.

15. Question 15 · 1

    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: ✑ Hundreds of user image uploads per second ✑ Maximum image upload size of 10 MB ✑ Maximum image metadata size of 1 KB ✑ 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?

    Choose one answer.

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

Paid access to all 72 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.