AWS Certified Database - Specialty

• #21

  A company is deploying a solution in Amazon Aurora by migrating from an on-premises system. The IT department has established an AWS Direct Connect link from the company's data center. The company's Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from being set over the network. The migration appears to be working successfully, and the data can be queried from a desktop machine. Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster. Both Analysts are unable to connect to Aurora. Their user names and passwords have been verified as valid and the Database Specialist can connect to the DB cluster using their accounts. The Database Specialist also verified that the security group configuration allows network from all corporate IP addresses. What should the Database Specialist do to correct the Data Analysts' inability to connect?

  • ARestart the DB cluster to apply the SSL change.
  • BInstruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.
  • CAdd explicit mappings between the Data Analysts' IP addresses and the instance in the security group assigned to the DB cluster.
  • DModify the Data Analysts' local client firewall to allow network traffic to AWS.
  उत्तर दिखाएँ
• #22

  A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries. How should the company identify the source of the problem?

  • AInstall and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
  • BEnable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
  • CUse AWS X-Ray deployed with Amazon RDS to track query system traces.
  • DCreate a support request and work with AWS Support to identify the source of the issue.
  उत्तर दिखाएँ
• #23

  A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second. Which solution meets these requirements?

  • AUse an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap- northeast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cache application data from the replica to generate the dashboards.
  • BUse an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1 Region. Use Amazon QuickSight for displaying dashboard results.
  • CUse an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
  • DUse an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.
  उत्तर दिखाएँ
• #242 चुनें

  A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made. What should the database specialist do to meet these requirements? (Choose two.)

  • ACreate an RDS event subscription to the audit event type.
  • BEnable auditing of CONNECT and QUERY_DML events.
  • CSSH to the DB instance and review the database logs.
  • DPublish the database logs to Amazon CloudWatch Logs.
  • EEnable Enhanced Monitoring on the DB instance.
  उत्तर दिखाएँ
• #25

  An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources. What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?

  • AIncrease the size of the DB instance storage.
  • BChange the underlying EBS storage type to General Purpose SSD (gp2).
  • CDisable EBS optimization on the DB instance.
  • DChange the DB instance to an instance class with a higher maximum bandwidth.
  उत्तर दिखाएँ
• #26

  An ecommerce company migrates an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). After the migration, a database specialist realizes that encryption at rest has not been turned on for the Amazon DocumentDB cluster. What should the database specialist do to enable encryption at rest for the Amazon DocumentDB cluster?

  • ATake a snapshot of the Amazon DocumentDB cluster. Restore the unencrypted snapshot as a new cluster while specifying the encryption option, and provide an AWS Key Management Service (AWS KMS) key.
  • BEnable encryption for the Amazon DocumentDB cluster on the AWS Management Console. Reboot the cluster.
  • CModify the Amazon DocumentDB cluster by using the modify-db-cluster command with the --storage-encrypted parameter set to true.
  • DAdd a new encrypted instance to the Amazon DocumentDB cluster, and then delete an unencrypted instance from the cluster. Repeat until all instances are encrypted.
  उत्तर दिखाएँ
• #27

  A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL. The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop. How should the Database Specialist edit the script to fix this issue?

  • AStop the source instances before stopping their read replicas.
  • BDelete each read replica before stopping its corresponding source instance.
  • CStop the read replicas before stopping their source instances.
  • DUse the AWS CLI to stop each read replica and source instance at the same time.
  उत्तर दिखाएँ
• #28

  A company is building a software as a service application. As part of the new user sign-on workflow, a Python script invokes the CreateTable operation using the Amazon DynamoDB API. After the call returns, the script attempts to call PutItem. Occasionally, the PutItem request fails with a ResourceNotFoundException error, which causes the workflow to fail. The development team has confirmed that the same table name is used in the two API calls. How should a database specialist fix this issue?

  • AAdd an allow statement for the dynamodb:PutItem action in a policy attached to the role used by the application creating the table.
  • BSet the StreamEnabled property of the StreamSpecification parameter to true, then call PutItem.
  • CChange the application to call DescribeTable periodically until the TableStatus is ACTIVE, then call PutItem.
  • DAdd a ConditionExpression parameter in the PutItem request.
  उत्तर दिखाएँ
• #29

  A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database. After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower. The company has narrowed down the cause of this issue to the database and not the application. Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?

  • ACreate an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption. Watch these dashboards during the next slow period.
  • BLaunch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs.
  • CModify the logging database parameter to log all the queries related to locking in the database and then check the logs after the next slow period for this information.
  • DEnable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.
  उत्तर दिखाएँ
• #30

  A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer. The EC2 instances use the security group named sg-application-servers. The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance. The DB instance is deployed in private DB subnet. What is the MOST restrictive configuration for the DB instance security group?

  • AOnly allow incoming traffic from the sg-application-servers security group on port 3306.
  • BOnly allow incoming traffic from the sg-application-servers security group on port 443.
  • COnly allow incoming traffic from the subnet of the application servers on port 3306.
  • DOnly allow incoming traffic from the subnet of the application servers on port 443.
  उत्तर दिखाएँ
• #31

  A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective. Which approach should the Database Specialist take?

  • ADump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp). Run data transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.
  • BOrder an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RDS.
  • CUse the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
  • DUse AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.
  उत्तर दिखाएँ
• #322 चुनें

  A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-of-concept project. A database specialist has configured automated database snapshots. As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created. Which of the following are possible reasons why the snapshot was not created? (Choose two.)

  • AA copy of the RDS automated snapshot for this DB instance is in progress within the same AWS Region.
  • BA copy of the RDS automated snapshot for this DB instance is in progress in a different AWS Region.
  • CThe RDS maintenance window is not configured.
  • DOThe RDS DB instance is in the STORAGE_FULL state.
  • ERDS event notifications have not been enabled.
  उत्तर दिखाएँ
