Database Solutions Flashcards

1
Q

Which data types are supported when configuring a DynamoDB primary key?

Number

String

Date

Binary

Boolean

A

Number

String

Binary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which AWS offering is a NoSQL solution?

Microsoft SQL server

MySql

Dynamo DB

Aurora

A

Dynamo DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which AWS CLI command lists RDS database instances?

rds list-db-instances

rds describe-db-instances

aws rds show-db-instances

aws rds describe-db-instances

A

aws rds describe-db-instances

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

You are viewing RDS database instance properties in the AWS management console. Where should you click to view detailed CPU utilization metrics?

Configuration

Monitoring

Connectivity

Replicas

A

Monitoring

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which of the following terms is the most closely related to NoSQL databases?

Structured schema

Unstructured schema

Relational

Encryption

A

Unstructured schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which PowerShell cmdlet starts MySQL deployed through RDS?

Start-RDS

Start-MySQL

Start-RDSDBInstance

Start-MySQLDBInstance

A

Start-RDSDBInstance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What purpose does an RDS snapshot serve?

Improved performance

Reduced network latency

Backup

Replication

A

Backup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which of the following are valid storage options when deploying MySQL through RDS?

General purpose

Provisioned IOPS

Cold HDD

Magnetic

A

General purpose

Provisioned IOPS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which option is used to convert a read replica to a master?

Snapshot

Start

Promote

Restart

A

Promote

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You have deployed a DocumentDB cluster. What should you use to connect to the cluster?

PowerShell

bash shell

mongo shell

AWS CLI

A

mongo shell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly