A fully updated 2024 AWS-Certified-Database-Specialty Exam Dumps exam guide from training expert ValidBraindumps [Q133-Q158]

A fully updated 2024 AWS-Certified-Database-Specialty Exam Dumps exam guide from training expert ValidBraindumps

Provides complete coverage of every objective on exam and exam preparation AWS-Certified-Database-Specialty

What Are Career Opportunities That Certified AWS Database Specialty Specialists Can Get?

Once you pass the AWS DBS-C01 test and get the AWS Certified Database Specialty certification, you will become eligible for different career opportunities, such as:

• Data Architect;
• AWS Cloud Engineer;
• Technical Support & Solutions Analyst.
• Senior Database Administrator;
• Database Developer;

If you wonder what the responsibilities of an AWS Cloud Engineer are, you should know that he/she is in charge of handling the AWS cloud platform together with developing and ensuring its proper running. In addition, such a specialist is responsible for planning, implementing, and growing AWS cloud infrastructure. Also, an AWS Cloud Engineer will release and manage different production systems configuration. Finally, he/she is responsible for implementing the continuous integration and deployment of server-based technologies.

When it comes to salaries, Payscale.com offers verified information on the average annual payment that an AWS Database Specialty certified specialist might get. For example, a Data Architect can earn around $119k on average per year. However, this salary can grow depending on the candidate's expertise. Besides, a Cloud Engineer can get about $91k per annum. But in case the specialist manages to add the AWS Certified Database Specialty certification under his/her belt, the annual salary can become higher and will equal $126k per year.

Last but not least, Payscale.com mentions that the annual payment that a Senior Database Administrator can get is a little bit more than $108k. An experienced professional can win up to $138k per annum in this position. As this is a well-paid job role, you should know that the responsibilities list of such an employee includes providing database architecture to meet the required goals of specialized software. All in all, Senior Database Administrators will deal with the maintenance, configuration, and creation of databases. This, in its turn, involves backup, storage, and access to databases.

After getting the AWS Certified Database Specialty certification, you can expand your knowledge and skills by obtaining any other database related certification.

The AWS Certified Database - Specialty (DBS-C01) certification exam is a highly sought after certification that is designed for individuals who have a deep understanding of AWS database services. AWS Certified Database - Specialty (DBS-C01) Exam certification validates the candidate’s skills and knowledge in designing, deploying, and managing AWS database solutions. AWS-Certified-Database-Specialty exam covers a broad range of AWS database services, including Amazon RDS, Amazon DynamoDB, Amazon Aurora, Amazon Redshift, and Amazon ElastiCache.

 

NEW QUESTION # 133
A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains complex T-SQL queries and stored procedures.
The company wants to minimize database server maintenance and operating costs after the migration is completed. The company also wants to minimize the need to rewrite code as part of the migration effort.
Which solution will meet these requirements?

• A. Migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.
• B. Migrate the database to Amazon S3. Use Amazon Redshift Spectrum for query processing.
• C. Migrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.
• D. Migrate the database to an Amazon EMR cluster that includes multiple primary nodes.

Answer: A

Explanation:
Explanation from Amazon documents:
Amazon Aurora PostgreSQL is a fully managed relational database service that is compatible with PostgreSQL. Aurora PostgreSQL offers up to three times better performance than standard PostgreSQL, as well as high availability, scalability, security, and durability. Aurora PostgreSQL also supports Babelfish, which is a new feature that enables Aurora to understand queries from applications written for Microsoft SQL Server. Babelfish allows you to migrate your SQL Server databases to Aurora PostgreSQL with minimal or no code changes, and run complex T-SQL queries and stored procedures on Aurora PostgreSQL.
Migrating the database to Amazon Aurora PostgreSQL and turning on Babelfish will meet the requirements of minimizing database server maintenance and operating costs, and minimizing the need to rewrite code as part of the migration effort. This solution will allow the company to benefit from the performance, reliability, and cost-efficiency of Aurora PostgreSQL, while preserving the compatibility and functionality of SQL Server.
The company will also avoid the hassle and expense of managing and licensing SQL Server on premises or on AWS.
Therefore, option A is the correct solution to meet the requirements. Option B is not suitable because Amazon S3 is an object storage service that is not designed for OLTP workloads. Amazon Redshift Spectrum is a feature that allows you to query data in S3 using Amazon Redshift, but it is not compatible with SQL Server or T-SQL. Option C is not optimal because Amazon RDS for SQL Server is a managed relational database service that supports SQL Server, but it does not offer the same performance, scalability, or cost savings as Aurora PostgreSQL. Kerberos authentication is a security feature that does not affect the migration effort or the operating costs. Option D is not suitable because Amazon EMR is a big data processing service that runs Apache Hadoop and Spark clusters, not relational databases. EMR does not support SQL Server or T-SQL, and it is not optimized for OLTP workloads.

