AWS Certified Data Analytics Exam Simulator 1 | (50 questions)

An organization looking to build a real-time operational analytics dashboard for its mobile gaming application is looking at various options to build the dashboard. Which of the following options will provide the right performance characteristics for such an application?

An administrator has a 6 GB file in Amazon S3. The administrator runs a nightly COPY command into a 2-node (32 slices) Amazon Redshift cluster. The administrator wants to prepare the data to optimize performance of the COPY command. What is the best way for the administrator to prepare the data?

A customer wants to build a log analytics solution on AWS with sub-second latency for the search facility. An additional requirement is to build a dashboard for the operations staff. Which of the following technologies would provide a more optimal solution?

A leading telecommunications provider is moving to AWS and has around 50 TB of data in its on-premises Hadoop environment, stored in HDFS, and is using Spark SQL to analyze the data. The customer has asked for a cost-effective and efficient solution to migrate onto AWS quickly, over a 100 mbps (megabits per second) connection, to be able to build a catalog that can be used by other services and analyze the data while managing as few servers as possible. Which solution would be best for this customer?

A leading financial organization is looking to migrate its enterprise data warehouse to AWS. It has 30 TB of data in its data warehouse but is only using 500 GB for reporting and dashboarding while the remaining data is occasionally required for compliance purposes. Which of the following is a more cost-effective solution?

An upcoming gaming startup is collecting gaming logs from its recently launched and hugely popular game. The logs are arriving in JSON format with 500 different attributes for each record. The CMO has requested a dashboard based on six attributes that indicate the revenue generated based on the in-game purchase recommendations as generated by the marketing departments ML team. The data is on S3 in raw JSON format, and a report is being generated using QuickSight on the data available. Currently the report creation takes
an hour, whereas publishing the report is very quick. Furthermore, the IT department has complained about the cost of data scans on S3. They have asked you as a solutions architect to provide a solution that improves performance and optimizes the cost. Which of the following options is most suitable to meet the requirements?

A leading manufacturing organization is running a large Redshift cluster and has complained about slow query response times. What configuration options would you check to identify the root cause of the problem?

Your customer has asked you to help build a data lake on S3. The source system is MySQL, Oracle, and standard CSV files. The data does not have any incremental key. The customer expects you to capture the initial data dump and changes during the data lake build phase. What tools/technologies would you recommend to reduce the overall cost of migration?

A QuickSight dashboard allows you to view the source data but not make any changes to it.

Amazon QuickSight can interpret your charts and tables for you and suggest insights in plain English.

You work for a large ad-tech company which has a set of predefined ads displayed routinely. Due to the popularity of your products, your website is getting popular garnering attention of a diverse set of visitors. You are currently placing dynamic ads based on user click data; however, you have discovered the process time is not keeping up to display the new ads since a user’s stay on the website is short-lived (few seconds) compared to your turnaround
time for delivering a new ad (> 1 minute). You have been asked to evaluate AWS platform services for possible solution to analyze the problem and reduce overall add serving time. Which of the below is your recommendation?

An upcoming startup with self-driving delivery trucks fitted with embedded sensors has requested that you capture data arriving in near real time and track the vehicles’ movement within the city. You will be capturing information from multiple sensors with data that includes the vehicle identification number, make, model, color and its GPS coordinates. Data is sent every 2 seconds and needs to be processed in near real time. Which of the following tools can you use to ingest the data and process it in near real time?

Which of the statements are true about AWS Glue crawlers? (Choose three.)

You have been tasked to work on a new and exciting project where data is coming from smart sensors in the kitchen and is sent to the AWS platform. You have to ensure that you can filter and transform the data being received from the sensors before storing them in DynamoDB. Which of the following AWS service is ideally suited for this scenario?

Your customer has an on-premises Cloudera cluster and is looking to migrate the workloads to the AWS platform. The customer does not want to pay the licensing and any fixed cost. His objective is to build a serverless pipeline in a pay-as-you-go model, ensuring that there is limited impact of migration on existing PySpark code. What would be your recommendation from the following options?

You are working for a ride-hailing company that has recently ventured into food delivery and order processing. The order processing system is built on AWS. The order processing runs into scaling issues particularly during lunch and dinner times when there is an excessive amount of orders received. In the current infrastructure, you have EC2 instances that pick up the orders from the application and EC2 instances in an Auto Scaling group to
process the orders. What architecture would you recommended to ensure that the EC2 processing instances are scaled correctly based on the demand?

Your CIO has recently announced that you will be migrating to AWS to reduce your costs and improve overall agility by benefitting from the breadth and depth of the platform. You have a number of on-premises Oracle databases, which are not only expensive from a licensing perspective but also difficult to scale. You have realized that you can get the same performance from Amazon Aurora at 1/10 of the cost and hence would like to proceed with the migration. You want to create the schema beforehand on the AWS My SQL instance. Which of the following is the easiest approach in getting this done?

Which of the following can be used to move extremely large amounts of data to AWS with up to 100 PB per device?

You have recently moved to AWS but still maintain an on-premises data center. You have already migrated your BI/analytics and DWH workloads to Amazon Redshift and now need to migrate large volumes of data to Redshift to ensure that the weekly reports have fresh data. Which AWS-managed service can be used for this data transfer in a simple, fast, and secure way? (Choose two.)

You need a cost-effective solution to store a large collection of audio, video, and PDF files and provide users with the ability to track and analyze all your data efficiently using your existing business intelligence tools. Which of the following would form the solution required to fulfill the requirements?

You have recently joined an online video streaming company that is looking to stream video files onto Amazon S3. Which of the following services can be used to deliver real-time streaming data to S3 with little to no coding required. Please select one option.

