Amazon AWS-Certified-Database-Specialty Exam Dumps [2024] Practice Valid Exam Dumps Question [Q46-Q67]

Amazon AWS-Certified-Database-Specialty Exam Dumps [2024] Practice Valid Exam Dumps Question

AWS-Certified-Database-Specialty Dumps - Grab Out For [NEW-2024] Amazon Exam

The AWS Certified Database - Specialty certification exam is a challenging exam that requires candidates to have a strong understanding of various database technologies and their applications on AWS. AWS-Certified-Database-Specialty exam consists of multiple-choice and multiple-answer questions that test candidates' knowledge of AWS database services, database design and implementation, migration and replication, and optimization. Candidates who pass the exam can showcase their expertise in AWS database services and gain recognition as certified professionals in the industry.

The AWS Certified Database - Specialty exam covers a range of topics, including database design, migration, deployment, and optimization. In addition, candidates must demonstrate their ability to manage and monitor AWS databases, as well as troubleshoot common issues that may arise. AWS-Certified-Database-Specialty exam also covers security and compliance requirements that are specific to AWS databases.

 

NEW QUESTION # 46
A company hosts a 2 TB Oracle database in its on-premises data center. A database specialist is migrating the database from on premises to an Amazon Aurora PostgreSQL database on AWS.
The database specialist identifies a problem that relates to compatibility Oracle stores metadata in its data dictionary in uppercase, but PostgreSQL stores the metadata in lowercase. The database specialist must resolve this problem to complete the migration.
What is the MOST operationally efficient solution that meets these requirements?

• A. Use an AWS Glue job that is attached to an AWS Database Migration Service (AWS DMS) replication task to convert the metadata from uppercase to lowercase.
• B. Use the AWS Schema Conversion Tool conversion agent to convert the metadata from uppercase to lowercase.
• C. Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convert-lowercase.
• D. Override the default uppercase format of Oracle schema by encasing object names in quotation marks during creation.

Answer: C

Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/dms-mapping-oracle-postgresql/

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

• A. Use Amazon DynamoDB in on-demand capacity mode.
• B. Use an Amazon RDS DB instance. Shut down the instance once the data has been read.
• C. Use Amazon Aurora Serverless. Allow the service to spin resources up and down, as needed.
• D. Use Amazon S3 and load the data from flat files.

Answer: D

Explanation:
Explanation
https://www.sumologic.com/insight/s3-cost-optimization/
For example, for 1 GB file stored on S3 with 1 TB of storage provisioned, you are billed for 1 GB only. In a lot of other services such as Amazon EC2, Amazon Elastic Block Storage (Amazon EBS) and Amazon DynamoDB you pay for provisioned capacity. For example, in the case of Amazon EBS disk you pay for the size of 1 TB of disk even if you just save 1 GB file. This makes managing S3 cost easier than many other services including Amazon EBS and Amazon EC2. On S3 there is no risk of over-provisioning and no need to manage disk utilization.

NEW QUESTION # 48
A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime using AWS DMS. A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover. The migration must have minimal impact on the performance of the source database.
Which approach will MOST effectively meet these requirements?

• A. Use the table metrics of the AWS DMS task created for migrating the data to verify the statistics for the tables being migrated and to verify that the data definition language (DDL) statements are completed.
• B. Enable AWS DMS data validation on the task so the AWS DMS task compares the source and targetrecords, and reports any mismatches.
• C. Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigrationchecklist to make sure there are no issues with the conversion.
• D. Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.

Answer: B

NEW QUESTION # 49
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 RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days.
• B. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
  Move the snapshot to the company's Amazon S3 bucket.
• C. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
• D. Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.

Answer: B

Explanation:
Explanation
Unlike automated backups, manual snapshots aren't subject to the backup retention period. Snapshots don't expire. For very long-term backups of MariaDB, MySQL, and PostgreSQL data, we recommend exporting snapshot data to Amazon S3. If the major version of your DB engine is no longer supported, you can't restore to that version from a snapshot.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html

NEW QUESTION # 50
An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
Update scores in real time whenever a player is playing the game. Retrieve a player's score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?

• A. Create a composite primary key with game_id as the partition key and user_id as the sort key
• B. Create a global secondary index with user_id as the partition key
• C. Create a composite primary key with user_id as the partition key and game_id as the sort key
• D. Create a global secondary index with game_id as the partition key

Answer: C

Explanation:
Explanation
https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/
"EA uses the user ID as the partition key and primary key (a 1:1 modeling pattern)."
https://aws.amazon.com/blogs/database/choosing-the-right-dynamodb-partition-key/
"Partition key and sort key: Referred to as a composite primary key, this type of key is composed of two attributes. The first attribute is the partition key, and the second attribute is the sort key."

