DBS-C01 Practice Test

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 storage. Provision enough instances to support high
demand

B.

Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most
recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum
layer. 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 data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum
layer. Enable Amazon Redshift Concurrency Scaling.

D.

Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most
recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum
layer. Leverage Amazon Redshift elastic resize

A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will
offload the administrative burdens of operating and scaling distributed databases. The solution must be
cost-effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

A.

Create an Amazon DynamoDB table with provisioned capacity mode

B.

Create an Amazon DocumentDB cluster

C.

Create an Amazon DynamoDB table with on-demand capacity mode

D.

Create an Amazon Aurora Serverless DB cluster

A retail company with its main office in New York and another office in Tokyo plans to build a database
solution on AWS. The company’s main workload consists of a mission-critical application that updates its
application data in a data store. The team at the Tokyo office is building dashboards with complex analytical
queries using the application data. The dashboards will be used to make buying decisions, so they need to have
access to the application data in less than 1 second.
Which solution meets these requirements?

A.

Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the
apnortheast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to
cacheapplication data from the replica to generate the dashboards.

B.

Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the
ap-northeast-1Region. Use Amazon QuickSight for displaying dashboard results.

C.

Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read
replicainstance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.

D.

Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the
replicain the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1
Region.

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.

Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.

B.

Modify the RDS SQL Server DB instance to use the directory for Windows authentication. Createappropriate new logins.

C.

Use the AWS Management Console to create an AWS Managed Microsoft AD. Create a trust
relationshipwith the corporate AD.

D.

Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and
startit again. Create appropriate new logins.

E.

Use the AWS Management Console to create an AD Connector. Create a trust relationship with
thecorporate AD.

F.

Configure the AWS Managed Microsoft AD domain controller Security Group.

After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect
tothe restored RDS DB instance. What is the likely cause of this problem?

A.

The restored DB instance does not have Enhanced Monitoring enabled

B.

The production DB instance is using a custom parameter group

C.

The restored DB instance is using the default security group

D.

The production DB instance is using a custom option group