NEW QUESTION # 134
A worldwide digital advertising corporation collects browser information in order to provide targeted visitors with contextually relevant pictures, websites, and connections. A single page load may create many events, each of which must be kept separately. A single event may have a maximum size of 200 KB and an average size of 10 KB. Each page load requires a query of the user's browsing history in order to deliver suggestions for targeted advertising. The advertising corporation anticipates daily page views of more than 1 billion from people in the United States, Europe, Hong Kong, and India. The information structure differs according to the event. Additionally, browsing information must be written and read with a very low latency to guarantee that consumers have a positive viewing experience.
Which database solution satisfies these criteria?

• A. Amazon RDS Multi-AZ deployment
• B. Amazon Aurora Global Database
• C. Amazon DynamoDB global table
• D. Amazon DocumentDB

Answer: C

NEW QUESTION # 135
The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real- time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?

• A. Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
• B. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
• C. Use pg_audit to generate audit logs and send the logs to the Security team.
• D. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.

Answer: B

Explanation:
https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-aurora-with-postgresql-compatibility-supports-database-activity-streams/
"Database Activity Streams for Amazon Aurora with PostgreSQL compatibility provides a near real-time data stream of the database activity in your relational database to help you monitor activity. When integrated with third party database activity monitoring tools, Database Activity Streams can monitor and audit database activity to provide safeguards for your database and help meet compliance and regulatory requirements."
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Overview.LoggingAndMonitoring.html

NEW QUESTION # 136
A coffee machine manufacturer is equipping all of its coffee machines with 10T sensors. The 10T core application is writing measurements for each record to Amazon Timestream. The records have multiple dimensions and measures. The measures include multiple measure names and values.
An analysis application is running queries against the Timestream database and is focusing on data from the current week. A database specialist needs to optimize the query costs of the analysis application.
Which solution will meet these requirements?

• A. Use time range, measure name, and dimensions in the WHERE clause of the query.
• B. Avoid canceling any query after the query starts running.
• C. Ensure that queries contain whole records over the relevant time range.
• D. Implement exponential backoff in the application.

Answer: A

Explanation:
Explanation
Use time range, measure name, and dimensions in the WHERE clause of the query.
Explanation from Amazon documents:
Amazon Timestream is a serverless time series database service that allows you to store and analyze time series data at any scale. To optimize the cost of queries, you should use the following best practices1:
Include only the measure and dimension names essential to query. Adding extraneous columns will increase data scans and therefore will also increase the query cost.
Include a time range in the WHERE clause of your query. For example, if you only need the last one hour of data in your dataset, include a time predicate such as time > ago (1h).
Include the measure names in the WHERE clause of the query when a query accesses a subset of measures in a table.
Option B follows these best practices, while option A does not. Option C is incorrect because canceling a query can save on cost if the query will not return the desired results1. Option D is irrelevant because exponential backoff is a technique to handle throttling errors, not to optimize query costs2.

NEW QUESTION # 137
A company has two separate AWS accounts: one for the business unit and another for corporate analytics. The company wants to replicate the business unit data stored in Amazon RDS for MySQL in us-east-1 to its corporate analytics Amazon Redshift environment in us-west-1. The company wants to use AWS DMS with Amazon RDS as the source endpoint and Amazon Redshift as the target endpoint.
Which action will allow AVS DMS to perform the replication?

