[Nov-2021] AWS-Certified-Database-Specialty Dumps PDF - AWS-Certified-Database-Specialty Real Exam Questions Answers
AWS-Certified-Database-Specialty Dumps 100% Pass Guarantee With Latest Demo
How to study the AWS Certified Database - Specialty
A broad range of AMAZON DBS-C01 dumps for AWS Accredited Developer-Professional Certification have been recognized for certification issues. The reality that students need to prepare attentively does not make certificates easy. It also takes a long time to learn from AWS Accredited Developer-Professional. Every examen includes answers and questions that help students pass their final test. You will pass the test after you have taken and learned our modules. But it doesn’t end there; thanks to our full guides, you will still be good in your career. You will produce your goods in the future. To plan any material for you, we have an advanced method. In the development of and commodity, we have used the latest details.
AMAZON DBS-C01 practice test is easy to use, so that anyone can appreciate them. In such dynamic areas, where qualification requires a lot of study, planning, and focus, no one likes loss. An effort is so hard that even the students' nerves can be shattered. Our waste management systems are so legitimate and best that you have no pain to pass your AWS accredited Developer Professional.
NEW QUESTION 87
A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances. The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.
What is the MOST operationally efficient solution to meet these requirements?
- A. Save the password in an Amazon S3 object. Encrypt the S3 object with an AWS KMS key. Set the KMS key to be rotated every 30 days by setting the EnableKeyRotation property to true. Use a CloudFormation custom resource to read the S3 object to extract the password.
- B. Create an AWS Lambda function to rotate the secret. Modify the CloudFormation template to add an AWS::SecretsManager::RotationSchedule resource. Configure the RotationLambdaARN value and, for the RotationRules property, set the AutomaticallyAfterDays parameter to 30.
- C. Integrate the Amazon RDS for MySQL DB instances with AWS IAM and centrally manage the master database user password.
- D. Modify the CloudFormation template to use the AWS KMS key as the database password. Configure an Amazon EventBridge rule to invoke the KMS API to rotate the key every 30 days by setting the ScheduleExpression parameter to ***/30***.
Answer: D
NEW QUESTION 88
A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account. The template configures provisioned throughput capacity using hard-coded values. The company wants to change the template so that the tables it creates in the future have independently configurable read and write capacity units assigned.
Which solution will enable this change?
- A. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template.
ConfigureDynamoDB to provision throughput capacity using the stack's mappings. - B. Add values for two Number parameters, rcuCount and wcuCount, to the template. Replace the hard-codedvalues with calls to the Ref intrinsic function, referencing the new parameters.
- C. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template.
Replacethe hard-coded values with calls to the Ref intrinsic function, referencing the new parameters. - D. Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDBto provision throughput capacity using the stack outputs.
Answer: B
NEW QUESTION 89
A company is running a finance application on an Amazon RDS for MySQL DB instance. The application is governed by multiple financial regulatory agencies. The RDS DB instance is set up with security groups to allow access to certain Amazon EC2 servers only. AWS KMS is used for encryption at rest.
Which step will provide additional security?
- A. Set up NACLs that allow the entire EC2 subnet to access the DB instance
- B. Disable the master user account
- C. Set up a security group that blocks SSH to the DB instance
- D. Set up RDS to use SSL for data in transit
Answer: D
NEW QUESTION 90
A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?
- A. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate the migration compatibility.
- B. Perform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing row counts from source and target tables.
- C. Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster. Create a migration assessment report to evaluate the migration compatibility.
- D. Run AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing the row counts from source and target tables.
Answer: C
NEW QUESTION 91
A financial services company is developing a shared data service that supports different applications from throughout the company. A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis with cluster mode enabled to enhance performance and scalability. The cluster is configured to listen on port 6379.
Which combination of steps should the Database Specialist take to secure the cache data and protect it from unauthorized access? (Choose three.)
- A. Create an IAM policy to allow the application service roles to access all ElastiCache API actions.
- B. Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.
- C. Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.
- D. Ensure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22 traffic from the trusted ElastiCache cluster's security group.
- E. Enable in-transit and at-rest encryption on the ElastiCache cluster.
- F. Ensure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound traffic on TCP port 6379 from trusted clients only.
Answer: B,D,E
NEW QUESTION 92
A manufacturing company's website uses an Amazon Aurora PostgreSQL DB cluster.
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)
- A. Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
- B. Edit and enable Aurora DB cluster cache management in parameter groups.
- C. Set Java DNS caching timeouts to a high value.
- D. Set JDBC connection string timeout variables to a low value.
- E. Set TCP keepalive parameters to a high value.
- F. Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
Answer: A,B,F
NEW QUESTION 93
A company's Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials. A Database Specialist must make the modifications needed to fulfill this requirement.
Which combination of actions should the Database Specialist take? (Choose three.)
- A. Modify the RDS SQL Server DB instance to use the directory for Windows authentication. Create appropriate new logins.
- B. Use the AWS Management Console to create an AWS Managed Microsoft AD. Create a trust relationship with the corporate AD.
- C. Use the AWS Management Console to create an AD Connector. Create a trust relationship with the corporate AD.
- D. Configure the AWS Managed Microsoft AD domain controller Security Group.
- E. Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.
- F. Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and start it again. Create appropriate new logins.
Answer: A,B,D
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerWinAuth.html
NEW QUESTION 94
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. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once theSnowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration tomigrate the data directly from Amazon S3 to Amazon RDS.
- B. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an AmazonEC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to anAurora DB cluster.
- C. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during theschema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
- D. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp).
Rundata transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.
Answer: B
NEW QUESTION 95
A database specialist was alerted that a production Amazon RDS MariaDB instance with 100 GB of storage was out of space. In response, the database specialist modified the DB instance and added 50 GB of storage capacity. Three hours later, a new alert is generated due to a lack of free space on the same DB instance. The database specialist decides to modify the instance immediately to increase its storage capacity by 20 GB.
What will happen when the modification is submitted?
- A. The request will succeed only if the primary instance is in active status.
- B. The request will fail because this storage capacity is too large.
- C. The request will fail as the most recent modification was too soon.
- D. The request will succeed only if CPU utilization is less than 10%.
Answer: A
NEW QUESTION 96
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. Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
- B. Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.
- C. Create an encrypted read replica of the RDS DB instance. Promote it the master.
- D. Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencryptedsnapshot. Restore the encrypted snapshot copy.
Answer: D
NEW QUESTION 97
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 new RDS DB instance with the required storage and move the databases from the old instances to the new instance using AWS DMS
- B. Create a new read replica and make it the primary by terminating the existing primary
- C. Create a snapshot of the old databases and restore the snapshot with the required storage
- D. Create a new database using native backup and restore
Answer: A
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/rds-db-storage-size/ Use AWS Database Migration Service (AWS DMS) for minimal downtime.
NEW QUESTION 98
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. Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property. Then, define the database user name in the SecureStringTemplate template. Create a resource for the database and reference the secret string for the MasterUserName and MasterUserPassword properties. Then, add a resource of type AWS::SecretsManagerSecretTargetAttachment with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database.
- B. Create the database with the MasterUserName and MasterUserPassword properties set to the default values. Then, create the secret with the user name and password set to the same default values. Add a Secret Target Attachment resource with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database. Finally, update the secret's password value with a randomly generated string set by the GenerateSecretString property.
- C. Create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add an SecretTargetAttachment resource with the SecretId property set to the Amazon Resource Name (ARN) of the secret and the TargetId property set to a parameter value matching the desired database ARN. Then, create a database with the MasterUserName and MasterUserPassword properties set to the previously created values in the secret.
- D. Add a Mapping property from the database Amazon Resource Name (ARN) to the secret ARN. Then, create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add the database with the MasterUserName and MasterUserPassword properties set to the user name of the secret.
Answer: A
NEW QUESTION 99
An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company's Amazon RDS database. A database specialist needs to ensure the database is up and running at all times. The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.
What should the database specialist do to achieve this? (Choose two.)
- A. Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
- B. Enable email notifications for AWS Trusted Advisor.
- C. Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
- D. Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
- E. Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
Answer: A,E
NEW QUESTION 100
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 routinely rotating its database master password for production.
What is most secure solution to store the master password?
- A. Use the ssm dynamic reference to retrieve the master password stored in the AWS Systems ManagerParameter Store and enable automatic rotation.
- B. Store the master password in a parameter file in each environment. Reference the environment-specific parameter file in the CloudFormation template.
- C. Use the secretsmanager dynamic reference to retrieve the master password stored in AWS SecretsManager and enable automatic rotation.
- D. Encrypt the master password using an AWS KMS key. Store the encrypted master password in theCloudFormation template.
Answer: C
NEW QUESTION 101
A financial services company is developing a shared data service that supports different applications from throughout the company. A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis with cluster mode enabled to enhance performance and scalability. The cluster is configured to listen on port
6379.
Which combination of steps should the Database Specialist take to secure the cache data and protect it from unauthorized access? (Choose three.)
- A. Create an IAM policy to allow the application service roles to access all ElastiCache API actions.
- B. Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.
- C. Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.
- D. Ensure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22 traffic from the trusted ElastiCache cluster's security group.
- E. Enable in-transit and at-rest encryption on the ElastiCache cluster.
- F. Ensure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound traffic on TCP port 6379 from trusted clients only.
Answer: B,D,E
NEW QUESTION 102
A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company's migration to AWS.
Which MySQL database option would meet these requirements?
- A. Amazon Aurora MySQL cluster
- B. Amazon Aurora Serverless MySQL cluster
- C. Amazon RDS for MySQL with read replica
- D. Amazon RDS for MySQL with Multi-AZ
Answer: A
NEW QUESTION 103
A company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ. The database supports an ecommerce website that runs continuously. The company can only provide a maintenance window of up to 5 minutes.
Which solution will meet these requirements?
- A. Configure AWS DataSync with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.
- B. Export the Oracle database from the EC2 instance using Oracle Data Pump and perform an import into Amazon RDS. Stop the application for the entire process. When the import is complete, change the database connection string and then restart the application.
- C. Configure AWS DMS with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.
- D. Configure Oracle Real Application Clusters (RAC) on the EC2 instance and the RDS DB instance. Update the connection string to point to the RAC cluster. Once the EC2 instance and RDS DB instance are in sync, fail over from Amazon EC2 to Amazon RDS.
Answer: B
NEW QUESTION 104
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. Enable a read replicas and direct read traffic to it when Amazon RDS is down
- B. Enable an Amazon RDS for MySQL Multi-AZ configuration
- C. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
- D. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
Answer: A
NEW QUESTION 105
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. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to bedeleted
- B. Create a ticket with AWS Support to have the logs deleted
- C. Log in to the host and run the rm $PGDATA/pg_logs/* command
- D. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs
Answer: A
NEW QUESTION 106
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 Auror a. Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?
- A. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.
- B. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
- C. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
- D. Provision a clone of the existing DB cluster for the new Application team.
Answer: C
NEW QUESTION 107
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?
- A. Use the AWS CLI to stop each read replica and source instance at the same time
- B. Stop the source instances before stopping their read replicas
- C. Stop the read replicas before stopping their source instances
- D. Delete each read replica before stopping its corresponding source instance
Answer: A
NEW QUESTION 108
A company is about to launch a new product, and test databases must be re-created from production dat a. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.
What should the Database Specialist do to meet these requirements?
- A. Restore a snapshot from the production cluster into test clusters
- B. Add an additional read replica to the production cluster and use that node for testing
- C. Use database cloning to create clones of the production cluster
- D. Create logical dumps of the production cluster and restore them into new test clusters
Answer: B
NEW QUESTION 109
......
Dumps Real Amazon AWS-Certified-Database-Specialty Exam Questions [Updated 2021]: https://www.dumpexam.com/AWS-Certified-Database-Specialty-valid-torrent.html
Prepare AWS-Certified-Database-Specialty Question Answers Free Update With 100% Exam Passing Guarantee [2021]: https://drive.google.com/open?id=1RVjr_PlX7Yt2LRlixnaIPsGEQ6imWyf6