• #33

  A database specialist is building a system that uses a static vendor dataset of postal codes and related territory information that is less than 1 GB in size. The dataset is loaded into the application's cache at start up. The company needs to store this data in a way that provides the lowest cost with a low application startup time. Which approach will meet these requirements?

  • AUse an Amazon RDS DB instance. Shut down the instance once the data has been read.
  • BUse Amazon Aurora Serverless. Allow the service to spin resources up and down, as needed.
  • CUse Amazon DynamoDB in on-demand capacity mode.
  • DUse Amazon S3 and load the data from flat files.
  उत्तर दिखाएँ
• #342 चुनें

  A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. The Database Specialist receives the following error: 'Unable to connect to s3 endpoint. Provided source = s3://mybucket/graphdata/ and region = us-east-1. Please verify your S3 configuration.' Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)

  • ACheck that Amazon S3 has an IAM role granting read access to Neptune.
  • BCheck that an Amazon S3 VPC endpoint exists.
  • CCheck that a Neptune VPC endpoint exists.
  • DCheck that Amazon EC2 has an IAM role granting read access to Amazon S3.
  • ECheck that Neptune has an IAM role granting read access to Amazon S3.
  उत्तर दिखाएँ
• #35

  A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy. Which backup methodology should the database specialist use to MINIMIZE management overhead?

  • AInstall the AWS CLI on an Amazon EC2 instance. Write a CLI command that creates a backup of the DynamoDB table. Create a scheduled job or task that executes the command on a nightly basis.
  • BCreate an AWS Lambda fts?unction that creates a backup of the DynamoDB table. Create an Amazon CloudWatch Events rule that executes the Lambda function on a nightly basis.
  • CCreate a backup plan using AWS Backup, specify a backup frequency of every 24 hours, and give the plan a nightly backup window.
  • DConfigure DynamoDB backup and restore for an on-demand backup frequency of every 24 hours.
  उत्तर दिखाएँ
• #36

  A company recently acquired a new business. A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account. The database specialist needs to minimize the amount of time required to migrate the database. Which solution meets these requirements?

  • ACreate a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.
  • BUse AWS Resource Access Manager to share the source DB instance with the destination account. Create a DB instance in the destination account using the shared resource.
  • CCreate a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.
  • DUse mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.
  उत्तर दिखाएँ
• #37

  A company is using Amazon Aurora PostgreSQL for the backend of its application. The system users are complaining that the responses are slow. A database specialist has determined that the queries to Aurora take longer during peak times. With the Amazon RDS Performance Insights dashboard, the load in the chart for average active sessions is often above the line that denotes maximum CPU usage and the wait state shows that most wait events are IO:XactSync. What should the company do to resolve these performance issues?

  • AAdd an Aurora Replica to scale the read traffic.
  • BScale up the DB instance class.
  • CModify applications to commit transactions in batches.
  • DModify applications to avoid conflicts by taking locks.
  उत्तर दिखाएँ
• #38

  A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting. These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency. System users run ad-hoc queries sporadically throughout the week. Cost is a primary concern for the company, and a solution that does not require significant rework is needed. Which solution meets these requirements?

  • ACreate new Aurora Serverless DB clusters for development and reporting, then migrate to these new DB clusters.
  • BUpgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.
  • CUse existing DB clusters and stop/start the databases on a routine basis using scheduling tools.
  • DChange the DB clusters to the burstable instance family.
  उत्तर दिखाएँ
• #39

  A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete. What is the MOST likely cause of the 5-minute connection outage?

  • AAfter a database crash, Aurora needed to replay the redo log from the last database checkpoint.
  • BThe client-side application is caching the DNS data and its TTL is set too high.
  • CAfter failover, the Aurora DB cluster needs time to warm up before accepting client connections.
  • DThere were no active Aurora Replicas in the Aurora DB cluster.
  उत्तर दिखाएँ
• #40

  A company uses an Amazon Redshift cluster to run its analytical workloads. Corporate policy requires that the company's data be encrypted at rest with customer managed keys. The company's disaster recovery plan requires that backups of the cluster be copied into another AWS Region on a regular basis. How should a database specialist automate the process of backing up the cluster data in compliance with these policies?

  • ACopy the AWS Key Management Service (AWS KMS) customer managed key from the source Region to the destination Region. Set up an AWS Glue job in the source Region to copy the latest snapshot of the Amazon Redshift cluster from the source Region to the destination Region. Use a time-based schedule in AWS Glue to run the job on a daily basis.
  • BCreate a new AWS Key Management Service (AWS KMS) customer managed key in the destination Region. Create a snapshot copy grant in the destination Region specifying the new key. In the source Region, configure cross-Region snapshots for the Amazon Redshift cluster specifying the destination Region, the snapshot copy grant, and retention periods for the snapshot.
  • CCopy the AWS Key Management Service (AWS KMS) customer-managed key from the source Region to the destination Region. Create Amazon S3 buckets in each Region using the keys from their respective Regions. Use Amazon EventBridge (Amazon CloudWatch Events) to schedule an AWS Lambda function in the source Region to copy the latest snapshot to the S3 bucket in that Region. Configure S3 Cross-Region Replication to copy the snapshots to the destination Region, specifying the source and destination KMS key IDs in the replication configuration.
  • DUse the same customer-supplied key materials to create a CMK with the same private key in the destination Region. Configure cross-Region snapshots in the source Region targeting the destination Region. Specify the corresponding CMK in the destination Region to encrypt the snapshot.
  उत्तर दिखाएँ

अपना स्कोर ट्रैक करना, समयबद्ध मॉक परीक्षा देना और AI व्याख्या पाना चाहते हैं? निःशुल्क खाता बनाएँ