The Abreast Of The Times Guide To DBS-C01 Free Dumps

NEW QUESTION 1
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 global secondary index with game_id as the partition key
• B. Create a global secondary index with user_id as the partition key
• C. Create a composite primary key with game_id as the partition key and user_id as the sort key
• D. Create a composite primary key with user_id as the partition key and game_id as the sort key

Answer: B

NEW QUESTION 2
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 value
• B. Then, create the secret with the user name and password set to the same default value
• C. Add a Secret Target Attachment resource with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the databas
• D. Finally, update the secret’s password value with a randomly generated string set by the GenerateSecretString property.
• E. Add a Mapping property from the database Amazon Resource Name (ARN) to the secret AR
• F. Then, create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString propert
• G. Add the database with the MasterUserName and MasterUserPassword properties set to the user name of the secret.
• H. Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property.Then, define the database user name in the SecureStringTemplate templat
• I. Create a resource for the database and reference the secret string for the MasterUserName and MasterUserPassword propertie
• J. 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.
• K. Create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString propert
• L. 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 AR
• M. Then, create a database with the MasterUserName and MasterUserPassword properties set to the previously created values in the secret.

Answer: C

NEW QUESTION 3
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 reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

• 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.

Answer: A

NEW QUESTION 4
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. Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
• C. Edit and enable Aurora DB cluster cache management in parameter groups.
• D. Set TCP keepalive parameters to a high value.
• E. Set JDBC connection string timeout variables to a low value.
• F. Set Java DNS caching timeouts to a high value.

Answer: ABC

NEW QUESTION 5
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. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp).Rundata transformations in AWS Glu
• B. Load the data from the S3 bucket to the Aurora DB cluster.
• C. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball applianc
• D. Once theSnowball data is delivered to Amazon S3, create a new Aurora DB cluste
• E. Enable the S3 integration tomigrate the data directly from Amazon S3 to Amazon RDS.
• F. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during theschema migratio
• G. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
• H. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an AmazonEC2 instanc
• I. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to anAurora DB cluster.

Answer: D

NEW QUESTION 6
A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:
ERROR: cloud not write block 7507718 of temporary file: No space left on device
What 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 loadin
• B. The Database Specialist needs tomodify the workload to load the data slowly.
• C. The scaling of Aurora storage cannot catch up with the data loadin
• D. The Database Specialist needs toenable Aurora storage scaling.
• E. The local storage used to store temporary tables is ful
• F. The Database Specialist needs to scale up theinstance.
• G. The local storage used to store temporary tables is ful
• H. The Database Specialist needs to enable localstorage scaling.

Answer: C

NEW QUESTION 7
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 templat
• C. Replace the hard-codedvalues with calls to the Ref intrinsic function, referencing the new parameters.
• D. Add values for the rcuCount and wcuCount parameters as outputs of the templat
• E. Configure DynamoDBto provision throughput capacity using the stack outputs.
• F. 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.

Answer: B

NEW QUESTION 8
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. Deploy multiple read replicas and have the team members make changes to separate replica instances
• 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. Enable the Amazon RDS for MySQL Backtrack feature

Answer: A

NEW QUESTION 9
A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users.
Which solution meets these requirements?

• A. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
• B. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
• C. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
• D. Use Amazon Neptune for storage

Answer: A

NEW QUESTION 10
A company with branch offices in Portland, New York, and Singapore has a three-tier web application that leverages a shared database. The database runs on Amazon RDS for MySQL and is hosted in the us-west-2 Region. The application has a distributed front end deployed in the us-west-2, ap-southheast-1, and us-east-2 Regions.
This front end is used as a dashboard for Sales Managers in each branch office to see current sales statistics. There are complaints that the dashboard performs more slowly in the Singapore location than it does in Portland or New York. A solution is needed to provide consistent performance for all users in each location.
Which set of actions will meet these requirements?

• A. Take a snapshot of the instance in the us-west-2 Regio
• B. Create a new instance from the snapshot in the ap-southeast-1 Regio
• C. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
• D. Create an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the uswest- 2 Regio
• E. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
• F. Create a new RDS instance in the ap-southeast-1 Regio
• G. Use AWS DMS and change data capture (CDC) to update the new instance in the ap-southeast-1 Regio
• H. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
• I. Create an RDS read replica in the us-west-2 Region where the primary instance reside
• J. Create a read replica in the ap-southeast-1 Region from the read replica located on the us-west-2 Regio
• K. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.

Answer: A

NEW QUESTION 11
A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed. This solution also needs to handle a fluctuating number incoming queries. Storage costs for the 100 TB of data must be kept low. Which solution meets these requirements?

• A. Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storag
• B. Provision enough instances to support high demand.
• C. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
• D. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
• E. Provision enough instances to support high demand.
• F. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
• G. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
• H. Enable Amazon Redshift Concurrency Scaling.
• I. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent dat
• J. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum laye
• K. Leverage Amazon Redshift elastic resize.

Answer: C

NEW QUESTION 12
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 instancesto 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

Answer: A

NEW QUESTION 13
A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. The Database Specialist receives the following error:
“Unable to connect to s3 endpoint. Provided source = s3://mybucket/graphdata/ and region = us-east-1. Please verify your S3 configuration.”
Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)

• A. Check that Amazon S3 has an IAM role granting read access to Neptune
• B. Check that an Amazon S3 VPC endpoint exists
• C. Check that a Neptune VPC endpoint exists
• D. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
• E. Check that Neptune has an IAM role granting read access to Amazon S3

Answer: BD

NEW QUESTION 14
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.cnf file for the DB cluster to increase max_connections
• B. Increase the instance size of the DB cluster
• C. Change the DB cluster to Multi-AZ
• D. Increase the number of Aurora Replicas

Answer: B

NEW QUESTION 15
A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.
What should the company do to achieve this in the shortest amount of time?

• A. Use a blue-green deployment with a complete application-level failover test
• B. Use the RDS console to reboot the DB instance by choosing the option to reboot with failover
• C. Use RDS fault injection queries to simulate the primary node failure
• D. Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone

Answer: C

NEW QUESTION 16
An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.
Which settings will meet this requirement? (Choose three.)

• A. Set DeletionProtection to True
• B. Set MultiAZ to True
• C. Set TerminationProtection to True
• D. Set DeleteAutomatedBackups to False
• E. Set DeletionPolicy to Delete
• F. Set DeletionPolicy to Retain

Answer: ACF

NEW QUESTION 17
A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions.
Which solution would meet these requirements and deploy the DynamoDB tables?

• A. Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
• B. Create an AWS CloudFormation template and deploy the template to all the Regions.
• C. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
• D. Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-bystep guide for future deployments.

Answer: B

NEW QUESTION 18
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 be taken to troubleshoot this issue?

• 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

Answer: B

NEW QUESTION 19
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. Allow all users to restore a database from a backup that will reduce the overall downtime to restore thedatabase
• C. Enable multi-factor authentication for sensitive operations to access sensitive resources and APIoperations
• 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

Answer: ACD

NEW QUESTION 20
A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?

• A. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
• B. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
• C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
• D. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Answer: A

NEW QUESTION 21
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

Answer: AD

NEW QUESTION 22
......