GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

parj kabal

Eric schleicher 17 questions Updated 10 Nov 2021

Take the quiz

Questions in this quiz (17)

  1. 1You have deployed an RDS MySQL database to a Linux based EC2 instances backed by EBS. You need to set up a RAID configuration that would provide data durability. Fault tolerance is more important than I/O performance. Which RAID configuration can meet this requirement?
    1. ARAID 6
    2. BRAID 5
    3. CRAID 1
    4. DRAID 0
  2. 2A solutions architect is designing a configuration for an application backed by an RDS database. The database is expected to receive heavy read traffic with periodic write traffic. The design will include an Elasticache cluster that needs to support complex data types, and the cluster needs to support scaling. Which option will be used to implement this solution?
    1. ARedis (cluster mode disabled)
    2. BDAX Clusters
    3. CRedis (cluster mode enabled)
    4. DMemcached
  3. 3You have configured a DynamoDB table to store customer information for a pharmacy application. The data can be purged after 30 days and you have set up TTL to do so. But there is an additional requirement to further process these deleted records. Which solution can meet this additional requirement?
    1. AEnable continuous backups on the table with point in time recovery.
    2. BEnable DynamoDB Streams on the table to trigger a lambda function and process the streams records of expired items.
    3. CCreate a Lambda function to process the deleted records as needed. Set the Lambda function to be triggered by the TTL expiry event.
    4. DCreate a CloudWatch Event triggered by the TTL event to stream the deleted records to SQS for further processing.
  4. 4You have configured an RDS MySQL database for your company’s customer-facing application. Next, you have changed the time_zone parameter in the DB Parameter Group to the local time, but several users are still seeing the original UTC time. What steps can be taken to resolve the issue?
    1. ARestore the database from a local snapshot.
    2. BHave the users close the connection and open a new connection.
    3. CReboot the database instance.
    4. DYou need to also change the time_offset parameter.
  5. 5A financial company uses several RDS MySQL databases. An initial configuration of the database needs to be recreated in different locations throughout the company. It has been decided to create and distribute encrypted snapshots of the database. Which statement is true if you want to have another AWS account copy an encrypted DB snapshot shared from your account?
    1. ASnapshots can be shared between different accounts, provided those accounts are linked in AWS Organizations
    2. BThe account that you share your snapshot with must have database credentials on the originating database.
    3. CYou can only share snapshots within the same account.
    4. DThe account that you share your snapshot with must have access to the KMS key that encrypted the snapshot.
  6. 6You have configured a new RDS MySQL database for a small insurance company that is moving to the AWS Cloud. But your attempts to connect to the database are failing. What could be the most likely cause?
    1. AThe inbound rules on the instance Security Group are not configured properly.
    2. BThe database instance is in a private subnet, so there needs to be a NAT Gateway.
    3. CThe outbound rules on the instance Security Group are not configured properly.
    4. DYou are not connecting from the root account.
  7. 7A social networking application supports the transfer of gift vouchers between users. When a user reaches a certain number of followers on the application, that user earns a gift voucher that can be redeemed or transferred to another user. The database administration team wants to ensure that this transfer is captured in the database such that the records for both users are either written successfully with the new gift vouchers or the status quo is maintained.

    As a Database Specialist, which of the following solutions would you recommend as the best-fit options to meet the given requirements? (Select two)
    1. AUse the DynamoDB transactional read and write APIs on the table items as a single, all-or-nothing operation
    2. BComplete both operations on RDS MySQL in a single transaction block
    3. CPerform DynamoDB read and write operations with ConsistentRead parameter set to true
    4. DComplete both operations on Amazon RedShift in a single transaction block
    5. EUse the Amazon Athena transactional read and write APIs on the table items as a single, all-or-nothing operation
  8. 8A Silicon Valley based unicorn startup is moving its IT operations from an on-premises data center to AWS Cloud. The database team at the startup is evaluating the Multi-AZ and Read Replica capabilities of RDS MySQL vs Aurora MySQL before they implement the solution in their production environment. The startup has hired you as an AWS Certified Database Specialist to provide a detailed report on this technical requirement.

    Which of the following would you identify as correct regarding the given use-case? (Select three)
    1. AMulti-AZ deployments for RDS MySQL follow synchronous replication whereas Multi-AZ deployments for Aurora MySQL follow asynchronous replication
    2. BRead Replicas can be manually promoted to a standalone database instance for RDS MySQL whereas Read Replicas for Aurora MySQL can be promoted to the primary instance
    3. CThe primary and standby DB instances are upgraded at the same time for RDS MySQL Multi-AZ. All instances are upgraded at the same time for Aurora MySQL
    4. DDatabase engine version upgrades happen on primary for Aurora MySQL whereas all instances are updated together for RDS MySQL
    5. ERead Replicas can be manually promoted to a standalone database instance for Aurora MySQL whereas Read Replicas for RDS MySQL can be promoted to the primary instance
    6. FMulti-AZ deployments for Aurora MySQL follow synchronous replication whereas Multi-AZ deployments for RDS MySQL follow asynchronous replication
  9. 9A multi-national retail company is planning to move their on-premises database to Amazon RDS. As an AWS Certified Database Specialist, you have been roped in to understand and weigh-in on the replication features of RDS.

    Which of the following statements would you identify as correct for the given context? (Select two)
    1. AAmazon RDS for MySQL allows you to create a second-tier read replica from an existing first-tier Read Replica
    2. BYou can configure RDS source DB instance as a Multi-AZ deployment to avoid I/O suspension that occurs when a Read Replica is initiated
    3. CAmazon RDS for PostgreSQL allows you to create a second-tier Read Replica from an existing first-tier Read Replica
    4. DWhen running an RDS DB instance as a Multi-AZ deployment, the standby DB can be used for read or write operations
    5. EIf you delete an Amazon RDS for MySQL DB Instance that has Read Replicas, all Read Replicas will be promoted to standalone DB Instances
  10. 10A company's compliance requirements mandate regular backup of all their production databases.

    What should a Database Specialist consider when creating backups for DynamoDB tables? (Select three)
    1. ADynamoDB backup will preserve the Provisioned Read and Write capacities, Local Secondary Indexes (LSIs) and billing mode of the backed-up table
    2. BAuto-scaling policies, AWS Identity and Access Management (IAM) policies have to be manually setup for the restored table
    3. CAll API and console actions of DynamoDB backup and restore are captured and recorded in AWS CloudTrail
    4. DWhen you restore a table, you only use the provisioned Read Capacity Units (RCUs) of the table and Write Capacity Units (WCUs) remain untouched
    5. EIAM policies as well as encryption settings have to be manually setup for the restored table
    6. FTo delete backups marked with a 'Backup type' of 'AWS' using the DynamoDB console, you need to have full access permissions on DynamoDB resources -

Information

Description
Quiz on parj kabal, created by Eric schleicher on 09/11/2021.
Language
English
Views
1
History
Created on 9 Nov 2021 · updated on 10 Nov 2021
Tags
sql
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?