QUESTION 1

1. What is a relational database? Select the best answer from the following.

   		Any organized list that contains data is technically a relational database.
   		An organized collection of structured data, and information about relationships.
   		A collection of information stored in a central repository that can be queried.
   		Any system that can process online transactions (OLTP).

QUESTION 2

1. Relational Databases are designed for what specific kind of processing? Select the best answer from the following.

   		Online Transaction Processing (OLTP)
   		Service Oriented Architecture (SOA)
   		Data warehousing.
   		Stream data processing.

QUESTION 3

1. How should the components within Service Oriented Architecture be viewed? Select the best answer from the following.

   		Hardware.
   		Services.
   		Custom developed software.
   		Tasks.

QUESTION 4

1. In a web database architecture what is the primary concern? Select the best answer from the following.

   		Hardware.
   		Services.
   		Software.
   		Security.
   		Elasticity.

QUESTION 5

1. What is a DBMS? Select the best answer from the following.

   		A DBMS serves as an intermediary between applications that use a database and open-source database technologies.
   		DBMS is an outdated term used to refer to database technology before the advancement of relational database management systems.
   		A DBMS is any program or application that has a relational database as its backend.
   		A DBMS is a collection of programs enabling users to access databases, manipulate data, and present data.

QUESTION 6

1. Who determines what data needs to be secured to maintain privacy? Select the best answer from the following.

   		Only the owner of the data, which typically is a company.
   		The Government determines rules about security and privacy that all companies are required to follow.
   		This is an issue that depends on where the data is stored. If the data is stored on a companys on-premise system, then the company decides. If, however, the data is stored in the cloud then the cloud vendor must follow the laws based on where their hardware is located.
   		This is an issue that depends on the data itself. Depending on the data, government regulations might impact what a company otherwise would do to secure their data.

QUESTION 7

1. What is a legacy database? Select the best answer from the following.

   		Any database with data from the time the company started its operations.
   		A database containing historical data.
   		A database that predates the relational model or any system that predates current technology.
   		A database that remains on-premise after the latest version has been moved to the cloud.

QUESTION 8

1. Which of the following are open source relational databases. Select all answers that apply.

   		Microsoft SQL Server.
   		MySQL.
   		Oracle.
   		PostgreSQL.
   		DynamoDB.

QUESTION 9

1. The work of systems analysis includes all of the following except which one answer? Select the one answer that is not related to the work of systems analysis.

   		Systems analysis helps to ensure the database design reflects the needs of the organization.
   		Systems analysis helps in understanding the environment in which the database will be deployed.
   		Systems analysis helps to ensure everyone in the organization understands the technical design of the database.
   		Systems analysis helps in knowing how the end product should work.

QUESTION 10

1. Which of the following are tools are used in conducting needs assessments? Select all answers that apply.

   		Observation.
   		Interviews.
   		Agile.
   		Questionnaires.

QUESTION 11

1. What is a meaningful identifier? Select the best answer from the following.

   		This generally is a key where the value of the key carries implicit meaning.
   		This generally is a key that contains sensitive information that needs to be protected.
   		This is a key that will never be changed because the information it contains must never be lost.
   		This is a key that contains data that is easy to remember.