• A. Configure the AWS DMS replication instance in the same account and Region as Amazon Redshift.
• B. Configure the AWS DMS replication instance in its own account and in the same Region as Amazon Redshift.
• C. Configure the AWS DMS replication instance in the same account and Region as Amazon RDS.
• D. Configure the AWS DMS replication instance in the same account as Amazon Redshift and in the same Region as Amazon RDS.

Answer: B

NEW QUESTION # 138
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. Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
• C. Ensure the table is always provisioned to meet peak needs
• D. Preprovision additional capacity for the known peaks and then reduce the capacity after the event

Answer: A

NEW QUESTION # 139
A stock market analysis firm maintains two locations: one in the us-east-1 Region and another in the eu-west-2 Region. The business want to build an AWS database solution capable of providing rapid and accurate updates.
Dashboards with advanced analytical queries are used to present data in the eu-west-2 office. Because the corporation will use these dashboards to make purchasing choices, they must have less than a second to obtain application data.
Which solution satisfies these criteria and gives the MOST CURRENT dashboard?

• A. Deploy an Amazon RDS for MySQL DB instance in us-east-1 with a read replica instance in eu-west-2.Configure the dashboard application to read from the read replica.
• B. Use an Amazon DynamoDB global table in us-east-1 with replication into eu-west-2. Use multi-active replication to ensure that updates are quickly propagated to eu-west-2.
• C. Deploy an Amazon RDS DB instance in us-east-1 with a read replica instance in eu-west-2. Create an Amazon ElastiCache cluster in eu-west-2 to cache data from the read replica to generate the dashboards.
• D. Use an Amazon Aurora global database. Deploy the primary DB cluster in us-east-1. Deploy the secondary DB cluster in eu-west-2. Configure the dashboard application to read from the secondary cluster.

Answer: D

Explanation:
Explanation
Amazon Aurora global databases span multiple AWS Regions, enabling low latency global reads and providing fast recovery from the rare outage that might affect an entire AWS Region. An Aurora global database has a primary DB cluster in one Region, and up to five secondary DB clusters in different Regions.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html

NEW QUESTION # 140
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 AWS DMS task to generate full logs to allow for 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 on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)
• D. Configure the AWS DMS connections to allow two-way communication to allow for ongoing change datacapture (CDC)

Answer: C

NEW QUESTION # 141
A database specialist at a large multi-national financial company is in charge of designing the disaster recovery strategy for a highly available application that is in development. The application uses an Amazon DynamoDB table as its data store. The application requires a recovery time objective (RTO) of 1 minute and a recovery point objective (RPO) of 2 minutes.
Which operationally efficient disaster recovery strategy should the database specialist recommend for the DynamoDB table?

• A. Create a DynamoDB stream that is processed by an AWS Lambda function that copies the data to a DynamoDB table in another Region.
• B. Use a DynamoDB global table replica in another Region. Enable point-in-time recovery for both tables.
• C. Create an AWS Backup plan and assign the DynamoDB table as a resource.
• D. Use a DynamoDB Accelerator table in another Region. Enable point-in-time recovery for the table.

Answer: D

NEW QUESTION # 142
A company is using an Amazon Aurora PostgreSQL DB cluster with an xlarge primary instance master and two large Aurora Replicas for high availability and read-only workload scaling. A failover event occurs and application performance is poor for several minutes. During this time, application servers in all Availability Zones are healthy and responding normally.
What should the company do to eliminate this application performance issue?

• A. Configure one Aurora Replica to have the same instance class as the primary DB instance. Implement Aurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DB instance and one replica with the same instance class. Set the failover priority to tier-1 for the other replicas.
• B. Configure both of the Aurora Replicas to the same instance class as the primary DB instance. Enable cache coherence on the DB cluster, set the primary DB instance failover priority to tier-0, and assign a failover priority of tier-1 to the replicas.
• C. Configure both Aurora Replicas to have the same instance class as the primary DB instance. Implement Aurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DB instance and to tier-1 for the replicas.
• D. Deploy an AWS Lambda function that calls the DescribeDBInstances action to establish which instance has failed, and then use the PromoteReadReplica operation to promote one Aurora Replica to be the primary DB instance. Configure an Amazon RDS event subscription to send a notification to an Amazon SNS topic to which the Lambda function is subscribed.

Answer: A

Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.cluster-cache-mgmt.htm
https://aws.amazon.com/blogs/database/introduction-to-aurora-postgresql-cluster-cache-management/
"You can customize the order in which your Aurora Replicas are promoted to the primary instance after a failure by assigning each replica a priority. Priorities range from 0 for the first priority to 15 for the last priority. If the primary instance fails, Amazon RDS promotes the Aurora Replica with the better priority to the new primary instance. You can modify the priority of an Aurora Replica at any time. Modifying the priority doesn't trigger a failover. More than one Aurora Replica can share the same priority, resulting in promotion tiers. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier. " Amazon Aurora with PostgreSQL compatibility now supports cluster cache management, providing a faster path to full performance if there's a failover. With cluster cache management, you designate a specific reader DB instance in your Aurora PostgreSQL cluster as the failover target. Cluster cache management keeps the data in the designated reader's cache synchronized with the data in the read-write instance's cache. If a failover occurs, the designated reader is promoted to be the new read-write instance, and workloads benefit immediately from the data in its cache.

NEW QUESTION # 143
A company has a database fleet that includes an Amazon RDS for MySQL DB instance. During an audit, the company discovered that the data that is stored on the DB instance is unencrypted.
A database specialist must enable encryption for the DB instance. The database specialist also must encrypt all connections to the DB instance.
Which combination of actions should the database specialist take to meet these requirements? (Choose three.)

• A. Enable SSH encryption on the DB instance.
• B. In the RDS console, choose "Enable encryption" to encrypt the DB instance by using an AWS Key Management Service (AWS KMS) key.
• C. Use SSL/TLS from the application to encrypt a connection to the DB instance.
• D. Require SSL connections for applicable database user accounts.
• E. Encrypt the read replica of the unencrypted DB instance by using an AWS Key Management Service (AWS KMS) key. Fail over the read replica to the primary DB instance.
• F. Create a snapshot of the unencrypted DB instance. Encrypt the snapshot by using an AWS Key Management Service (AWS KMS) key. Restore the DB instance from the encrypted snapshot. Delete the original DB instance.

Answer: B,C,F

Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html#Overview.Encryption.E

NEW QUESTION # 144
A finance company migrated its 3 on-premises PostgreSQL database to an Amazon Aurora PostgreSQL DB cluster. During a review after the migration, a database specialist discovers that the database is not encrypted at rest. The database must be encrypted at rest as soon as possible to meet security requirements. The database specialist must enable encryption for the DB cluster with minimal downtime.
Which solution will meet these requirements?

• A. Modify the unencrypted DB cluster using the AWS Management Console. Enable encryption and choose to apply the change immediately.
• B. Take a snapshot of the unencrypted DB cluster and restore it to a new DB cluster with encryption enabled. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.
• C. Create a new DB cluster with encryption enabled and use the pg_dump and pg_restore utilities to load data to the new DB cluster. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.
• D. Create an encrypted Aurora Replica of the unencrypted DB cluster. Promote the Aurora Replica as the new master.

Answer: B

Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Overview.Encryption.html

NEW QUESTION # 145
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. Delete each read replica before stopping its corresponding source instance
• B. Use the AWS CLI to stop each read replica and source instance at the same time
• C. Stop the read replicas before stopping their source instances
• D. Stop the source instances before stopping their read replicas

Answer: A

Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html
"The following are some limitations to stopping and starting a DB instance: You can't stop a DB instance that has a read replica, or that is a read replica." So if you cant stop a db with a read replica, you have to delete the read replica first to then stop it???
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.ReadReplicas.html#US