NEW QUESTION # 51
A business uses Amazon EC2 instances in VPC A to serve an internal file-sharing application. This application is supported by an Amazon ElastiCache cluster in VPC B that is peering with VPCA. The corporation migrates the instances of its applications from VPC A to VPC B. The file-sharing application is no longer able to connect to the ElastiCache cluster, as shown by the logs.
What is the best course of action for a database professional to take in order to remedy this issue?

• A. Create a second security group on the EC2 instances. Add an outbound rule to allow traffic from the ElastiCache cluster security group.
• B. Delete the ElastiCache security group. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.
• C. Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.
• D. Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.

Answer: D

Explanation:
https://docs.aws.amazon.com/vpc/latest/peering/vpc-peering-security-groups.html

NEW QUESTION # 52
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. Allow burst capacity to handle the additional load
• B. Preprovision additional capacity for the known peaks and then reduce the capacity after the event
• 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: B

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 # 53
A software company uses an Amazon RDS for MySQL Multi-AZ DB instance as a data store for its critical applications. During an application upgrade process, a database specialist runs a custom SQL script that accidentally removes some of the default permissions of the master user.
What is the MOST operationally efficient way to restore the default permissions of the master user?

• A. Use AWS Secrets Manager to modify the master user password and restart the DB instance.
• B. Create a new master user for the DB instance.
• C. Modify the DB instance and set a new master user password.
• D. Review the IAM user that owns the DB instance, and add missing permissions.

Answer: C

NEW QUESTION # 54
A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the Advanced Auditing feature in Aurora.
Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)

• A. TABLE
• B. QUERY_DCL
• C. QUERY_DDL
• D. QUERY_DML
• E. CONNECT
• F. QUERY

Answer: B,C,E

Explanation:
Explanation
Connect - logins / DCL - authorizations (grant,revoke), DDL - schema updates

NEW QUESTION # 55
A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.
What should the database specialist do to accomplish this task?

• A. Connect to the MySQL database and run the SET SESSION wait_timeout=900 command.
• B. Modify the default DB parameter group and set the wait_timeout parameter value to 900.
• C. Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DB instance.
• D. Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.

Answer: D

Explanation:
https://aws.amazon.com/fr/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-3-parameters-related-to-security-operational-manageability-and-connectivity-timeout/
"You can set parameters globally using a parameter group. Alternatively, you can set them for a particular session using the SET command." https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon-rds-for-mysql-part-1-parameters-related-to-performance/

NEW QUESTION # 56
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. Create and review a change set before applying it
• B. Export the database resources as stack outputs
• C. Define the database resources in a nested stack
• D. Set a stack policy for the database resources
• E. Review the stack drift before modifying the template

Answer: C,E

NEW QUESTION # 57
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. Restore a new DB instance from the encrypted snapshot.
• B. Restore a DB instance from the most recent automated snapshot and enable encryption.
• C. Modify the DB instance and enable encryption.
• D. Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.

Answer: A

Explanation:
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/encrypt-an-existing-amazon-rds-for-postgresql-db-instance.html You can enable encryption for an Amazon RDS DB instance when you create it, but not after it's created. However, you can add encryption to an unencrypted DB instance by creating a snapshot of your DB instance, and then creating an encrypted copy of that snapshot. You can then restore a DB instance from the encrypted snapshot to get an encrypted copy of your original DB instance. The pattern uses AWS Database Migration Service (AWS DMS) to migrate data and AWS Key Management Service (AWS KMS) for encryption.

NEW QUESTION # 58
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 these requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?

• A. Create RDS event subscriptions. Have the tracking systems subscribe to specific RDS event system notifications.
• B. Create an AWS Lambda function to trigger on AWS CloudTrail API calls. Filter on specific RDS API calls and write the output to the tracking systems.
• C. Write RDS logs to Amazon Kinesis Data Firehose. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
• D. Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RDS.
  Create an AWS Lambda function to act on these rules and write the output to the tracking systems.

Answer: A

NEW QUESTION # 59
A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to complete.
Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake.
Which approach should the Database Specialist take to reduce downtime?

• A. Enable the Amazon RDS for MySQL Backtrack feature
• B. Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot
• C. Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature
• D. Deploy multiple read replicas and have the team members make changes to separate replica instances

Answer: C

Explanation:
"Amazon Aurora, a fully-managed relational database service in AWS, is now offering a backtrack feature. With Amazon Aurora with MySQL compatibility, users can backtrack, or "rewind", a database cluster to a specific point in time, without restoring data from a backup. The backtrack process allows a point in time to be specified with one second resolution, and the rewind process typically takes minutes. This new feature facilitates developers in undoing mistakes like deleting data inappropriately or dropping the wrong table."

NEW QUESTION # 60
An internet advertising firm stores its data in an Amazon DynamoDb table. Amazon DynamoDB Streams are enabled on the table, and one of the keys has a global secondary index. The table is encrypted using a customer-managed AWS Key Management Service (AWS KMS) key.
The firm has chosen to grow worldwide and want to duplicate the database using DynamoDB global tables in a new AWS Region.
An administrator observes the following upon review:
* No role with the dynamodb: CreateGlobalTable permission exists in the account.
* An empty table with the same name exists in the new Region where replication is desired.
* A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.
Which settings will prevent you from creating a global table or replica in the new Region? (Select two.)

