DBS-C01 Question Bank · Latest 50 Questions Free Preview (Page 2/5)
Questions 11–20 of the latest 50 DBS-C01 questions (5 pages total), with answers and explanations, no login required. Practice all 376 questions online.
Question 11 · No. 337 · Single choice
A company wants to implement a design that includes multiple AWS Regions to support disaster recovery for its application. The company currently has a static website that is hosted on Amazon S3 and Amazon CloudFront. The application connects to an existing Amazon DynamoDB database in the us-east-1 Region. The DynamoDB table was recently created and was initialized with a large amount of company data. The company wants to replicate the database in real time to the us-west-2 Region. A database specialist needs to perform the replication, which must include all existing table data and any new data that is added in the future, in an automated way. Which solution will meet these requirements?
- A. Enable DynamoDB streams. Configure streams for new and old images. Create a global table replica in us-west-2. Monitor the progress of the replication until the status changes to Active.
- B. Create global table replica in us-west-2. Monitor the progress of the replication until the status changes to Active.
- C. Enable DynamoDB streams. Configure streams for new and old images. Create a global table replica in us-west-2. Copy all existing data from us-east-1 to us-west-2 by using an export and batch import.
- D. Create a global table replica in us-west-2. Copy all existing data from us-east-1 to us-west-2 by using an export and batch import.
Answer: A
Explanation: Answer is A. Enabling DynamoDB streams helps capture table activity, and the information about insert, update, and delete actions is written to the stream whenever an item in the table is modified, which is aligned with the company's need to include all existing table data and newly added data in the replication. Configuring streams for new and old images ensures that both the before and after image of an item is stored whenever it is modified. 'Creating a global table replica in us-west-2' supports the requirement for disaster recovery as the data is now distributed across regions and the application is available even if one region fails. 'Monitoring the progress of the replication until the status changes to Active' ensures that the replica is ready for use before it is needed.
Question 12 · No. 338 · Multiple choice
A company wants to use AWS Organizations to create isolated accounts for different teams and functionality. The company’s database administrator needs to copy a DB instance from the main account in the us-east-1 Region to a new test account in the us-west-2 Region. The database administrator has already taken a snapshot of the encrypted Amazon RDS for PostgreSQL source DB instance in the main account. Which combination of steps must the database administrator take to copy the snapshot to the new account? (Choose three.)
- A. Create a new AWS Key Management Service (AWS KMS) customer managed key in the main account in us-east-1. Replicate the key ID and key material to the test account in us-west-2.
- B. Create a new AWS Key Management Service (AWS KMS) customer managed key in the main account in us-east-1. Copy the key to the test account in us-west-2.
- C. Copy the snapshot of the source DB instance to us-west-2 by using the AWS Key Management Service (AWS KMS) customer managed key. Enable encryption on the new snapshot. Share the snapshot with the test account.
- D. Copy the snapshot of the source DB instance to the test account in us-east-1. Switch to the test account and share the snapshot with us-west-2.
- E. In the test account, copy the shared snapshot to create a final snapshot. Use the final snapshot to create a new RDS for PostgreSQL DB instance.
- F. In the test account, copy the shared snapshot by using the copied AWS Key Management Service (AWS KMS) key to create a final encrypted snapshot. Use the final snapshot to create a new RDS for PostgreSQL DB instance.
Answer: A, C, F
Question 13 · No. 339 · Single choice
A database specialist needs to enable IAM authentication on an existing Amazon Aurora PostgreSQL DB cluster. The database specialist already has modified the DB cluster settings, has created IAM and database credentials, and has distributed the credentials to the appropriate users. What should the database specialist do next to establish the credentials for the users to use to log in to the DB cluster?
- A. Add the users' IAM credentials to the Aurora cluster parameter group.
- B. Run the generate-db-auth-token command with the user names to generate a temporary password for the users.
- C. Add the users' IAM credentials to the default credential profile, Use the AWS Management Console to access the DB cluster.
- D. Use an AWS Security Token Service (AWS STS) token by sending the IAM access key and secret key as headers to the DB cluster API endpoint.
Answer: B
Explanation: Answer is B. Amazon Aurora uses IAM authentication tokens to verify the database user’s login credentials. The user must generate an IAM DB authentication token and use it as a password to login. Using the generate-db-auth-token command will help to generate a temporary password for the users which they can use to log in.
Question 14 · No. 340 · Multiple choice
A company hosts an online gaming application on AWS. A single Amazon DynamoDB table contains one item for each registered user. The partition key for each item is the user's ID. A daily report generator computes the sum totals of two well-known attributes for all items in the table that contain a dimension attribute. As the number of users grows, the report generator takes more time to generate the report. Which combination of steps will minimize the time it takes to generate the report? (Choose two.)
- A. Create a global secondary index (GSI) that uses the user ID as the partition key and the dimension attribute as the sort key. Use the GSI to project the two attributes that the report generator uses to compute the sum totals.
- B. Create a local secondary index (LSI) that uses the user ID as the partition key and the dimension attribute as the sort key. Use the LSI to project the two attributes that the report generator uses to compute the sum totals.
- C. Modify the report generator to query the index instead of the table.
- D. Modify the report generator to scan the index instead of the table.
- E. Modify the report generator to call the BatchGetItem operation.
Answer: A, C
Explanation: Answer is A, C. Creating a Global Secondary Index with the User ID as the partition key and dimension attribute as the sort key would fasten the access to the data for the report generation. Modifying the report generator to query the index instead of the table would help to speed up the report generation as it would only need to look up the index table instead of the main table.
Question 15 · No. 341 · Multiple choice
A company runs an Amazon Aurora MySQL DB instance for one of its critical applications. The company’s marketing department sends promotional email messages to customers based on the data in this database. A database engineer needs to make the data from all the tables available in the company’s Amazon S3 data lake. The database engineer wants to perform an export from a snapshot to populate the S3 data lake with the contents of the database. Which combination of steps will meet these requirements with the LEAST operational overhead? (Choose three.)
- A. . Use an existing automated snapshot or manual snapshot, or create a manual snapshot of the DB instance.
- B. . Identify the S3 bucket for export. Provide access to the S3 bucket by using an IAM user. Attach an IAM policy with s3:PutObject*, s3:GetObject*, s3:Listucket, s3:DeleteObject*, and s3:GetucketLocation permissions to the IAM user. Attach the IAM role to the D instance.
- C. . reate a copy of an existing automated snapshot or manual snapshot of the DB instance.
- D. . Create a symmetric AWS Key Management Service (AWS KMS) key for server-side encryption. Export the snapshot to Amazon S3.
- E. . Identify the S3 bucket for export. Provide access to the S3 bucket by using an IAM role. Attach an IAM policy with s3:PutObject*, s3:GetQpject*, s3:ListBucket, s3:DeleteObject*, and s3:GetBucketLocation permissions to the IAM role. Attach the IAM role to the DB instance.
- F. . Create a symmetric AWS Key Management Service (AWS KMS) key for server-side encryption. Export the snapshot to Amazon S3 Glacier lexible Retrieval.
Answer: A, D, E
Explanation: Answer is A,D,E. Option A is correct because AWS supports exporting from both automatic and manual snapshots of Amazon Aurora database instances. Option D is needed because AWS requires use of a symmetric AWS Key Management Service (AWS KMS) key for server-side encryption when exporting the snapshot. Option E provides an appropriate method to give access to the S3 bucket by attaching an IAM role with necessary permissions. Options B and F are incorrect because they suggest methods that add unnecessary complexity.
Question 16 · No. 342 · Single choice
A company uses an Amazon Redshift cluster to support its business intelligence (BI) team. The cluster has a maintenance window that overlaps with some business report jobs that run long-running queries on the cluster. During a recent maintenance window, the cluster went offline and restarted for an update. The BI team wants to know which queries were terminated during the maintenance window. What should a database specialist do to obtain this information?
- A. . Look for the terminated queries in the SVL_QLOG view.
- B. . Look for the terminated queries in the SVL_QUERY_REPORT view.
- C. . Write a scalar SQL user-defined function to find the terminated queries.
- D. . Use a federated query to find the terminated queries.
Answer: A
Explanation: Answer is A. The SVL_QLOG view records logs about query execution and can be used to find terminated queries during any specified window.
Question 17 · No. 343 · Single choice
A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days. Which solution will meet these requirements in the MOST operationally efficient way?
- A. . Create a manual copy of the snapshot.
- B. . Export the contents of the snapshot to an Amazon S3 bucket.
- C. . hange the retention period of the snapshot to 45 days.
- D. . Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.
Answer: A
Explanation: Answer is A. Creating a manual copy of the snapshot is the most operationally efficient way to save a particular automated snapshot for longer than the maximum number of days. Other options involve exporting contents or creating native backups, which can take more resources and be less operationally efficient.
Question 18 · No. 344 · Single choice
A company is using Amazon DocumentDB (with MongoDB compatibility) to manage its complex documents. Users report that an Amazon DocumentDB cluster takes a long time to return query results. A database specialist must investigate and resolve this issue. Which of the following can the database specialist use to investigate the query plan and analyze the query performance?
- A. . WS X-Ray deep linking
- B. . Amazon CloudWatch Logs Insights
- C. . MongoDB explain() method
- D. . AWS CloudTrail with a custom filter
Answer: C
Explanation: Answer is C. The MongoDB explain() method is used to provide information about the MongoDB Query Optimizer's choice of plan. It identifies how queries are processed and can help in resolving efficiency issues.
Question 19 · No. 345 · Single choice
A database specialist needs to replace the encryption key for an Amazon RDS DB instance. The database specialist needs to take immediate action to ensure security of the database. Which solution will meet these requirements?
- A. Modify the DB instance to update the encryption key. Perform this update immediately without waiting for the next scheduled maintenance window.
- B. Export the database to an Amazon S3 bucket. Import the data to an existing DB instance by using the export file. Specify a new encryption key during the import process.
- C. Create a manual snapshot of the DB instance. Create an encrypted copy of the snapshot by using a new encryption key. Create a new DB instance from the encrypted snapshot.
- D. Create a manual snapshot of the DB instance. Restore the snapshot to a new DB instance. Specify a new encryption key during the restoration process.
Answer: A
Explanation: The solution that will meet the requirement is to modify the DB instance to update the encryption key immediately without waiting for the next scheduled maintenance window. This ensures the security of the database.
Question 20 · No. 346 · Single choice
A company has a web application that uses Amazon API Gateway to route HTTPS requests to AWS Lambda functions. The application uses an Amazon Aurora MySQL database for its data storage. The application has experienced unpredictable surges in traffic that overwhelm the database with too many connection requests. The company needs to implement a scalable solution that is more resilient to database failures as quickly as possible. Which solution will meet these requirements MOST cost-effectively?
- A. Migrate the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot. Change the endpoint in the Lambda functions to use the new database.
- B. Migrate the Aurora MySQL database to Amazon DynamoDB tables by using AWS Database Migration Service (AWS DMS). Change the endpoint in the Lambda functions to use the new database.
- C. Create an Amazon EventBridge rule that invokes a Lambda function. Code the function to iterate over all existing connections and to call MySQL queries to end any connections in the sleep state.
- D. Increase the instance class for the Aurora database with more memory. Set a larger value for the max_connections parameter.
Answer: A
Explanation: Migrating the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot and changing the endpoint in the Lambda functions to use the new database is the most cost-effective solution. This solution allows for automatic scaling based on demand and eliminates the need for managing database connections.