NEW QUESTION # 146
An IT consulting company wants to reduce costs when operating its development environment databases. The company's workflow creates multiple Amazon Aurora MySQL DB clusters for each development group. The Aurora DB clusters are only used for 8 hours a day. The DB clusters can then be deleted at the end of the development cycle, which lasts 2 weeks.
Which of the following provides the MOST cost-effective solution?

• A. Use the Aurora DB cloning feature. Deploy a single development and test Aurora DB instance, and create clone instances for the development groups. Delete the clones at the end of the development cycle.
• B. Use Aurora Serverless. Restore current Aurora snapshot and deploy to a serverless cluster for each development group. Enable the option to pause the compute capacity on the cluster and set an appropriate timeout.
• C. Use AWS CloudFormation templates. Deploy a stack with the DB cluster for each development group. Delete the stack at the end of the development cycle.
• D. Use Aurora Replicas. From the master automatic pause compute capacity option, create replicas for each development group, and promote each replica to master. Delete the replicas at the end of the development cycle.

Answer: A

Explanation:
Aurora Serverless is not compatible to all Aurora provisioned engine version. However, you can do clone with most engine version. Meanwhile, I also consider the performance while restoring snapshot to Aurora Serverless.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html#aurora-serverless.how-it-works.pause-resume
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.use-cases

NEW QUESTION # 147
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 using Aurora Serverless. Create 12 clones in VPC_TEST, andscript the clones to be deleted and re-created nightly.
• B. Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script thereplicas to be deleted and re-created nightly.
• C. Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases inVPC_TEST using Aurora Serverless.
• D. Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to bedeleted and re-created nightly.

Answer: D

NEW QUESTION # 148
A company has migrated a single MySQL database to Amazon Auror
a. 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. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.
• B. Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
• C. Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.
• D. Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.

Answer: D

NEW QUESTION # 149
A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process.
Recently, a change was made to an AWS::RDS::DBInstance resource in the template. The CharacterSetName property was changed to allow the application to process international text. A change set was generated using the new template, which indicated that the existing DB instance should be replaced during an upgrade.
What should a database specialist do to prevent data loss during the stack upgrade?

• A. Modify the stack policy using the aws cloudformation update-stack command and the set-stack-policy command, then make the DB resource protected.
• B. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack.
• C. Deactivate any applications that are using the DB instance. Create a snapshot of the DB instance.Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack and reactivate the applications.
• D. Create a snapshot of the DB instance. Update the stack. Restore the database to a new instance.

Answer: C

Explanation:
Explanation
To preserve your data, perform the following procedure:
1.Deactivate any applications that are using the DB instance so that there's no activity on the DB instance.
2.Create a snapshot of the DB instance. For more information about creating DB snapshots
3.If you want to restore your instance using a DB snapshot, modify the updated template with your DB instance changes and add the DBSnapshotIdentifier property with the ID of the DB snapshot that you want to use
4.Update the stack.

NEW QUESTION # 150
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. QUERY_DML
• B. CONNECT
• C. QUERY_DCL
• D. QUERY
• E. TABLE
• F. QUERY_DDL

Answer: B,C,F

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

NEW QUESTION # 151
A company is running a two-tier ecommerce 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. Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations
• C. Use policy conditions to restrict access to selective IP addresses
• D. Use AccessList Controls policy type to restrict users for database instance deletion
• E. Allow all users to restore a database from a backup that will reduce the overall downtime to restore the database
• F. Enable AWS CloudTrail logging and Enhanced Monitoring

Answer: A,B,C

Explanation:
https://aws.amazon.com/blogs/database/using-iam-multifactor-authentication-with-amazon-rds/
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/security_iam_id-based-policy-htmlhttps://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/DataDurability.html

NEW QUESTION # 152
A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server backup file is approximately 120 GB in size. The application can be down for an extended period of time to complete the migration. Connectivity between the on-premises environment and AWS can be initiated from on-premises only.
How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?