• A. The table is encrypted using a KMS customer managed key.
• B. DynamoDB Streams is enabled for the table.
• C. No role with the dynamodb:CreateGlobalTable permission exists in the account.
• D. An empty table with the same name exists in the Region where replication is desired.
• E. A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.

Answer: D,E

NEW QUESTION # 61
A company's database specialist disabled TLS on an Amazon DocumentDB cluster to perform benchmarking tests. A few days after this change was implemented, a database specialist trainee accidentally deleted multiple tables. The database specialist restored the database from available snapshots. An hour after restoring the cluster, the database specialist is still unable to connect to the new cluster endpoint.
What should the database specialist do to connect to the new, restored Amazon DocumentDB cluster?

• A. Configure the interface VPC endpoint and associate the new Amazon DocumentDB cluster.
• B. Change the restored cluster's parameter group to the original cluster's custom parameter group.
• C. Run the syncInstances command in AWS DataSync.
• D. Change the restored cluster's parameter group to the Amazon DocumentDB default parameter group.

Answer: B

Explanation:
You can't modify the parameter settings of the default parameter groups. You can use a DB parameter group to act as a container for engine configuration values that are applied to one or more DB instances. If you create a DB instance without specifying a DB parameter group, the DB instance uses a default DB parameter group. Each default DB parameter group contains database engine defaults and Amazon RDS system defaults. You can't modify the parameter settings of a default parameter group. Instead, you create your own parameter group where you choose your own parameter settings. Not all DB engine parameters can be changed in a parameter group that you create.

NEW QUESTION # 62
A company is launching a new Amazon RDS for MySQL Multi-AZ DB instance to be used as a data store for a custom-built application. After a series of tests with point-in-time recovery disabled, the company decides that it must have point-in-time recovery reenabled before using the DB instance to store production data.
What should a database specialist do so that point-in-time recovery can be successful?

• A. Modify the DB instance and configure a backup retention period
• B. Set up a scheduled job to create manual DB instance snapshots.
• C. Enable binary logging in the DB parameter group used by the DB instance.
• D. Modify the DB instance and enable audit logs to be pushed to Amazon CloudWatch Logs.

Answer: A

Explanation:
You can restore a DB instance to a specific point in time (PITR), creating a new DB instance. To support PITR, your DB instances must have backup retention set to a nonzero value. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-backup-sqlserver.html
https://aws.amazon.com/blogs/database/setting-up-a-binlog-server-for-amazon-rds-mysql-and-mariadb-using-mariadb-maxscale/
"After you run the command, it's okay to enable backup retention on the RDS instance by using the AWS CLI or the console. Enabling backup retention also enables binary logging."
https://aws.amazon.com/blogs/storage/point-in-time-recovery-and-continuous-backup-for-amazon-rds-with-aws-backup/

NEW QUESTION # 63
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. 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.
• B. 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.
• C. Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.
• D. Enable in-transit and at-rest encryption on the ElastiCache cluster.
• E. Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.
• F. Create an IAM policy to allow the application service roles to access all ElastiCache API actions.

Answer: B,D,E

NEW QUESTION # 64
Amazon DynamoDB global tables are being used by a business to power an online gaming game. The game is played by gamers from all around the globe. As the game became popularity, the amount of queries to DynamoDB substantially rose. Recently, gamers have complained about the game's condition being inconsistent between nations. A database professional notices that the ReplicationLatency metric for many replica tables is set to an abnormally high value.
Which strategy will resolve the issue?

• A. Configure the primary table to use DynamoDB auto scaling and the replica tables to use manually provisioned capacity.
• B. Configure all replica tables to use DynamoDB auto scaling.
• C. Configure the table-level write throughput limit service quota to a higher value.
• D. Configure a DynamoDB Accelerator (DAX) cluster on each of the replicas.

Answer: B

Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/V2globaltables_reqs_bestpractices.html

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

• A. Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.
• B. Use AWS Resource Access Manager to share the source DB instance with the destination account. Create a DB instance in the destination account using the shared resource.
• C. Create a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.
• D. Create a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.

Answer: C

NEW QUESTION # 66
An application reads and writes data to an Amazon RDS for MySQL DB instance. A new reporting dashboard needs read-only access to the database. When the application and reports are both under heavy load, the database experiences performance degradation. A database specialist needs to improve the database performance.
What should the database specialist do to meet these requirements?

• A. Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.
• B. Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.
• C. Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.
• D. Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.

Answer: D

Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

NEW QUESTION # 67
......

AWS-Certified-Database-Specialty Exam Dumps PDF Guaranteed Success with Accurate & Updated Questions: https://examtorrent.actual4test.com/AWS-Certified-Database-Specialty_examcollection.html