Login with Google
AWS Practitioner Chapter 09
Questions from the book AWS Certified Cloud Practitioner Study Guide by Ben Piper and David Clinton.
1.- Which type of database stores data in columns and rows?
1.
Nonrelational
2.
Relational
3.
Key-value store
4.
Document
2.- Which of the following Structured Query Language (SQL) statements can you use to write data to a relational database table?
1.
CREATE
2.
INSERT
3.
QUERY
4.
WRITE
3.- Which of the following statements is true regarding nonrelational databases?
1.
You can create only one table.
2.
No primary key is required.
3.
You can’t store data with a fixed structure.
4.
You don’t have to define all the types of data that a table can store before adding data to it.
4.- What is a no-SQL database?
1.
A nonrelational database without primary keys
2.
A schemaless relational database
3.
A schemaless nonrelational database
4.
A relational database with primary keys
5.- What do new Relational Database Service (RDS) instances use for database storage?
1.
Instance volumes
2.
Elastic Block Store (EBS) volumes
3.
Snapshots
4.
Magnetic storage
6.- Which of the following are database engine options for Amazon Relational Database Service (RDS)? (Select TWO.)
1.
IBM dBase
2.
PostgreSQL
3.
DynamoDB
4.
Amazon Aurora
5.
Redis
7.- What two databases is Amazon Aurora compatible with? (Select TWO.)
1.
MySQL
2.
PostgreSQL
3.
MariaDB
4.
Oracle
5.
Microsoft SQL Server
8.- Which of the following features of Relational Database Service (RDS) can prevent data loss in the event of an Availability Zone failure? (Select TWO.)
1.
Read replicas
2.
Multi-AZ
3.
Snapshots
4.
IOPS
5.
Vertical scaling
9.- Which RDS database engine offers automatically expanding database storage up to 64 TB?
1.
Microsoft SQL Server
2.
Amazon Aurora
3.
Oracle
4.
Amazon Athena
10.- Which of the following Relational Database Service (RDS) features can help you achieve a monthly availability of 99.95 percent?
1.
Multi-AZ
2.
Read replicas
3.
Point-in-time recovery
4.
Horizontal scaling
11.- What is true regarding a DynamoDB partition? (Select TWO.)
1.
It’s stored within a table.
2.
It’s backed by solid-state drives.
3.
It’s a way to uniquely identify an item in a table.
4.
It’s replicated across multiple Availability Zones.
12.- What is the minimum monthly availability for DynamoDB in a single region?
1.
99.99 percent
2.
99.95 percent
3.
99.9 percent
4.
99.0 percent
13.- Which of the following statements is true regarding a DynamoDB table?
1.
It can store only one data type.
2.
When you create a table, you must define the maximum number of items that it can store.
3.
Items in a table can have duplicate values for the primary key.
4.
Items in a table don’t have to have all the same attributes.
14.- Which configuration parameters can you adjust to improve write performance against a DynamoDB table? (Select TWO.)
1.
Decrease read capacity units (RCU)
2.
Increase read capacity units
3.
Increase write capacity units (WCU)
4.
Decrease write capacity units
5.
Enable DynamoDB Auto Scaling
15.- Which DynamoDB operation is the most read-intensive?
1.
Write
2.
Query
3.
Scan
4.
Update
16.- Which of the following would be appropriate to use for a primary key in a DynamoDB table that stores a customer list?
1.
The customer’s full name
2.
The customer’s phone number
3.
The customer’s city
4.
A randomly generated customer ID number
17.- Which type of Redshift node uses magnetic storage?
1.
Cost-optimized
2.
Dense compute
3.
Dense storage
4.
Dense memory
18.- Which Redshift feature can analyze structured data stored in S3?
1.
Redshift Spectrum
2.
Redshift S3
3.
Amazon Athena
4.
Amazon RDS
19.- What is the term for a relational database that stores large amounts of structured data from a variety of sources for reporting and analysis?
1.
Data storehouse
2.
Data warehouse
3.
Report cluster
4.
Dense storage node
20.- What’s the maximum amount of data you can store in a Redshift cluster when using dense storage nodes?
1.
2 PB
2.
326 TB
3.
2 TB
4.
326 PB
5.
236 TB
Submit the answers
