AWS Certified Database - Specialty

• #41

  A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster. What is the quickest way for the company to gather data on the migration compatibility?

  • APerform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing row counts from source and target tables.
  • BRun AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing the row counts from source and target tables.
  • CRun native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate the migration compatibility.
  • DRun the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster. Create a migration assessment report to evaluate the migration compatibility.
  Tampilkan jawaban
• #42

  A Database Specialist is working with a company to launch a new website built on Amazon Aurora with several Aurora Replicas. This new website will replace an on-premises website connected to a legacy relational database. Due to stability issues in the legacy database, the company would like to test the resiliency of Aurora. Which action can the Database Specialist take to test the resiliency of the Aurora DB cluster?

  • AStop the DB cluster and analyze how the website responds.
  • BUse Aurora fault injection to crash the master DB instance.
  • CRemove the DB cluster endpoint to simulate a master DB instance failure.
  • DUse Aurora Backtrack to crash the DB cluster.
  Tampilkan jawaban
• #43

  A company uses Amazon DynamoDB as the data store for its ecommerce website. The website receives little to no traffic at night, and the majority of the traffic occurs during the day. The traffic growth during peak hours is gradual and predictable on a daily basis, but it can be orders of magnitude higher than during offpeak hours. The company initially provisioned capacity based on its average volume during the day without accounting for the variability in traffic patterns. However, the website is experiencing a significant amount of throttling during peak hours. The company wants to reduce the amount of throttling while minimizing costs. What should a database specialist do to meet these requirements?

  • AUse reserved capacity. Set it to the capacity levels required for peak daytime throughput.
  • BUse provisioned capacity. Set it to the capacity levels required for peak daytime throughput.
  • CUse provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
  • DUse on-demand capacity.
  Tampilkan jawaban
• #44

  A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost- effective and able to handle unpredictable application traffic. What should a Database Specialist recommend for this user?

  • ACreate an Amazon DynamoDB table with provisioned capacity mode.
  • BCreate an Amazon DocumentDB cluster.
  • CCreate an Amazon DynamoDB table with on-demand capacity mode.
  • DCreate an Amazon Aurora Serverless DB cluster.
  Tampilkan jawaban
• #45

  A company is using Amazon with Aurora Replicas for read-only workload scaling. A Database Specialist needs to split up two read-only applications so each application always connects to a dedicated replica. The Database Specialist wants to implement load balancing and high availability for the read-only applications. Which solution meets these requirements?

  • AUse a specific instance endpoint for each replica and add the instance endpoint to each read-only application connection string.
  • BUse reader endpoints for both the read-only workload applications.
  • CUse a reader endpoint for one read-only application and use an instance endpoint for the other read-only application.
  • DUse custom endpoints for the two read-only applications.
  Tampilkan jawaban
• #46Pilih 3

  An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future. Which settings will meet this requirement? (Choose three.)

  • ASet DeletionProtection to True.
  • BSet MultiAZ to True.
  • CSet TerminationProtection to True.
  • DSet DeleteAutomatedBackups to False.
  • ESet DeletionPolicy to Delete.
  • FSet DeletionPolicy to Retain.
  Tampilkan jawaban
• #47

  A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region. Where should the AWS DMS replication instance be placed for the MOST optimal performance?

  • AIn the same Region and VPC of the source DB instance.
  • BIn the same Region and VPC as the target DB instance.
  • CIn the same VPC and Availability Zone as the target DB instance.
  • DIn the same VPC and Availability Zone as the source DB instance.
  Tampilkan jawaban
• #48

  A company is moving its fraud detection application from on premises to the AWS Cloud and is using Amazon Neptune for data storage. The company has set up a 1 Gbps AWS Direct Connect connection to migrate 25 TB of fraud detection data from the on-premises data center to a Neptune DB instance. The company already has an Amazon S3 bucket and an S3 VPC endpoint, and 80% of the company’s network bandwidth is available. How should the company perform this data load?

  • AUse an AWS SDK with a multipart upload to transfer the data from on premises to the S3 bucket. Use the Copy command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
  • BUse AWS Database Migration Service (AWS DMS) to transfer the data from on premises to the S3 bucket. Use the Loader command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
  • CUse AWS DataSync to transfer the data from on premises to the S3 bucket. Use the Loader command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
  • DUse the AWS CLI to transfer the data from on premises to the S3 bucket. Use the Copy command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
  Tampilkan jawaban
• #49

  A company uses the Amazon DynamoDB table contractDB in us-east-1 for its contract system with the following schema: orderID (primary key) timestamp (sort key) contract (map) createdBy (string) customerEmail (string) After a problem in production, the operations team has asked a database specialist to provide an IAM policy to read items from the database to debug the application. In addition, the developer is not allowed to access the value of the customerEmail field to stay compliant. Which IAM policy should the database specialist use to achieve these requirements?

  • AOption A.
  • BOption B.
  • COption C.
  • DOption D.
  Tampilkan jawaban
• #50

  A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level. How can the Database Specialist meet these requirements?

  • AUse AWS IAM database authentication and restrict access to the tables using an IAM policy.
  • BConfigure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.
  • CExecute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
  • DDefine access privileges to the tables containing sensitive data in the pg_hba.conf file.
  Tampilkan jawaban
• #51

  A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window. What is the MOST cost-effective action that should be taken to avoid downtime?

  • AMigrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB.
  • BEnable cross-Region read replicas and direct read traffic to then when Amazon RDS is down.
  • CEnable a read replicas and direct read traffic to it when Amazon RDS is down.
  • DEnable an Amazon RDS for MySQL Multi-AZ configuration.
  Tampilkan jawaban
