Quiz
Chapter 5 - 13 Relational Databases
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (24)
1In a relational database, a row may also be called what? (Choose two.)
- ARecord
- BAttribute
- CTuple
- DTable
2What must every relational database table contain?
- AA foreign key
- BA primary key
- CAn attribute
- DA row
3Which SQL statement would you use to retrieve data from a relational database table?
- AQUERY
- BSCAN
- CINSERT
- DSELECT
4Which relational database type is optimized to handle multiple transactions per second?
- AOffline transaction processing (OLTP)
- BOnline transaction processing (OLTP)
- COnline analytic processing (OLAP)
- DKey-value store
5How many database engines can an RDS database instance run?
- ASix
- BOne
- CTwo
- DFour
6Which database engines are compatible with existing MySQL databases? (Choose all that
apply.)- AMicrosoft SQL Server
- BMariaDB
- CAurora
- DPostgreSQL
7Which storage engine should you use with MySQL, Aurora, and MariaDB for maximum
compatibility with RDS?- AMyISAM
- BXtraDB
- CInnoDB
- DPostgreSQL
8Which database engine supports the bring-your-own-license (BYOL) model? (Choose all
that apply.)- AOracle Standard Edition Two
- BMicrosoft SQL Server
- COracle Standard Edition One
- DPostgreSQL
9Which database instance class provides dedicated bandwidth for storage volumes?
- AStandard
- BMemory optimized
- CStorage optimized
- DBurstable
10If a MariaDB database running in RDS needs to write 200 MB of data every second, how
many IOPS should you provision using io1 storage to sustain this performance?- A12,800
- B25,600
- C200
- D16
11Using general-purpose SSD storage, how much storage would you need to allocate to get
600 IOPS?- A200 GB
- B100 GB
- C200 TB
- D200 MB
12If you need to achieve 12,000 IOPS using provisioned IOPS SSD storage, how much storage
should you allocate, assuming that you need only 100 GB of storage?- AThere is no minimum storage requirement.
- B200 GB
- C240 GB
- D12 TB
13What type of database instance only accepts queries?
- ARead replica
- BStandby database instance
- CPrimary database instance
- DMaster database instance
14In a multi-AZ deployment using Oracle, how is data replicated?
- ASynchronously from the primary instance to a read replica
- BSynchronously using a cluster volume
- CAsynchronously from the primary to a standby instance
- DSynchronously from the primary to a standby instance
15Which of the following occurs when you restore a failed database instance from a
snapshot?- ARDS restores the snapshot to a new instance.
- BRDS restores the snapshot to the failed instance.
- CRDS restores only the individual databases to a new instance.
- DRDS deletes the snapshot.
16Which Redshift distribution style stores all tables on all compute nodes?
- AEVEN
- BALL
- CKEY
- DODD
17Which Redshift node type can store up to 326 TB of data?
- ADense memory
- BLeader
- CDense storage
- DDense compute
18Which is true regarding a primary key in a nonrelational database? (Choose all that apply.)
- AIt’s required to uniquely identify an item.
- BIt must be unique within the table.
- CIt’s used to correlate data across different tables.
- DIts data type can vary within a table.
19In DynamoDB table containing orders, which key would be most appropriate for storing an
order date?- APartition key
- BSort key
- CHash key
- DSimple primary key
20When creating a DynamoDB table, how many read capacity units should you provision to
be able to sustain strongly consistent reads of 11 KB per second?- A3
- B2
- C1
- D0
21Which Redshift node type can provide the fastest read access?
- ADense compute
- BDense storage
- CLeader
- DKEY
22Which DynamoDB index type allows the partition and hash key to differ from the base
table?- AEventually consistent index
- BLocal secondary index
- CGlobal primary index
- DGlobal secondary index
23To ensure the best performance, in which of the following situations would you choose to
store data in a NoSQL database instead of a relational database?- AYou need to perform a variety of complex queries against the data.
- BYou need to query data based on only one attribute.
- CYou need to store JSON documents.
- DThe data will be used by different applications.
24What type of database can discover how different items are related to each other?
- ASQL
- BRelational
- CDocument-oriented store
- DGraph
Information
- Description
- AWS (AWS - Study Book) Quiz on Chapter 5 - 13 Relational Databases, created by Fausto Trindade on 03/02/2020.
- Author
- Fausto Trindade
- Language
- Português
- Views
- 2
- Tags
- Rating
- No ratings yet Rate this quiz