Font size
Worksheetspraticioner database
Total questions: 18
Worksheet time: 10mins
A user needs to quickly deploy a non-relational database on AWS. The user does not want to manage the underlying hardware or the database software. Which AWS service can be used to accomplish this?
Amazon RDS
Amazon DynamoDB
Amazon Aurora
Amazon Aurora
Which AWS services can host a Microsoft SQL Server database? (Choose two.)
Amazon EC2
Amazon Relational Database Service (Amazon RDS)
Amazon Aurora
Amazon Redshift
Amazon S3
Which AWS services should be used for read/write of constantly changing data? (Choose two.)
Amazon Glacier
Amazon RDS
AWS Snowball
Amazon Redshift
Amazon EFS
What is one of the advantages of the Amazon Relational Database Service (Amazon RDS)?
It simplifies relational database administration tasks.
It provides 99.99999999999% reliability and durability.
It automatically scales databases for loads.
It enabled users to dynamically adjust CPU and RAM resources.
A customer needs to run a MySQL database that easily scales. Which AWS service should they use?
Amazon Aurora
Amazon Redshift
Amazon DynamoDB
Amazon ElastiCache
Which of the following is a fast and reliable NoSQL database service?
Amazon Redshift
Amazon RDS
Amazon DynamoDB
Amazon S3
Which of the following AWS Cloud services can be used to run a customer-managed relational database?
Amazon EC2
Amazon Route 53
Amazon ElastiCache
Amazon DynamoDB
A company is looking for a scalable data warehouse solution. Which of the following AWS solutions would meet the company’s needs?
Amazon Simple Storage Service (Amazon S3)
Amazon DynamoDB
Amazon Kinesis
Amazon Redshift
What is the benefit of using AWS managed services, such as Amazon ElastiCache and Amazon Relational Database Service (Amazon RDS)?
They require the customer to monitor and replace failing instances.
They have better performance than customer-managed services.
They simplify patching and updating underlying OSs.
They do not require the customer to optimize instance type or size selections.
Which AWS managed service is used to host databases?
AWS Batch
AWS Artifact
AWS Data Pipeline
Amazon RDS
Which service is best for storing common database query results, which helps to alleviate database access load?
Amazon Machine Learning
Amazon SQS
Amazon ElastiCache
Amazon EC2 Instance Store
Which of the following services is a MySQL-compatible database that automatically grows storage as needed?
Amazon Elastic Compute Cloud (Amazon EC2)
Amazon Relational Database Service (Amazon RDS) for MySQL
Amazon Lightsail
Amazon Aurora
Which of the following AWS services can be used to run a self-managed database?
Amazon Route 53
AWS X-Ray
AWS Snowmobile
Amazon Elastic Compute Cloud (Amazon EC2)
Which AWS service can be used to query stored datasets directly from Amazon S3 using standard SQL?
AWS Glue
AWS Data Pipeline
AWS Data PipelineAmazon CloudSearch
Amazon Athena
Which of the following is an AWS database service?
Amazon Redshift
Amazon Elastic Block Store (Amazon EBS)
Amazon S3 Glacier
AWS Snowball
A company wants to migrate a MySQL database to AWS but does not have the budget for Database Administrators to handle routine tasks including provisioning, patching, and performing backups. Which AWS service will support this use case?
Amazon RDS
Amazon DynamoDB
Amazon DocumentDB
Amazon ElastiCache
Which AWS service is a managed NoSQL database?
Amazon Redshift
Amazon DynamoDB
Amazon Aurora
Amazon RDS for MariaDB
A company has deployed several relational databases on Amazon EC2 instances. Every month, the database software vendor releases new security patches that need to be applied to the databases. What is the MOST efficient way to apply the security patches?
Connect to each database instance on a monthly basis, and download and apply the necessary security patches from the vendor.
Enable automatic patching for the instances using the Amazon RDS console.
In AWS Config, configure a rule for the instances and the required patch level.
. Use AWS Systems Manager to automate database patching according to a schedule.
