NEW 2024 Certification Sample Questions DBS-C01 Dumps & Practice Exam
DBS-C01 Deluxe Study Guide with Online Test Engine
To become an AWS Certified Database Specialist, candidates must demonstrate their proficiency in designing, deploying, and managing highly available, cost-effective, and secure database solutions on AWS. They must also be able to optimize database performance and troubleshoot common database issues. AWS Certified Database - Specialty (DBS-C01) Exam certification exam covers a wide range of topics, including database design principles, data modeling, database security, backup and recovery, and database automation.
NEW QUESTION # 174
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?
- A. Use 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.
- B. Order 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.
- C. Dump 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.
- D. Use 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.
Answer: D
Explanation:
Explanation
https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/
NEW QUESTION # 175
An ecommerce company uses Amazon DynamoDB as the backend for its payments system. A new regulation requires the company to log all data access requests for financial audits. For this purpose, the company plans to use AWS logging and save logs to Amazon S3 How can a database specialist activate logging on the database?
- A. Use AWS CloudTrail to monitor DynamoDB control-plane operations. Create a DynamoDB stream to monitor data-plane operations. Pass the stream to Amazon Kinesis Data Streams. Use that stream as a source for Amazon Kinesis Data Firehose to store the data in an Amazon S3 bucket.
- B. Use AWS CloudTrail to monitor DynamoDB data-plane operations. Create a DynamoDB stream to monitor control-plane operations. Pass the stream to Amazon Kinesis Data Streams. Use that stream as a source for Amazon Kinesis Data Firehose to store the data in an Amazon S3 bucket.
- C. Use AWS CloudTrail to monitor DynamoDB data-plane and control-plane operations.
- D. Create two trails in AWS CloudTrail. Use Trail1 to monitor DynamoDB control-plane operations. Use Trail2 to monitor DynamoDB data-plane operations.
Answer: C
Explanation:
https://aws.amazon.com/about-aws/whats-new/2021/04/you-now-can-use-aws-cloudtrail-to-log-amazon-dynamodb-streams-da/
NEW QUESTION # 176
A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?
- A. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
- B. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.
- C. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
- D. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
Answer: C
NEW QUESTION # 177
Amazon Neptune is being used by a corporation as the graph database for one of its products. During an ETL procedure, the company's data science team produced enormous volumes of temporary data by unintentionally. The Neptune DB cluster extended its storage capacity automatically to handle the added data, but the data science team erased the superfluous data.
What should a database professional do to prevent incurring extra expenditures for cluster volume space that is not being used?
- A. Export the cluster data into a new Neptune DB cluster.
- B. Use the AWS CLI to turn on automatic resizing of the cluster volume.
- C. Add a Neptune read replica to the cluster. Promote this replica as a new primary DB instance. Reset the storage space of the cluster.
- D. Take a snapshot of the cluster volume. Restore the snapshot in another cluster with a smaller volume size.
Answer: A
Explanation:
The only way to shrink the storage space used by your DB cluster when you have a large amount of unused allocated space is to export all the data in your graph and then reload it into a new DB cluster. Creating and restoring a snapshot does not reduce the amount of storage allocated for your DB cluster, because a snapshot retains the original image of the cluster's underlying storage.
NEW QUESTION # 178
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 off-peak 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?
- A. Use provisioned capacity. Set it to the capacity levels required for peak daytime throughput.
- B. Use reserved capacity. Set it to the capacity levels required for peak daytime throughput.
- C. Use provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
- D. Use on-demand capacity.
Answer: D
NEW QUESTION # 179
A large ecommerce company uses Amazon DynamoDB to handle the transactions on its web portal. Traffic patterns throughout the year are usually stable; however, a large event is planned. The company knows that traffic will increase by up to 10 times the normal load over the 3-day event. When sale prices are published during the event, traffic will spike rapidly.
How should a Database Specialist ensure DynamoDB can handle the increased traffic?
- A. Preprovision additional capacity for the known peaks and then reduce the capacity after the event
- B. Allow burst capacity to handle the additional load
- C. Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
- D. Ensure the table is always provisioned to meet peak needs
Answer: A
Explanation:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-partition-key-design.html#bp-partition-key-throughput-bursting
"DynamoDB provides some flexibility in your per-partition throughput provisioning by providing burst capacity. Whenever you're not fully using a partition's throughput, DynamoDB reserves a portion of that unused capacity for later bursts of throughput to handle usage spikes. DynamoDB currently retains up to 5 minutes (300 seconds) of unused read and write capacity. During an occasional burst of read or write activity, these extra capacity units can be consumed quickly-even faster than the per-second provisioned throughput capacity that you've defined for your table. DynamoDB can also consume burst capacity for background maintenance and other tasks without prior notice. Note that these burst capacity details might change in the future."
NEW QUESTION # 180
A company has an AWS CloudFormation stack that defines an Amazon RDS DB instance. The company accidentally deletes the stack and loses recent data from the DB instance. A database specialist must change the CloudFormation template for the RDS resource to reduce the chance of accidental data loss from the DB instance in the future.
Which combination of actions should the database specialist take to meet this requirement? (Choose three.)
- A. Set the DeletionPolicy attribute to No.
- B. Set the DeletionPolicy attribute to Retain.
- C. Set the MultiAZ property to True.
- D. Set the DeletionProtection property to True.
- E. Set the DeleteAutomatedBackups property to False.
- F. Set the TerminationProtection property to True.
Answer: B,D,E
NEW QUESTION # 181
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?
- A. Create new Aurora Serverless DB clusters for development and reporting, then migrate to these new DB clusters.
- B. Use existing DB clusters and stop/start the databases on a routine basis using scheduling tools.
- C. Change the DB clusters to the burstable instance family.
- D. Upgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.
Answer: A
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.DBInstanceClass.html
NEW QUESTION # 182
A company uses Microsoft SQL Server on Amazon RDS in a Multi-AZ deployment as the database engine for its application. The company was recently acquired by another company. A database specialist must rename the database to follow a new naming standard.
Which combination of steps should the database specialist take to rename the database? (Choose two.)
- A. Turn off automatic snapshots for the DB instance. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedure. Turn on the automatic snapshots.
- B. Turn off Multi-AZ for the DB instance. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedure. Turn on Multi-AZ Mirroring.
- C. Update the DNS record for the DB instance.
- D. Delete all existing snapshots for the DB instance. Use the rdsadmin.dbo.rds_modify_db_name stored procedure.
- E. Update the application with the new database connection string.
Answer: B,E
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html
NEW QUESTION # 183
A company is running critical applications on AWS. Most of the application deployments use Amazon Aurora MySQL for the database stack. The company uses AWS CloudFormation to deploy the DB instances.
The company's application team recently implemented a CI/CD pipeline. A database engineer needs to integrate the database deployment CloudFormation stack with the newly built CllCD platform. Updates to the CloudFormation stack must not update existing production database resources.
Which CloudFormation stack policy action should the database engineer implement to meet these requirements?
- A. Use a Deny statement for the Update:Replace action on the production database resources.
- B. Use a Deny statement for the action on the production database resources.
- C. Use a Deny statement for the Update:Modify action on the production database resources.
- D. Use a Deny statement for the Update:Delete action on the production database resources.
Answer: A
Explanation:
Correct Answer: D
Explanation from Amazon documents:
A CloudFormation stack policy is a JSON document that defines the update actions that can be performed on designated resources in a CloudFormation stack. A stack policy can be used to prevent accidental updates or deletions of stack resources, such as a production database.
The Update:Replace action is an update action that replaces an existing resource with a new one during a stack update. This action can cause data loss or downtime for the resource. To prevent this action from affecting the production database resources, the database engineer should use a Deny statement for the Update:Replace action on the production database resources in the stack policy. This statement will override any Allow statements for the same action and resource, and protect the production database resources from being replaced during a stack update.
Therefore, option D is the correct stack policy action to meet the requirements. Option A is incorrect because the Update:Modify action is not a valid update action for a stack policy. The valid update actions are Update:Replace, Update:Skip, and Delete. Option B is incorrect because it does not specify a valid update action for the Deny statement. Option C is incorrect because the Update:Delete action is not a valid update action for a stack policy. The valid update actions are Update:Replace, Update:Skip, and Delete.
NEW QUESTION # 184
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?
- A. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs
- B. Log in to the host and run the rm $PGDATA/pg_logs/* command
- C. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to bedeleted
- D. Create a ticket with AWS Support to have the logs deleted
Answer: C
NEW QUESTION # 185
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.)
- A. Set MultiAZ to True
- B. Set DeletionProtection to True
- C. Set DeletionPolicy to Retain
- D. Set DeleteAutomatedBackups to False
- E. Set DeletionPolicy to Delete
- F. Set TerminationProtection to True
Answer: B,C,F
NEW QUESTION # 186
After restoring an Amazon RDS snapshot from 3 days ago, a company's Development team cannot connect to the restored RDS DB instance. What is the likely cause of this problem?
- A. The restored DB instance is using the default security group
- B. The production DB instance is using a custom option group
- C. The restored DB instance does not have Enhanced Monitoring enabled
- D. The production DB instance is using a custom parameter group
Answer: A
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html
NEW QUESTION # 187
A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)
- A. Amazon Neptune
- B. Amazon Elasticsearch Service
- C. Amazon ElastiCache
- D. Amazon DynamoDB
- E. Amazon Redshift
Answer: C,D
Explanation:
https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html#Strategies.WriteThrough
https://aws.amazon.com/products/databases/real-time-apps-elasticache-for-redis/
NEW QUESTION # 188
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?
- A. Use 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.
- B. Use 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.
- C. Use 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.
- D. Use 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.
Answer: C
Explanation:
Explanation
"AWS DataSync is an online data transfer service that simplifies, automates, and accelerates moving data between on-premises storage systems and AWS storage services, and also between AWS storage services."
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load.html
NEW QUESTION # 189
A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?
- A. Configure RDS instance Auto Scaling.
- B. Modify the DB instance allocated storage to meet the forecasted requirements.
- C. Configure RDS Storage Auto Scaling.
- D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
Answer: C
Explanation:
Explanation
If your workload is unpredictable, you can enable storage autoscaling for an Amazon RDS DB instance. With storage autoscaling enabled, when Amazon RDS detects that you are running out of free database space it automatically scales up your storage.
https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html#USER_PIOPS.A
NEW QUESTION # 190
A company has more than 100 AWS accounts that need Amazon RDS instances. The company wants to build an automated solution to deploy the RDS instances with specific compliance parameters. The data does not need to be replicated. The company needs to create the databases within 1 day Which solution will meet these requirements in the MOST operationally efficient way?
- A. Create RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.
- B. use AWS CloudFormation to create RDS instances in each account. Run AWS Database Migration Service (AWS DMS) replication to each ot the created instances.
- C. Create an RDS snapshot. Share the snapshot With each account Deploy the snapshot into each account
- D. Create a script by using the AWS CLI to copy the ROS instance into the other accounts from a template account.
Answer: A
Explanation:
Explanation
AWS CloudFormation is a service that helps you model and set up your AWS resources so that you can spend less time managing those resources and more time focusing on your applications that run in AWS. You create a template that describes all the AWS resources that you want (like Amazon RDS instances), and CloudFormation takes care of provisioning and configuring those resources for you1.
Using AWS CloudFormation to create RDS resources and share the template with each account is a suitable solution for the company's requirements, as it can:
Automate the deployment of RDS instances with specific compliance parameters, such as security groups, encryption, backup settings, etc.
Reduce the operational overhead and human errors of manually creating RDS instances in each account.
Enable the company to create the databases within one day, as CloudFormation can provision resources in parallel and in a consistent manner.
NEW QUESTION # 191
......
DBS-C01 dumps review - Professional Quiz Study Materials: https://passleader.free4dump.com/DBS-C01-real-dump.html