Browse DBS Questions
Study all 100 questions at your own pace with detailed explanations
Total: 100 questionsPage: 2 of 10
Question 11 of 100
Your company recently purchased five different companies that run different backend databases that include Redshift, MySQL, Hive on EMR and PostgreSQL. You need a single tool that can run queries on all the different platform for your daily ad-hoc analysis. Which tool enables you to do that?
APresto
BQuickSight
CGanglia
DYARN
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 12 of 100
A company has lot of web applications, databases and data warehouse built on Teradata, NoSQL databases, and other types of data stores. They have lot of data assets in terms of logs, documents; excel files, CSV files, PDF documents and others. Web Application has different user workloads at different parts of the day. They are running one of their web application Node.js supported by MongoDB Database. The schema designed is document based. The team wants to migrate the platform on to AWS. Which NoSQL Managed service provides the document management capability?
AAmazon Aurora Database, being a multi-modal database support document models and NoSQL requirements
BAmazon RDS Database, being a multi-modal database support document models and NoSQL requirements
CAmazon DynamoDB Database, being a document database support document models and NoSQL requirements
DAmazon Neptune Database, being a graph database support document models and NoSQL requirements
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 13 of 100
An International company has deployed a multi-tier web application that relies on DynamoDB in a single region. For regulatory reasons they need disaster recovery capability in a separate region with a Recovery Time Objective of 2 hours and a Recovery Point Objective of 24 hours. They should synchronize their data on a regular basis and be able to provision the web application rapidly using CloudFormation. The objective is to minimize changes to the existing web application, control the throughput of DynamoDB used for the synchronization of data and synchronize only the modified elements. Which design would you choose to meet these requirements?
AUse AWS Data Pipeline to schedule a DynamoDB cross region copy once a day. Create a 'Lastupdated' attribute in your DynamoDB table that would represent the timestamp of the last update and use it as a filter
BUse EMR and write a custom script to retrieve data from DynamoDB in the current region using a SCAN operation and push it to DynamoDB in the second region.
CUse AWS Data Pipeline to schedule an export of the DynamoDB table to S3 in the current region once a day then schedule another task immediately after it that will import data from S3 to DynamoDB in the other region.
DSend each update into an SQS queue in the second region; use an auto-scaling group behind the SQS queue to replay the write in the second region.
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 14 of 100
You work for a start-up that tracks commercial delivery trucks via GPS. You receive coordinates that are transmitted from each delivery truck once every 6 seconds. You need to process these coordinates in real-time from multiple sources and load them into Elasticsearch without significant technical overhead to maintain. Which tool should you use to digest the data?
AAmazon Kinesis Firehose
BAmazon EMR
CAWS Data Pipeline
DAmazon SQS
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 15 of 100
A solutions architect works for a company that has a data lake based on a central Amazon S3 bucket. The data contains sensitive information. The architect must be able to specify exactly which files each user can access. Users access the platform through a SAML federation Single Sign On platform. The architect needs to build a solution that allows fine grained access control, traceability of access to the objects, and usage of the standard tools (AWS Console, AWS CLI) to access the data. Which solution should the architect build?
AUse Amazon S3 Server-Side Encryption with AWS KMS-Managed Keys for storing data. Use AWS KMS Grants to allow access to specific elements of the platform. Use AWS CloudTrail for auditing.
BUse Amazon S3 Server-Side Encryption with Amazon S3-Managed Keys. Set Amazon S3 ACLs to allow access to specific elements of the platform. Use Amazon S3 to access logs for auditing.
CUse Amazon S3 Client-Side Encryption with Client-Side Master Key. Set Amazon S3 ACLs to allow access to specific elements of the platform. Use Amazon S3 to access logs for auditing.
DUse Amazon S3 Client-Side Encryption with AWS KMS-Managed Keys for storing data. Use AWS KMS Grants to allow access to specific elements of the platform. Use AWS CloudTrail for auditing.
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 16 of 100
A mobile application collects data that must be stored in multiple Availability Zones within five minutes of being captured in the app. What architecture securely meets these requirements?
AThe mobile app should write to an S3 bucket that allows anonymous PutObject calls.
BThe mobile app should authenticate with an Amazon Cognito identity that is authorized to write to an Amazon Kinesis Firehose with an Amazon S3 destination.
CThe mobile app should authenticate with an embedded IAM access key that is authorized to write to an Amazon Kinesis Firehose with an Amazon S3 destination.
DThe mobile app should call a REST-based service that stores data on Amazon EBS. Deploy the service on multiple EC2 instances across two Availability Zones.
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 17 of 100
You are using QuickSight to identify demand trends over multiple months for your top five product lines. Which type of visualization do you choose?
AScatter Plot
BPie Chart
CPivot Table
DLine Chart
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 18 of 100
A company is storing data on Amazon Simple Storage Service (S3). The company’s security policy mandates that data be encrypted at rest. Which of the following methods can achieve this? Choose 3 answers
AUse Amazon S3 server-side encryption with AWS Key Management Service managed keys.
BUse Amazon S3 server-side encryption with customer-provided keys
CUse Amazon S3 server-side encryption with EC2 key pair.
DUse Amazon S3 bucket policies to restrict access to the data at rest.
EEncrypt the data on the client-side before ingesting to Amazon S3 using their own master key
FUse SSL to encrypt the data while in transit to Amazon S3.
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 19 of 100
A company that provides economics data dashboards needs to be able to develop software to display rich, interactive, data-driven graphics that run in web browsers and leverages the full stack of web standards (HTML, SVG, and CSS). Which technology provides the most appropriate support for this requirements?
AD3.js
BIPython/Jupyter
CR Studio
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation
Question 20 of 100
An enterprise customer is migrating to Redshift and is considering using dense storage nodes in its Redshift cluster. The customer wants to migrate 50 TB of data. The customer’s query patterns involve performing many joins with thousands of rows. The customer needs to know how many nodes are needed in its target Redshift cluster. The customer has a limited budget and needs to avoid performing tests unless absolutely needed. Which approach should this customer use?
AStart with many small nodes.
BStart with fewer large nodes.
CHave two separate clusters with a mix of a small and large nodes.
DInsist on performing multiple tests to determine the optimal configuration.
💡 Try to answer first, then click "Show Answer" to see the correct answer and explanation