Tim Urista
Quiz von , erstellt am more than 1 year ago

Praxis Digital Technologies Quiz am AWS Ch7 Exam, erstellt von Tim Urista am 09/03/2018.

502
0
0
Tim Urista
Erstellt von Tim Urista vor mehr als 6 Jahre
Schließen

AWS Ch7 Exam

AWS Ch7 Exam

Frage 1 von 20

1

Which AWS database service is best suited for traditional Online Transaction Processing (OLTP)?

Wähle eine der folgenden:

  • Amazon Redshift

  • Amazon Relational Database Service (Amazon RDS)

  • Amazon Glacier

  • Elastic Database

Erklärung

Frage 2 von 20

1

Which AWS database service is best suited for non-relational databases?

Wähle eine der folgenden:

  • Amazon Redshift

  • Amazon Relational Database Service (Amazon RDS)

  • Amazon Glacier

  • Amazon DynamoDB

Erklärung

Frage 3 von 20

1

You are a solutions architect working for a media company that hosts its website on AWS. Currently, there is a single Amazon Elastic Compute Cloud (Amazon EC2) Instance on AWS with MySQL installed locally to that Amazon EC2 Instance. You have been asked to make the company’s production environment more resilient and to increase performance. You suggest that the company split out the MySQL database onto an Amazon RDS Instance with Multi-AZ enabled. This addresses the company’s increased resiliency requirements. Now you need to suggest how you can increase performance. Ninety-nine percent of the company’s end users are magazine subscribers who will be reading additional articles on the website, so only one percent of end users will need to write data to the site. What should you suggest to increase performance?

Wähle eine der folgenden:

  • Alter the connection string so that if a user is going to write data, it is written to the secondary copy of the Multi-AZ database.

  • Alter the connection string so that if a user is going to write data, it is written to the primary copy of the Multi-AZ database.

  • Recommend that the company use read replicas, and distribute the traffic across multiple read replicas.

  • Migrate the MySQL database to Amazon Redshift to take advantage of columnar storage and maximize performance.

Erklärung

Frage 4 von 20

1

Which AWS Cloud service is best suited for Online Analytics Processing (OLAP)?

Wähle eine der folgenden:

  • Amazon Redshift

  • Amazon Relational Database Service (Amazon RDS)

  • Amazon Glacier

  • Amazon DynamoDB

Erklärung

Frage 5 von 20

1

You have been using Amazon Relational Database Service (Amazon RDS) for the last year to run an important application with automated backups enabled. One of your team members is performing routine maintenance and accidentally drops an important table, causing an outage. How can you recover the missing data while minimizing the duration of the outage?

Wähle eine der folgenden:

  • Perform an undo operation and recover the table.

  • Restore the database from a recent automated DB snapshot.

  • Restore only the dropped table from the DB snapshot.

  • The data cannot be recovered.

Erklärung

Frage 6 von 20

1

Which Amazon Relational Database Service (Amazon RDS) database engines support Multi-AZ?

Wähle eine der folgenden:

  • All of them

  • Microsoft SQL Server, MySQL, and Oracle

  • Oracle, Amazon Aurora, and PostgreSQL

  • MySQL

Erklärung

Frage 7 von 20

1

Which Amazon Relational Database Service (Amazon RDS) database engines support read replicas?

Wähle eine der folgenden:

  • Microsoft SQL Server and Oracle

  • MySQL, MariaDB, PostgreSQL, and Aurora

  • Aurora, Microsoft SQL Server, and Oracle

  • MySQL and PostgreSQL

Erklärung

Frage 8 von 20

1

Your team is building an order processing system that will span multiple Availability Zones. During testing, the team wanted to test how the application will react to a database failover. How can you enable this type of test?

Wähle eine der folgenden:

  • Force a Multi-AZ failover from one Availability Zone to another by rebooting the primary instance using the Amazon RDS console.

  • Terminate the DB instance, and create a new one. Update the connection string.

  • Create a support case asking for a failover.

  • It is not possible to test a failover.

Erklärung

Frage 9 von 20

1

You are a system administrator whose company has moved its production database to AWS. Your company monitors its estate using Amazon CloudWatch, which sends alarms using Amazon Simple Notification Service (Amazon SNS) to your mobile phone. One night, you get an alert that your primary Amazon Relational Database Service (Amazon RDS) Instance has gone down. You have Multi-AZ enabled on this instance. What should you do to ensure the failover happens quickly?

Wähle eine der folgenden:

  • Update your Domain Name System (DNS) to point to the secondary instance’s new IP address, forcing your application to fail over to the secondary instance.

  • Connect to your server using Secure Shell (SSH) and update your connection strings so that your application can communicate to the secondary instance instead of the failed primary instance.

  • Take a snapshot of the secondary instance and create a new instance using this snapshot, then update your connection string to point to the new instance.

  • No action is necessary. Your connection string points to the database endpoint, and AWS automatically updates this endpoint to point to your secondary instance.

Erklärung

Frage 10 von 20

1

