AWS Databases

A company is running an on-premise database management system (DBMS) that has MySQL and PostgreSQL databases that are used for complex query transactions. The company wants to migrate the DBMS to AWS. Which AWS service is compatible to the contents of the DBMS to achieve this migration? (Choose TWO)

A Systems Administrator wants a quick way to import MySQL database to AWS RDS MySQL. Which AWS tools can do this? (Choose TWO)

A Systems Administrator wants to quickly import PostgreSQL database to AWS RDS PostgreSQL. Which AWS tool can do this?

Which of the following TWO are Amazon RDS database engines?

A company is looking for a cost-effective, highly available and scalable relational database service with high throughput and is compatible to MySQL, Oracle and Microsoft SQL Server. Which AWS service can do this?

A Systems Administrator noticed that her Amazon RDS MySQL queries are very slow and this has affected the performance of her queries badly. How can she find out the problems causing her queries to be slow and improve on the performance? (Choose TWO)

You are billed for your Amazon RDS based on:

Amazon RDS provides different methods for backing up and restoring your DB instances. Which of the following TWO methods can do this?

Which of the following events can make the primary Amazon RDS DB instance to failover to the standby DB instance?

A Systems Administrator is experiencing performance issues because there are thousands of read requests on the master DB instance of her Amazon RDS MySQL database. What can she do to improve the read performance?

Amazon RDS supports Cross-Region Read Replicas for the following TWO database engines

A Systems Administrator is experiencing that his Amazon RDS DB Instance query performance is getting very slow. What can he do to improve the performance of the DB instance query?

Amazon RDS Enhanced Monitoring captures which of the following RDS instance system level metrics?

A Systems Administrator is using Enhanced Monitoring for Amazon RDS to get deeper visibility into the health of his RDS instances. But he still wants to get an even deeper level of diagnostics and visualization capabilities for his DB instance load. Which AWS service can do this?

A Solutions Architect wants to horizontally partition and scale-out his Amazon RDS MySQL database. He does not want each DB instance to have knowledge of each partition. Which AWS database technique he can use?

Amazon RDS supports which types of DB Instance classes?

A Solutions Architect just created a master and standby Amazon RDS DB instances in different availability zones. What will happen to the master DB instance if it has connection or network problems?

A Solutions Architect just created a read replica of MySQL database from the primary Amazon RDS MySQL DB instance in a different availability zone. What will happen if the primary RDS MySQL database has problems?

Amazon RDS read replicas offer (Choose TWO):

Amazon RDS read replicas are used to (Choose TWO):

The following is true of Amazon RDS DB Instances (Choose TWO):

The following is true of Amazon RDS Master and Standby databases(Choose THREE):

Each Amazon RDS DB Instance Class consists of (Choose THREE):

Amazon RDS is good for (Choose TWO):

A Solutions Architect is asked to design a database system that will have key-value parameters and is highly scalable with a performance of single digit millisecond to handle millions of mobile phone calls. Which AWS service can do this?

A Solutions Architect is looking for a NoSQL database to manage mobile and web applications. The database must be highly scalable and high throughput to handle millions of requests with consistent performance in single digit millisecond. Which AWS service can do this?

A Solutions Architect is looking for a document database to manage an online game application. The game has a leader board that displays the first 8 players that are leading in different countries at the same time. Millions of users login all the time to play the game from different locations around the world. The database needs to hold sessions of games and process results in single digit millisecond. Which AWS service can do this?

Amazon DynamoDB supports (Choose TWO):

Strongly consistent data reading in Amazon DynamoDB means that:

Eventually consistent data reading in Amazon DynamoDB means that:

Amazon DynamoDB supports (Choose TWO):

The types of primary keys supported by Amazon DynamoDB are (Choose TWO):

Example of a primary partition key in DynamoDB is? (Choose TWO)

Example of a primary partition-sort key in DynamoDB is?

DynamoDB supports TWO types of secondary indexes (Choose TWO):

The following statements are true for Amazon DynamoDB Global Secondary Index (Choose TWO):

The following statements are true for Amazon DynamoDB Local Secondary Index (Choose TWO):

You can use the following operations to read data in a DynamoDB table (Choose THREE):

To read just a portion of data in a DynamoDB table, use the following operations (Choose TWO):

To read the entire data in the table at once in a DynamoDB table, use the following operation:

A Systems Administrator wants to read the entire data in Amazon DynamoDB table, but wants to display only a portion of the data. Which AWS operations will enable the Systems Administrator to achieve this? (Choose TWO).

A DynamoDB Scan operation reads the entire table and displays all the data. How can you control the output of a Scan operation to display just a portion of the data in the table?.

A Solutions Architect is designing on-premise web and mobile apps that use unstructured nonrelational database formats and require microseconds performance using in-memory cache for performance. The apps also require read-heavy or busty workloads (sudden huge increase in workloads) and increased throughput. The Solutions Architecture decided to implement this design in AWS using an AWS managed service. Which AWS service can meet these requirements? (Choose TWO).

Amazon DynamoDB supports these features (Choose THREE).

Amazon DynamoDB supports these features (Choose TWO).

A Solutions Architect has been managing an on-premise enterprise data warehouse. The data warehouse processes data on the company’s business intelligence (BI) system, but it is getting too slow in performance and too costly to maintain. The solutions Architect wants to move the system to AWS, but needs a performance that is 10 times any other cloud data warehouse. Which AWS service can do this? (Choose TWO).

A company is using Amazon Redshift for its enterprise data warehouse (EDW) and business intelligence (BI) applications. It also stores exabytes of data in an unstructured format in S3 and needs a tool that can quickly query this huge unstructured data without using any ETL (Extract, Transform and Load) tool. Which AWS query service will help this company with this requirement?

A company is looking for an AWS data warehouse service that is compatible with relational database formats and can do Online Analytical Processing (OLAP) tasks. Which AWS service meet this requirement?

Amazon Redshift supports the following use cases:

Which AWS relational database service can combine the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases and is faster than MySQL and PostSQL database engines to perform complex online transactional processing (OLTP) tasks?

Which AWS relational database service is both compatible to MySQL and PostgreSQL databases and is 5 times better than MySQL database and 3 times better than PostgreSQL database in terms of speed and performance?

Amazon Aurora supports the following features:

An Amazon Aurora cost-effective option for infrequent, intermittent or unpredictable workloads that is offered on-demand to perform autoscaling configuration for MySQL-compatible and PostgreSQL-compatible editions of Amazon Aurora and enable DB cluster to automatically starts up, shuts down and scales capacity up or down based on your application’s needs is know as:

A Systems Analyst is working on Amazon Aurora but she wants to be able to push down and distribute the computational load of a single query across thousands of CPUs in Aurora’s storage layer. She also wants to perform analytical workloads requiring fresh data and good query performance, even on large tables. Which Amazon Aurora feature can do this?

Amazon Aurora supports the following features:

Which AWS service will help you to manage data streams in real-time to process rapidly moving data and continuously process the data in real-time metrics and analytics to derive more complex data streams for further processing?

Which AWS service is fast, scalable, highly available and fully managed NoSQL document database service that supports MongoDB workloads?

Which AWS service is a fast, reliable, fully-managed graph database service that makes it easy to build and run applications that work with highly connected datasets?

A Systems Analyst is looking for a language for APIs that will help her to query and manipulate data easily through an intuitive and flexible syntax and can access many sources in a single request. In addition, it should work with a service that works at enterprise level and is fully managed service with real-time data synchronization and offline programming features. Which AWS services can do this? (Choose TWO)