• A. Provision and configure AWS DMS. Set up replication between the on-premises SQL Server environment to replicate the database to the new production RDS instance.
• B. Back up the SQL Server database using AWS Backup. Once the backup is complete, restore the completed backup to an Amazon EC2 instance and move it to the new production RDS instance.
• C. Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Download the backup files on an Amazon EC2 instance and restore them from the EC2 instance into the new production RDS instance.
• D. Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Restore the backup files from the S3 bucket into the new production RDS instance.

Answer: D

Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html

NEW QUESTION # 153
A retail company uses Amazon Redshift Spectrum to run complex analytical queries on objects that are stored in an Amazon S3 bucket. The objects are joined with multiple dimension tables that are stored in an Amazon Redshift database. The company uses the database to create monthly and quarterly aggregated reports. Users who attempt to run queries are reporting the following error message: error: Spectrum Scan Error: Access throttled Which solution will resolve this error?

• A. Check file sizes of fact tables in Amazon S3, and look for small files. Merge the small files into larger files of at least 64 MB in size.
• B. Reduce the number of queries that users can run in parallel.
• C. Review and optimize queries that submit a large aggregation step to Redshift Spectrum.
• D. Check file sizes of fact tables in Amazon S3, and look for large files. Break up large files into smaller files of equal size between 100 MB and 1 GB

Answer: A

Explanation:
Explanation
https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html#spectrum-troubleshooting-acce
https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html
https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html#spectrum-troubleshooting-acce

NEW QUESTION # 154
Amazon Aurora MySQL is being used by an ecommerce business to migrate its main application database.
The firm is now doing OLTP stress testing using concurrent database connections. A database professional detected sluggish performance for several particular write operations during the first round of testing.
Examining the Amazon CloudWatch stats for the Aurora DB cluster revealed a CPU usage of 90%.
Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively? (Select two.)

• A. Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.
• B. Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.
• C. Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.
• D. Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.
• E. Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I/O.

Answer: A,D

Explanation:
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/rds-instance-high-cpu/
https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-slow-query/

NEW QUESTION # 155
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. Override the default uppercase format of Oracle schema by encasing object names in quotation marks during creation.
• C. Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convert-lowercase.
• D. Use the AWS Schema Conversion Tool conversion agent to convert the metadata from uppercase to lowercase.

Answer: C

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

NEW QUESTION # 156
A company runs hundreds of Microsoft SQL Server databases on Windows servers in its on-premises data center. A database specialist needs to migrate these databases to Linux on AWS.
Which combination of steps should the database specialist take to meet this requirement? (Choose three.)

• A. Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers.
• B. On the AWS Management Console, set up AWS Database Migration Service (AWS DMS) by entering details of the source SQL Server database and the destination SQL Server database on AWS. Start migration.
• C. Install AWS Systems Manager Agent on the on-premises servers. Use Systems Manager Run Command to install the Windows to Linux replatforming assistant for Microsoft SQL Server Databases.
• D. On the AWS Management Console, set up Amazon RDS for SQL Server DB instances with Linux as the operating system. Install AWS Systems Manager Agent on the DB instances by using an options group.
• E. Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.
• F. On the Amazon EC2 console, launch EC2 instances and select a Linux AMI that includes SQL Server. Install and configure AWS Systems Manager Agent on the EC2 instances.

Answer: C,E,F

Explanation:
https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/replatform-sql-server.html
https://d1.awsstatic.com/events/reinvent/2019/REPEAT_1_Leverage_automation_to_re-platform_SQL_Server_to_Linux_WIN322-R1.pdf

NEW QUESTION # 157
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. Change the DB clusters to the burstable instance family.
• C. Use existing DB clusters and stop/start the databases on a routine basis using scheduling tools.
• D. Upgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.

Answer: B

NEW QUESTION # 158
......

Tested Material Used To AWS-Certified-Database-Specialty: https://www.validbraindumps.com/AWS-Certified-Database-Specialty-exam-prep.html

Steps Necessary To Pass The AWS-Certified-Database-Specialty Exam: https://drive.google.com/open?id=1euOsOJtsE-kyzfa2Us6ztU4mOLFMzHDY