You are working for a small organization without a dedicated database administrator on staff. You need to install Microsoft SQL Server Enterprise edition quickly to support an accounting back office application on Amazon Relational Database Service (Amazon RDS). What should you do?

Wähle eine der folgenden:

  • Launch an Amazon RDS DB Instance, and select Microsoft SQL Server Enterprise Edition under the Bring Your Own License (BYOL) model.

  • Provision SQL Server Enterprise Edition using the License Included option from the Amazon RDS Console.

  • SQL Server Enterprise edition is only available via the Command Line Interface (CLI). Install the command-line tools on your laptop, and then provision your new Amazon RDS Instance using the CLI.

  • You cannot use SQL Server Enterprise edition on Amazon RDS. You should install this on to a dedicated Amazon Elastic Compute Cloud (Amazon EC2) Instance.

Erklärung

Frage 11 von 20

1

You are building the database tier for an enterprise application that gets occasional activity throughout the day. Which storage type should you select as your default option?

Wähle eine der folgenden:

  • Magnetic storage

  • General Purpose Solid State Drive (SSD)

  • Provisioned IOPS (SSD)

  • Storage Area Network (SAN)-attached

Erklärung

Frage 12 von 20

1

You are designing an e-commerce web application that will scale to potentially hundreds of thousands of concurrent users. Which database technology is best suited to hold the session state for large numbers of concurrent users?

Wähle eine der folgenden:

  • Relational database using Amazon Relational Database Service (Amazon RDS)

  • NoSQL database table using Amazon DynamoDB

  • Data warehouse using Amazon Redshift

  • Amazon Simple Storage Service (Amazon S3)

Erklärung

Frage 13 von 20

1

Which of the following techniques can you use to help you meet Recovery Point Objective (RPO) and Recovery Time Objective (RTO) requirements? (Choose 3 answers)

Wähle eine oder mehr der folgenden:

  • DB snapshots

  • DB option groups

  • Read replica

  • Multi-AZ deployment

Erklärung

Frage 14 von 20

1

When using Amazon Relational Database Service (Amazon RDS) Multi-AZ, how can you offload read requests from the primary? (Choose 2 answers)

Wähle eine oder mehr der folgenden:

  • Configure the connection string of the clients to connect to the secondary node and perform reads while the primary is used for writes.

  • Amazon RDS automatically sends writes to the primary and sends reads to the secondary.

  • Add a read replica DB instance, and configure the client’s application logic to use a read-replica.

  • Create a caching environment using ElastiCache to cache frequently used data. Update the application logic to read/write from the cache.

Erklärung

Frage 15 von 20

1

You are building a large order processing system and are responsible for securing the database. Which actions will you take to protect the data? (Choose 3 answers)

Wähle eine oder mehr der folgenden:

  • Adjust AWS Identity and Access Management (IAM) permissions for administrators.

  • Configure security groups and network Access Control Lists (ACLs) to limit network access.

  • Configure database users, and grant permissions to database objects.

  • Install anti-virus software on the Amazon RDS DB Instance.

Erklärung

Frage 16 von 20

1

Your team manages a popular website running Amazon Relational Database Service (Amazon RDS) MySQL backend. The Marketing department has just informed you about an upcoming television commercial that will drive thousands of new visitors to the website. How can you prepare your database to handle the load? (Choose 3 answers)

Wähle eine oder mehr der folgenden:

  • Vertically scale the DB Instance by selecting a more powerful instance class.

  • Create read replicas to offload read requests and update your application.

  • Upgrade the storage from Magnetic volumes to General Purpose Solid State Drive (SSD) volumes.

  • Upgrade to Amazon Redshift for faster columnar storage.

Erklärung

Frage 17 von 20

1

You are building a photo management application that maintains metadata on millions of images in an Amazon DynamoDB table. When a photo is retrieved, you want to display the metadata next to the image. Which Amazon DynamoDB operation will you use to retrieve the metadata attributes from the table?

Wähle eine der folgenden:

  • Scan operation

  • Search operation

  • Query operation

  • Find operation

Erklärung

Frage 18 von 20

1

You are creating an Amazon DynamoDB table that will contain messages for a social chat application. This table will have the following attributes: Username (String), Timestamp (Number), Message (String). Which attribute should you use as the partition key? The sort key?

Wähle eine der folgenden:

  • Username, Timestamp

  • Username, Message

  • Timestamp, Message

  • Message, Timestamp

Erklärung

Frage 19 von 20

1

Which statement about Amazon DynamoDB tables is true?

Wähle eine der folgenden:

  • Global secondary indexes can only be created when the table is being created.

  • Local secondary indexes can only be created when the table is being created.

  • You can only have one global secondary index.

  • You can only have one local secondary index.

Erklärung

Frage 20 von 20

1

Which of the following workloads are a good fit for running on Amazon Redshift? (Choose 2 answers)

Wähle eine oder mehr der folgenden:

  • Transactional database supporting a busy e-commerce order processing website

  • Reporting database supporting back-office analytics

  • Data warehouse used to aggregate multiple disparate data sources

  • Manage session state and user profile data for thousands of concurrent users

Erklärung

Vorherige
Nächste