DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

2024 Updated DBS-C01 Exam Questions & Practice Tests, AWS Certified Database – Specialty | SPOTO

In today's data-driven landscape, the AWS Certified Database - Specialty certification has become a coveted credential for professionals seeking to validate their expertise in designing, deploying, and operating database solutions on the AWS platform. Preparing for the DBS-C01 exam can be a challenging endeavor, but SPOTO's updated exam materials offer a comprehensive and effective solution. SPOTO 2024 DBS-C01 exam questions and practice tests are meticulously crafted to reflect the latest exam objectives and industry trends. With a vast collection of exam questions and answers, sample questions, and mock exams, you'll gain exposure to a wide range of topics covered in the certification, including database design, migration, deployment, access, maintenance, automation, monitoring, security, and troubleshooting. SPOTO's exam materials are more than just exam dumps; they are carefully curated exam preparation resources that simulate real-world scenarios, helping you apply your knowledge in practical contexts. Regular practice with these online exam questions and exam simulators will not only reinforce your understanding but also boost your confidence and time management skills. Our detailed explanations accompanying each question ensure that you not only learn the correct answers but also gain a deeper comprehension of the underlying concepts. Additionally, these practice tests serve as invaluable exam preparation tools, allowing you to identify your strengths and weaknesses, enabling you to focus your study efforts effectively.

