CH14 Assessment

Question 1

What consists of columns and rows of numerical or text data?

Answer 1

Relational Database

Question 2

Your database has grown over time, you need to improve query performance. What should you do? (Choose Two)

A. Perform a Database Dump
B. Create a Foreign Key
C. Create an Index for Queried Data
D. Remove Infrequently Accessed Data

Answer 2

C. Create an Index for Queried Data

D. Remove Infrequently Accessed Data

Question 3

Greg needs to remove a customer’s information completely from a table. Which command should he use?

Answer 3

DELETE (Data)

Question 4

Which of the following descriptions best describes the type of structure that stores values as blobs?

A. Key/Value Database
B. Rational Database
C. Document Database
D. Non-Relational Database

Answer 4

A. Key/Value Database

Question 5

Which unit of measurement relates to disk throughput?

Answer 5

IOPS

Question 6

What statement regarding NoSQL database is Correct? (Choose Two)

A. Each row can store different types of Data.
B. They are less scalable than relational databases.
C. Each row must store the same type of data.
D. They are more scalable than Relational Databases.

Answer 6

A. Each row can store different types of data.

D. They are more scalable than relational databases.

Question 7

You have configured a database in the headquarters office located in Houston, Texas. Users in Eastern Canada complain about slow query access to the database, while Texas users enjoy fast performance. What should you do?

A. Create an Index
B. Create a Foreign Key
C. Place a Read Replica in Eastern Canada
D. Place a Writable Replica in Eastern Canada

Answer 7

C. Place a Read Replica in Eastern Canada

Question 8

Peter is accessing a database using JDBC connection. Which of the following terms best describes that type of access he is using?

A. User Interface/Utility Access
B. Query/Report Builder
C. Direct/Manual Access
D. Programmatic Access

Answer 8

C. Direct/Manual Access

Question 9

You have created a Relational Database. Which of the following elements uniquely identifies a record in the database?

A. Schema
B. Primary Key
C. Field
D. Foreign Key

Answer 9

B. Primary Key

Question 10

An employee at your office just got married and changed their last name. Which command do you use to change their last name in the employee database?

Answer 10

UPDATE (Data)

Question 11

Which type of Database does NOT use a Rigid Schema?

Answer 11

NoSQL

Question 12

Which of the following statements most accurately describes what a Primary Key refers to?

A. Field in a Table
B. Table in a Schema
C. Schema in a Database
D. Record in a Table

Answer 12

A. Field in a Table

Question 13

You have increased the amount of RAM available for your cloud-based database instance. Which term describes this action?

Answer 13

Scaling UP

Question 14

You have increased the number of compute nodes for your cloud-based database instance. Which term describes this action?

Answer 14

Scaling OUT

Question 15

A school has a database with four TABLES, but it needs a fifth table. Which command is used to accomplish this task?

Answer 15

CREATE (Tables)

Question 16

Laura, your manager, instructs you to remove a TABLE from a database permanently. Which command should you use?

Answer 16

DROP (Table)

Question 17

Michael, an administrator, needs to add a column to an existing table. Which command should he use?

Answer 17

ALTER (Table)

Question 18

Joe creates a database. What does he need to do next to make it Usable?

Answer 18

Import Data

Question 19

A medical office needs to create a solution to manage patient records. They have about 10,000 patients and 8 staff, they want to include notes from medical professionals, emails to and from patients, and images such as x-rays. What should they create?

A. Spreadsheet
B. Relational Database
C. NON-Relational Database
D. Primary Key

Answer 19

C. NON-Relational Database

Question 20

Henry wants to understand which of his customers has purchased part number BC8. Which command should he use?

Answer 20

SELECT (Data)

Question 21

What is another term used to refer to a Field?

A. Row
B. Foreign Key
C. Column
D. Collection

Answer 21

C. Column

Question 22

A user, Ann, is granted permissions to access a database. What is this an example of?

A. Direct/Manual Access
B. Data Collection
C. Data Manipulation
D. Data Definition

Answer 22

D. Data Definition

Question 23

A database developer is working on generating queries. If the developer needs to ensure that the output of the query has data persistence, to where should the data be written?

A. CPU
B. Cache
C. SSD
D. RAM

Answer 23

C. SSD

Question 24

Rachel, a database administrator, has created a database for her website. It contains pictures of vacations that people have uploaded. In the database, pictures have associated information about who uploaded them and the date. What is this an example of?

A. Semi-Structured Data
B. Structured Data
C. Schema Definition
D. Non-Structured Data

Answer 24

A. Semi-Structured Data

Question 25

You have an address book for a small business with contact info for about 100 clients. The address book is used by 2 people. Which solution should you use to store the data? A. Relational Database B. Non-Relational Database C. Word Processing Software D. Spreadsheet

Answer 25

D. Spreadsheet