You have recently joined a new gaming company as data architect. The company’s latest game, Chocolate Bites, has been an overwhelming success, resulting in log files. You have been asked to ensure that the log files are made available for access at the cheapest price point. The data will be accessed once every few weeks, but it needs to be readily available when the access request is made. You have realized that S3 is a good option for such a scenario. Which of the following S3 storage option should you use?

You are working with a team of engineers who are using DynamoDB to build the leaderboard for their online multiplayer gaming application. In order to boost performance of reads, a caching layer is being considered. Which of the following is a caching service compatible with your DynamoDB-based application?

Rogers Inc, a video rental company, has set up an online site to make its rentals available to a wider community. It ships the latest videos that are not available on other streaming sites and charges a small percentage in addition to the shipping costs. The company has its website on AWS and is using DynamoDB behind its web application. The database has a main table called videos, which contains two attributes, videoid and the subscriberid, the user
who has rented the video. You are required to select a primary key for this table to optimize access based on the subscriber identifier. Which of the following would you use as a primary key for this table?

Which of the following statements about Amazon DocumentDB are true? (Choose two.)

Amazon DocumentDB can only run in a VPC. Is this statement true or false?

Which of the following is an ideal use case for a graph database like Amazon Neptune?

You are working as an Enterprise Architect for a large fashion retailer based out of Madrid, Spain. The team is looking to build ETL and have large datasets that need to be transformed. Data is arriving from a number of sources and hence de-duplication is also an important factor. Which of the following is the simplest way to process data on AWS?

Which of the following is a distributed data processing option on Apache Hadoop and was the main processing engine until Hadoop 2.0?

You are working as a consultant for a telecommunications company. The data scientists have requested direct access to the data to dive deep into the structure of the data and build models. They have good knowledge of SQL. Which of the following tools will you choose to provide them direct access to the data and reduce the infrastructure and maintenance overhead, while ensuring that access to data on Amazon S3 can be provided?
Which of the following would you recommend to them? (Choose One.)

Which of the following file formats are supported by Amazon Athena? (Choose Three.)

You are working for a large utilities company which has deployed smart meters across its customer base. They are getting near real-time usage data from their customers and ingesting it into Amazon S3 via Amazon Kinesis. They were previously running some large scale transformations using PySpark on their on-premises Hadoop cluster. They have the Pyspark application available and expect no change other than input and output parameters while
running the job. They are looking to reuse their code as much as possible, while looking at the possibility to tune the environment specific to their workload. Which of the following is the right data processing choice for their workload that meets the customers’ requirements at the lowest cost? (Choose One.)

You are looking to run large scale data processing jobs on Amazon EMR running in a stepexecution mode. The data processing jobs can be run at any time with input data available on Amazon S3. Which of the following options will ensure that the data remains available, provides a consistent view, and is encrypted for protection during and after the cluster is terminated after the completion of steps? (Choose One.)

You are working for a large ecommerce retailer who would like to search the web-logs for specific error codes and their reference numbers. You have the ability to choose any tool from the AWS stack. Which of the following tools would you highly recommend for this use-case? (Choose One.

Your customer is all in on AWS and most of the data has high velocity using Amazon S3, Amazon Kinesis Data Streams, Amazon Kinesis Data Fireshose, and Amazon DynamoDB. They are looking to analyze this streaming data and are contemplating choosing a service from the AWS stack. Which of the following services will you recommend to analyze this data? (Choose One.)

You are looking to build a Datawarehouse solution with the ability to flexibly transfer your data between data lake and Datawarehouse. Which of the following is the most cost effective way to meet your requirements? (Choose One.)

Which of the following statements are true about Redshift Leader nodes? (Choose Two.)

Which of the following business analytics services is provided by AWS?

You are looking to understand the correlation between the price vs. quantity sold of various products within your merchandise? Which is the best charting technique to display this?

True or false? Amazon QuickSight Standard edition allows you to provide access to users in your Microsoft Active Directory groups.

You have recently been hired by a large e-commerce organization that is looking to forecast its annual sales in order to optimize the inventory storage. Which of the following services will provide the organization with the simplest forecasting option allowing native integration with data from S3, Redshift, and Athena?

A large manufacturing organization has started capturing data from sensors across the assembly lines. It is looking to perform operational analytics and build real-time dashboards based on specific index patterns and looking at ultra-low latency. The data is available in Elasticsearch. Which of the following visualization techniques is best suited for such an organization?

You are a data architect working for a large multinational organization that allows various suppliers to access inventory details available as files in your S3 bucket. The supplier has an AWS account. How can you provide access to the vendor to this bucket?

You are a data engineer who has been responsible for building a data warehouse using Redshift. You have set up the analysts with Redshift client applications running on an EC2 instance to access Redshift. The analysts have complained about the inability to access the Redshift cluster. Which of the following will you do to ensure proper access to the Redshift cluster?

You are working for a mid-sized tractor manufacturing company, which is providing access to the latest sales analytics stored on Redshift to its sales advisors’ mobile devices. Applications on those mobile devices will need access to Amazon Redshift where data marts are housed for large-scale analytics. Which of the following is the simplest and most secure way to provide access to your Redshift data store from your mobile application?

True or false? Amazon Kinesis Firehose does not offer server-side encryption

Which of the following can be used to restrict user access to Athena operations, including Athena Workgroups?

Consider the following statements about the AAA architecture:
I. Authentication deals with the question “Who is the user?”
II. Authorization addresses the question “What is the user allowed to do?”
III. Accountability answers the question “What did the user do?”
Which of the following is correct?

Does Amazon Cognito support Short Message Service (SMS)–based multi-factor authentication (MFA)?

You are using an existing RADIUS-based multi-factor authentication (MFA) infrastructure. Which AWS service is your best choice?