Take other online exams
Question #1
A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation. How can the Database Specialists accomplish this?
A. Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
B. Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
C. Enable Amazon RDS Performance Insights and review the appropriate dashboard
D. Enable Enhanced Monitoring will the appropriate settings
View answer
Correct Answer: C
Question #2
68. 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?
A. Stop the DB cluster and analyze how the website responds
B. Use Aurora fault injection to crash the master DB instance
C. Remove the DB cluster endpoint to simulate a master DB instance failure
D. Use Aurora Backtrack to crash the DB cluster
View answer
Correct Answer: B
Question #3
A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicasfor a highly intensive, business-critical application. The Aurora DB cluster has one medium-sized primary instance, onelarge-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.In the event of a primary failure, what will occur?
A. Aurora will promote an Aurora Replica that is of the same size as the primary instance
B. Aurora will promote an arbitrary Aurora Replica
C. Aurora will promote the largest-sized Aurora Replica
D. Aurora will not promote an Aurora Replica
View answer
Correct Answer: A
Question #4
64. A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster. The database will be accessed by multiple applications across the company. The company has mandated that all communications to the database be encrypted and the server identity must be validated. Any non-SSL- based connections should be disallowed access to the database. Which solution addresses these requirements?
A. Set the rds
B. Set the rds
C. Set the rds
D. Set the rds
View answer
Correct Answer: D
Question #5
69. 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?
A. Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption
B. Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs
C. Modify 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
D. Enable Amazon RDS Performance Insights on the PostgreSQL database
View answer
Correct Answer: D
Question #6
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database,including database shutdown, deletion, creation, and backup.The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy theserequirements. The data could be used by other systems within the company.Which solution will meet these requirements with minimal effort?
A. Create an Amazon CloudWatch Events rule with the operations that need to be tracked on Amazon RDS
B. Create an AWS Lambda function to trigger on AWS CloudTrail API calls
C. Create RDS event subscriptions
D. Write RDS logs to Amazon Kinesis Data Firehose
View answer
Correct Answer: C
Question #7
76. 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. Ensure the table is always provisioned to meet peak needs
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. Pre Provision additional capacity for the known peaks and then reduce the capacity after the event
View answer
Correct Answer: B
Question #8
After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect tothe restored RDS DB instance. What is the likely cause of this problem?
A. The restored DB instance does not have Enhanced Monitoring enabled
B. The production DB instance is using a custom parameter group
C. The restored DB instance is using the default security group
D. The production DB instance is using a custom option group
View answer
Correct Answer: C
Question #9
The Development team recently executed a database script containing several data definition language (DDL) and datamanipulation language (DML) statements on an Amazon Aurora MySQL DB cluster. The release accidentally deletedthousands of rows from an important table and broke some application functionality. This was discovered 4 hours after therelease. Upon investigation, a Database Specialist tracked the issue to a DELETE command in the script with an incorrectWHERE clause filtering the wrong set of rows.Th
A. Quickly rewind the DB cluster to a point in time before the release using Backtrack
B. Perform a point-in-time recovery (PITR) of the DB cluster to a time before the release and copy the deleted rows from the restored database to the original database
C. Restore the DB cluster using the manual backup snapshot created before the release and change the application configuration settings to point to the new DB cluster
D. Create a clone of the DB cluster with Backtrack enabled
View answer
Correct Answer: D
Question #10
72. A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors. Which of the following will resolve this issue?
A. Edit the my
B. Increase the instance size of the DB cluster
C. Change the DB cluster to Multi-AZ
D. Increase the number of Aurora Replicas
View answer
Correct Answer: B
Question #11
A database specialist has a fleet of Amazon RDS DB instances that use the default DB parameter group. The databasespecialist needs to associate a custom parameter group with some of the DB instances.After the database specialist makes this change, when will the instances be assigned to this new parameter group?
A. Instantaneously after the change is made to the parameter group
B. In the next scheduled maintenance window of the DB instances
C. After the DB instances are manually rebooted
D. Within 24 hours after the change is made to the parameter group
View answer
Correct Answer: C
Question #12
A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster containssome 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?
A. Use AWS IAM database authentication and restrict access to the tables using an IAM policy
B. Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster
C. Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data
D. Define access privileges to the tables containing sensitive data in the pg_hba
View answer
Correct Answer: C
Question #13
A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A databasespecialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Serverbackup file is approximately 120 GB in size. The application can be down for an extended period of time to complete themigration. Connectivity between the onpremises environment and AWS can be initiated from on-premises only.How can the database be migrated from on-premises to Amazon RDS
A. Back up the SQL Server database using a native SQL Server backup
B. Back up the SQL Server database using a native SQL Server backup
C. Provision and configure AWS DMS
D. Back up the SQL Server database using AWS Backup
View answer
Correct Answer: B
Question #14
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? According to the Amazon Redshift documentation1, you can enable database encryption for yo
A. opy the AWS Key Management Service (AWS KMS) customer managed key from the source Region to the destination Region
B. reate a new AWS Key Management Service (AWS KMS) customer managed key in the destination Region
C. opy the AWS Key Management Service (AWS KMS) customer-managed key from the source Region to the destination Region
D. se the same customer-supplied key materials to create a CMK with the same private key in the destination Region
View answer
Correct Answer: B
Question #15
71. A company is running a two-tier e commerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue. Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)
A. Grant least privilege to groups, users, and roles
B. Allow all users to restore a database from a backup that will reduce the overall downtime to restore the database
C. Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations
D. Use policy conditions to restrict access to selective IP addresses
E. Use AccessList Controls policy type to restrict users for database instance deletion
F. Enable AWS CloudTrail logging and Enhanced Monitoring
View answer
Correct Answer: ACD
Question #16
67. 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?
A. Use AWS IAM database authentication and restrict access to the tables using an IAM policy
B. Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster
C. Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data
D. Define access privileges to the tables containing sensitive data in the pg_hba
View answer
Correct Answer: C
Question #17
An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server EnterpriseEdition DB instance. The company expects a spike in read traffic due to an upcoming sale. A database specialist mustcreate a read replica of the DB instance to serve the anticipated read traffic.Which actions should the database specialist take before creating the read replica? (Choose two.)
A. Identify a potential downtime window and stop the application calls to the source DB instance
B. Ensure that automatic backups are enabled for the source DB instance
C. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups
D. Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM)
E. Modify the read replica parameter group setting and set the value to 1
View answer
Correct Answer: BD
Question #18
A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table usesprovisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist hasrestored the latest backup to a new table.To prepare the new table with identical settings, which steps should be performed? (Choose two.)
A. Re-create global secondary indexes in the new table
B. Define IAM policies for access to the new table
C. Define the TTL settings
D. Encrypt the table from the AWS Management Console or use the update-table command
E. Set the provisioned read and write capacity
View answer
Correct Answer: AE
Question #19
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 re
A. Turn on the serverless option in the DB cluster so it can automatically scale based on demand
B. Provision a clone of the existing DB cluster for the new Application team
C. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoingreplication using AWS DMS change data capture (CDC)
D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPUconsumption
View answer
Correct Answer: A
Question #20
A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the mostrecent minor version available. Noticing that there is a new minor version available, the database specialist has issues anAWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the AuroraDB cluster indicates that no update to the Aurora version has been made.What might account for this? (Choose two.)
A. The new minor version has not yet been designated as preferred and requires a manual upgrade
B. Configuring automatic upgrades using the AWS CLI is not supported
C. Applying minor version upgrades requires sufficient free space
D. The AWS CLI command did not include an apply-immediately parameter
E. Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade
View answer
Correct Answer: CD
Question #21
78. A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The company now want to downsize storage to save money. The solution must have the least impact on production and near-zero downtime. Which solution would meet these requirements?
A. Create a snapshot of the old databases and restore the snapshot with the required storage
B. Create a new RDS DB instance with the required storage and move the databases from the old instances to the new instance using AWS DMS
C. Create a new database using native backup and restore
D. Create a new read replica and make it the primary by terminating the existing primary
View answer
Correct Answer: A
Question #22
A database specialist is launching a test graph database using Amazon Neptune for the first time. The database specialist needs to insert millions of rows of test observations from a .csv file that is stored in Amazon S3. The database specialist has been using a series of API calls to upload the data to the Neptune DB instance. Which combination of steps would allow the database specialist to upload the data faster? (Choose three.) Correct Answer: B, E, F Explanation from Amazon documents: To upload data fa
A. nsure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file
B. nsure the vertices and edges are specified in different
C. se AWS DMS to move data from Amazon S3 to the Neptune Loader
D. url the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands
E. nsure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket
F. reate an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint
View answer
Correct Answer: BEF
Question #23
A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306. The company’s Database Specialist is able to log in to MySQL and run queries from the bastion host using these details. When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging
A. The user name and password the application is using are incorrect
B. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance
C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers
D. The user name and password are correct, but the user is not authorized to use the DB instance
View answer
Correct Answer: C
Question #24
An ecommerce company uses Amazon DynamoDB as the backend for its payments system. A new regulation requires thecompany to log all data access requests for financial audits. For this purpose, the company plans to use AWS logging andsave logs to Amazon S3 How can a database specialist activate logging on the database?
A. Use AWS CloudTrail to monitor DynamoDB control-plane operations
B. Use AWS CloudTrail to monitor DynamoDB data-plane operations
C. Create two trails in AWS CloudTrail
D. Use AWS CloudTrail to monitor DynamoDB data-plane and control-plane operations
View answer
Correct Answer: D
Question #25
A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simpledatabase behavior. When loading a large dataset and creating the index, the Database Specialist encounters the followingerror message from Aurora:ERROR: cloud not write block 7507718 of temporary file: No space left on deviceWhat is the cause of this error and what should the Database Specialist do to resolve this issue?
A. The scaling of Aurora storage cannot catch up with the data loading
B. The scaling of Aurora storage cannot catch up with the data loading
C. The local storage used to store temporary tables is full
D. The local storage used to store temporary tables is full
View answer
Correct Answer: C
Question #26
A company is going through a security audit. The audit team has identified cleartext master user password in the AWSCloudFormation templates for Amazon RDS for MySQL DB instances. The audit team has flagged this as a security risk tothe database team.What should a database specialist do to mitigate this risk?
A. Change all the databases to use AWS IAM for authentication and remove all the cleartext passwords in CloudFormation templates
B. Use an AWS Secrets Manager resource to generate a random password and reference the secret in the CloudFormation template
C. Remove the passwords from the CloudFormation templates so Amazon RDS prompts for the password when the database is being created
D. Remove the passwords from the CloudFormation template and store them in a separate file
View answer
Correct Answer: C
Question #27
A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system.New compliance requirements specify that the database must be encrypted at rest.Which action will meet these requirements?
A. Create an encrypted copy of manual snapshot of the DB instance
B. Modify the DB instance and enable encryption
C. Restore a DB instance from the most recent automated snapshot and enable encryption
D. Create an encrypted read replica of the DB instance
View answer
Correct Answer: C
Question #28
The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. ADatabase Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for theSecurity team to use for monitoring and alerting. The Security team is required to perform real-time alerting and monitoringoutside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution. Which approach willmeet these requirements?
A. Use pg_audit to generate audit logs and send the logs to the Security team
B. Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3
C. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications
D. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team
View answer
Correct Answer: B
Question #29
66. 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?
A. Create the database with the MasterUserName and MasterUserPassword properties set to the default values
B. Add a Mapping property from the database Amazon Resource Name (ARN) to the secret ARN
C. Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property
D. Create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property
View answer
Correct Answer: C
Question #30
75. A company has migrated a single MySQL database to Amazon Aurora. The production data is hosted in a DB cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using the same AWS account. Testing results in minimal changes to the test data. The Development team wants each environment refreshed nightly so each test database contains fresh production data every day. Which migration approach will be the fastest and most cost-effective to implement?
A. Run the master in Amazon Aurora MySQL
B. Run the master in Amazon Aurora MySQL
C. Run the master in Amazon Aurora MySQL
D. Run the master in Amazon Aurora MySQL using Aurora Serverless
View answer
Correct Answer: A
Question #31
73. A company is developing a multi-tier web application hosted on AWS using Amazon Aurora as the database. The application needs to be deployed to production and other non-production environments. A Database Specialist needs to specify different MasterUsername and MasterUserPassword properties in the AWS CloudFormation templates used for automated deployment. The CloudFormation templates are version controlled in the company’s code repository. The company also needs to meet compliance requirement by routin
A. Store the master password in a parameter file in each environment
B. Encrypt the master password using an AWS KMS key
C. Use the secretsmanager dynamic reference to retrieve the master password stored in AWS Secrets Manager and enable automatic rotation
D. Use the ssm dynamic reference to retrieve the master password stored in the AWS Systems Manager Parameter Store and enable automatic rotation
View answer
Correct Answer: C
Question #32
74. 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 DynamoDB
B. Amazon Redshift
C. Amazon Neptune
D. Amazon Elasticsearch Service
E. Amazon ElastiCache
View answer
Correct Answer: AE
Question #33
70. A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when survey responses are being collected, a Database Specialist sees the ProvisionedThroughputExceededException error. What can the Database Specialist do to resolve this error? (Choose two.)
A. Change the table to use Amazon DynamoDB Streams
B. Purchase DynamoDB reserved capacity in the affected Region
C. Increase the write capacity units for the specific table
D. Change the table capacity mode to on-demand
E. Change the table type to throughput optimized
View answer
Correct Answer: CD
Question #34
A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists. Which step should b
A. Ensure that the database option group for the RDS DB instance allows ingress from theDevelopermachine’s IP address
B. Ensure that the RDS DB instance’s subnet group includes a public subnet to allow the Developer toconnect
C. Ensure that the RDS DB instance has not reached its maximum connections limit
D. Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listeningfor encrypted connections
View answer
Correct Answer: C
Question #35
65. A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours. Which solution will meet these requirements and is the MOST operationally efficient?
A. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot
B. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot
C. Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days
D. Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot
View answer
Correct Answer: B
Question #36
A database specialist is planning to migrate a 4 TB Microsoft SQL Server DB instance from on premises to Amazon RDS for SQL Server. The database is primarily used for nightly batch processing. Which RDS storage option meets these requirements MOST cost-effectively? General Purpose SSD storage is a cost-effective storage option that is ideal for a broad range of workloads running on medium-sized DB instances1.General Purpose storage is best suited for development and testing environments1.Since the database
A. eneral Purpose SSD storage
B. rovisioned IOPS storage
C. agnetic storage
D. hroughput Optimized hard disk drives (HDD)
View answer
Correct Answer: A
Question #37
79. A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists. Which step shou
A. Ensure that the database option group for the RDS DB instance allows ingress from the Developer machine’s IP address
B. Ensure that the RDS DB instance subnet group includes a public subnet to allow the Developer to connect
C. Ensure that the RDS DB instance has not reached its maximum connections limit
D. Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listening for encrypted connections
View answer
Correct Answer: B
Question #38
A company uses Amazon Aurora MySQL as the primary database engine for many of its applications. A database specialistmust create a dashboard to provide the company with information about user connections to databases. According tocompliance requirements, the company must retain all connection logs for at least 7 years.Which solution will meet these requirements MOST cost-effectively?
A. Enable advanced auditing on the Aurora cluster to log CONNECT events
B. Capture connection attempts to the Aurora cluster with AWS Cloud Trail by using the DescribeEvents API operation
C. Start a database activity stream for the Aurora cluster
D. Publish the DatabaseConnections metric for the Aurora DB instances to Amazon CloudWatch
View answer
Correct Answer: C
Question #39
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?
A. Create a snapshot of the unencrypted RDS DB instanc
B. Create an encrypted copy of the unencryptedsnapsho
C. Restore the encrypted snapshot copy
D. Modify the RDS DB instanc
E. Enable the AWS KMS encryption option that leverages the AWS CLI
F. Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted
View answer
Correct Answer: A
Question #40
80. 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?
A. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
B. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
C. Enable a read replicas and direct read traffic to it when Amazon RDS is down
D. Enable an Amazon RDS for MySQL Multi-AZ configuration
View answer
Correct Answer: D
Question #41
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?
A. Use a specific instance endpoint for each replica and add the instance endpoint to each read-onlyapplication connection string
B. Use reader endpoints for both the read-only workload applications
C. Use a reader endpoint for one read-only application and use an instance endpoint for the other read-onlyapplication
D. Use custom endpoints for the two read-only applications
View answer
Correct Answer: AD
Question #42
An online bookstore uses Amazon Aurora MySQL as its backend database. After the online bookstore added a popular book to the online catalog, customers began reporting intermittent timeouts on the checkout page. A database specialist determined that increased load was causing locking contention on the database. The database specialist wants to automatically detect and diagnose database performance issues and to resolve bottlenecks faster. Which solution will meet these requirements? Correct Answer: A Explana
A. urn on Performance Insights for the Aurora MySQL database
B. reate a CPU usage alarm
C. se the Amazon RDS query editor to get the process ID of the query that is causing the database to lock
D. se the SELECT INTO OUTFILE S3 statement to query data from the database
View answer
Correct Answer: A
Question #43
A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity. A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed. Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)
A. Review the stack drift before modifying the template
B. Create and review a change set before applying it
C. Export the database resources as stack outputs
D. Define the database resources in a nested stack
E. Set a stack policy for the database resources
View answer
Correct Answer: D
Question #44
A healthcare company is running an application on Amazon EC2 in a public subnet and using Amazon DocumentDB (with MongoDB compatibility) as the storage layer. An audit reveals that the traffic between the application and Amazon DocumentDB is not encrypted and that the DocumentDB cluster is not encrypted at rest. A database specialist must correct these issues and ensure that the data in transit and the data at rest are encrypted. Which actions should the database specialist take to meet these requirements? (Select TWO.)
A. ownload the SSH RSA public key for Amazon DocumentDB
B. ownload the SSL
C. reate a snapshot of the unencrypted cluster
D. reate an Amazon DocumentDB VPC endpoint to prevent the traffic from going to the Amazon DocumentDB public endpoint
E. ctivate encryption at rest using the modify-db-cluster command with the ---storage-encrypted parameter set to true
View answer
Correct Answer: BC
Question #45
77. A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB instance goes live. What change should the Database Specialist make to enable the migration?
A. Configure the on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)
B. Configure the AWS DMS replication instance to allow both full load and ongoing change data capture (CDC)
C. Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)
D. Configure the AWS DMS connections to allow two-way communication to allow for ongoing change data capture (CDC)
View answer
Correct Answer: A

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.