PETRARCA D4 SAFARI pract cap 9-11

ch.9.1.Which type of database stores data in columns and rows?

• Nonrelational

• Relational

• Key-value store

• Document

ch.9.2.Which of the following Structured Query Language (SQL) statements can you use to write data to a relational database table?

• CREATE

• INSERT

• QUERY

• WRITE

ch.9.3.Which of the following statements is true regarding nonrelational databases?

• You can create only one table.

• No primary key is required.

• You can’t store data with a fixed structure.

• You don’t have to define all the types of data that a table can store before adding data to it.

ch.9.4.What is a no-SQL database?

• A nonrelational database without primary keys

• A schemaless relational database

• A schemaless nonrelational database

• A relational database with primary keys

ch.9.5.What do new Relational Database Service (RDS) instances use for database storage?

• Instance volumes

• Elastic Block Store (EBS) volumes

• Snapshots

• Magnetic storage

ch.9.6.Which of the following are database engine options for Amazon Relational Database Service (RDS)? (Select TWO.)

• IBM dBase

• PostgreSQL

• DynamoDB

• Amazon Aurora

• Redis

ch.9.7.What two databases is Amazon Aurora compatible with? (Select TWO.)

• MySQL

• PostgreSQL

• MariaDB

• Oracle

• Microsoft SQL Server

ch.9.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.)

• Read replicas

• Multi-AZ

• Snapshots

• IOPS

• Vertical scaling

ch.9.9.Which RDS database engine offers automatically expanding database storage up to 64 TB?

• Microsoft SQL Server

• Amazon Aurora

• Oracle

• Amazon Athena

ch.9.10.Which of the following Relational Database Service (RDS) features can help you achieve a monthly availability of 99.95 percent?

• Multi-AZ

• Read replicas

• Point-in-time recovery

• Horizontal scaling