• #52

  A startup company is building a new application to allow users to visualize their on-premises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. The application should be able to identify: The networks and routes affected if a particular component fails. The networks that have redundant routes between them. The networks that do not have redundant routes between them. The fastest path between two networks. Which database engine meets these requirements?

  • AAmazon Aurora MySQL.
  • BAmazon Neptune.
  • CAmazon ElastiCache for Redis.
  • DAmazon DynamoDB.
  Tampilkan jawaban
• #53

  An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora. Data that is read by the dashboard should be available within 100 milliseconds of an update. The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster. Which solution meets these requirements?

  • ATurn on the serverless option in the DB cluster so it can automatically scale based on demand.
  • BProvision a clone of the existing DB cluster for the new Application team.
  • CCreate a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
  • DAdd an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.
  Tampilkan jawaban
• #54

  A company’s ecommerce website uses Amazon DynamoDB for purchase orders. Each order is made up of a Customer ID and an Order ID. The DynamoDB table uses the Customer ID as the partition key and the Order ID as the sort key. To meet a new requirement, the company also wants the ability to query the table by using a third attribute named Invoice ID. Queries using the Invoice ID must be strongly consistent. A database specialist must provide this capability with optimal performance and minimal overhead. What should the database administrator do to meet these requirements?

  • AAdd a global secondary index on Invoice ID to the existing table.
  • BAdd a local secondary index on Invoice ID to the existing table.
  • CRecreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.
  • DUse the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.
  Tampilkan jawaban
• #55

  A gaming company has recently acquired a successful iOS game, which is particularly popular during the holiday season. The company has decided to add a leaderboard to the game that uses Amazon DynamoDB. The application load is expected to ramp up over the holiday season. Which solution will meet these requirements at the lowest cost?

  • ADynamoDB Streams.
  • BDynamoDB with DynamoDB Accelerator.
  • CDynamoDB with on-demand capacity mode.
  • DDynamoDB with provisioned capacity mode with Auto Scaling.
  Tampilkan jawaban
• #56

  A small startup company is looking to migrate a 4 TB on-premises MySQL database to AWS using an Amazon RDS for MySQL DB instance. Which strategy would allow for a successful migration with the LEAST amount of downtime?

  • ADeploy a new RDS for MySQL DB instance and configure it for access from the on-premises data center. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance utilizing the MySQL utilities running on an Amazon EC2 instance. Immediately point the application to the DB instance.
  • BDeploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into the EC2 instance and restore it into the EC2 MySQL instance. Use AWS DMS to migrate data into a new RDS for MySQL DB instance. Point the application to the DB instance.
  • CDeploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into an Amazon S3 bucket and import the snapshot into a new RDS for MySQL DB instance using the MySQL utilities running on an EC2 instance. Point the application to the DB instance.
  • DDeploy a new RDS for MySQL DB instance and configure it for access from the on-premises data center. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance using the MySQL utilities running on an Amazon EC2 instance. Establish replication into the new DB instance using MySQL replication. Stop application access to the on-premises MySQL server and let the remaining transactions replicate over. Point the application to the DB instance.
  Tampilkan jawaban
• #57

  A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time- consuming, so it is not an option. How should the Database Specialist satisfy this new requirement?

  • ACreate a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted snapshot. Restore the encrypted snapshot copy.
  • BModify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.
  • CRestore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
  • DCreate an encrypted read replica of the RDS DB instance. Promote it the master.
  Tampilkan jawaban
• #58Pilih 2

  A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in CPU utilization was not determined using the standard metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A Database Specialist needs to determine what caused the CPU spike. Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)

  • AEnable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
  • BEnable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
  • CImplement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
  • DUse Amazon QuickSight to view the SQL statement being run.
  • EEnable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQL statements, hosts, or users.
  Tampilkan jawaban
• #59

  A company wants to automate the creation of secure test databases with random credentials to be stored safely for later use. The credentials should have sufficient information about each test database to initiate a connection and perform automated credential rotations. The credentials should not be logged or stored anywhere in an unencrypted form. Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation template?

  • ACreate the database with the MasterUserName and MasterUserPassword properties set to the default values. Then, create the secret with the user name and password set to the same default values. Add a Secret Target Attachment resource with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database. Finally, update the secret's password value with a randomly generated string set by the GenerateSecretString property.
  • BAdd a Mapping property from the database Amazon Resource Name (ARN) to the secret ARN. Then, create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add the database with the MasterUserName and MasterUserPassword properties set to the user name of the secret.
  • CAdd a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property. Then, define the database user name in the SecureStringTemplate template. Create a resource for the database and reference the secret string for the MasterUserName and MasterUserPassword properties. Then, add a resource of type AWS::SecretsManagerSecretTargetAttachment with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database.
  • DCreate the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add an SecretTargetAttachment resource with the SecretId property set to the Amazon Resource Name (ARN) of the secret and the TargetId property set to a parameter value matching the desired database ARN. Then, create a database with the MasterUserName and MasterUserPassword properties set to the previously created values in the secret.
  Tampilkan jawaban
• #60Pilih 3

  A manufacturing company's website uses an Amazon Aurora PostgreSQL DB cluster. Which configurations will result in the LEAST application downtime during a failover? (Choose three.)

  • AUse the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
  • BCreate an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
  • CEdit and enable Aurora DB cluster cache management in parameter groups.
  • DSet TCP keepalive parameters to a high value.
  • ESet JDBC connection string timeout variables to a low value.
  • FSet Java DNS caching timeouts to a high value.
  Tampilkan jawaban

Ingin melacak skor, mengikuti ujian simulasi berwaktu, dan mendapat penjelasan AI? Buat akun gratis