Question 1

Which database professional primarily focuses on system administration such as installation, performance, and maintenance?

Accepted Answer

A) application DBA 
B) product manager 
C) system DBA 
D) data operations manager 
A) application DBA 
B) product manager 
C) system DBA 
D) data operations manager C

Question 2

The hardware, software, and database that users and regular applications of the company use is called the _____.

Accepted Answer

A) production system 
B) test system 
C) sandbox 
D) cold site 
A) production system 
B) test system 
C) sandbox 
D) cold site A

Question 3

Describe the role of the data scientist in an organization, including technology businesses.

Accepted Answer

A data scientist analyzes massive sets of data. A senior data scientist often has an entire department of data scientists that know how to model, interpret, and present insights from volumes of internal, external, and big data. In technology businesses, data scientists often conduct infrastructure testing to plan for future optimization of hardware, software, massive datasets, and networks.

Question 4

What do you call the log of all database maintenance, with information such as dates, license keys, and issues or updates?

Accepted Answer

A) archive 
B) cloud backup 
C) data warehouse 
D) run-book 
A) archive 
B) cloud backup 
C) data warehouse 
D) run-book

Question 5

_____ is an open source distributed processing framework for managing and processing very large sets of data.

Accepted Answer

A) GLAPPR 
B) Hadoop 
C) Python 
D) SQL Server 
A) GLAPPR 
B) Hadoop 
C) Python 
D) SQL Server

Question 6

A(n) _____ analyzes massive sets of internal, external, and big data to help an organization make faster and better decisions.

Accepted Answer

A) data visualizer 
B) data scientist 
C) system DBA 
D) application DBA 
A) data visualizer 
B) data scientist 
C) system DBA 
D) application DBA

Question 7

The database architect focuses on database design.

Accepted Answer

A) True 
 B)False

Question 8

The primary task of a database administrator (DBA) is to ensure that a database is available as needed and is protected and secured from unauthorized users and activities.

Accepted Answer

A) True 
 B)False

Question 9

_____ is a large set of nontraditional data that may be used to gain meaningful business insights or predict significant business events.

Accepted Answer

A) A virtual sandbox 
B) Hot data 
C) Big data 
D) Business intelligence 
A) A virtual sandbox 
B) Hot data 
C) Big data 
D) Business intelligence

Question 10

Which of the following SQL statements rescinds privileges for user kchen05 to create constraints and delete data in the Customers table?

Accepted Answer

A) REVOKE ALL ON Customers TO kchen05; 
B) REVOKE CONSTRAINTS, DELETE ON Customers TO kchen05; 
C) REVOKE REFERENCES, DELETE ON Customers TO kchen05; 
D) RESCIND REFERENCES, DELETE ON Customers TO kchen05; 
A) REVOKE ALL ON Customers TO kchen05; 
B) REVOKE CONSTRAINTS, DELETE ON Customers TO kchen05; 
C) REVOKE REFERENCES, DELETE ON Customers TO kchen05; 
D) RESCIND REFERENCES, DELETE ON Customers TO kchen05;

Question 11

Describe what a data visualization expert does to support an organization's efforts.

Accepted Answer

A data visualization expert works with d

Question 12

Which of the following is one of the most identifiable entry-level database industry job titles?

Accepted Answer

A) chief security officer 
B) data analyst 
C) application DBA 
D) data visualization expert 
A) chief security officer 
B) data analyst 
C) application DBA 
D) data visualization expert

Question 13

Which of the following is not a typical qualification for a data scientist?

Accepted Answer

A) strong data modeling skills 
B) experience with big data technologies 
C) data visualization skills 
D) advanced degree in computer science 
A) strong data modeling skills 
B) experience with big data technologies 
C) data visualization skills 
D) advanced degree in computer science

Question 14

What do organizations install to detect and stop cyberattack threats at the point of attack?

Accepted Answer

A) backup protocols 
B) disaster recovery plans 
C) biometric technologies 
D) spyware/malware detection software 
A) backup protocols 
B) disaster recovery plans 
C) biometric technologies 
D) spyware/malware detection software

Question 15

A _____ is a duplicate instance of a single, shared database to balance the workload among CPUs.

Accepted Answer

A) parallel database system 
B) sandbox 
C) test system 
D) archived database system 
A) parallel database system 
B) sandbox 
C) test system 
D) archived database system

Question 16

Which of the following database professionals uses programming algorithms and applies statistics to analyze large sets of data?

Accepted Answer

A) data entry technician 
B) data scientist 
C) application DBA 
D) data modeler 
A) data entry technician 
B) data scientist 
C) application DBA 
D) data modeler

Question 17

Data scientists look for patterns and trends in data to discover new opportunities and solutions.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is not one of the top five database certifications?

Accepted Answer

A) MySQL Certified Database Analyst 
B) IBM Certified Database Administrator-DB2 
C) Oracle Certified Professional, MySQL Database Administrator 
D) Microsoft SQL Server database certification 
A) MySQL Certified Database Analyst 
B) IBM Certified Database Administrator-DB2 
C) Oracle Certified Professional, MySQL Database Administrator 
D) Microsoft SQL Server database certification

Question 19

Which of the following laws does not govern data access, retention, and destruction?

Accepted Answer

A) Sarbanes-Oxley (SOX) Action 
B) Hatch Act 
C) Health Insurance Portability and Accountability Act (HIPA
A)  
D) Presidential Records Act 
A) Sarbanes-Oxley (SOX) Action 
B) Hatch Act 
C) Health Insurance Portability and Accountability Act (HIPA
A)  
D) Presidential Records Act

Question 20

Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.

Accepted Answer

To protect against local hard drive fail

Which database professional primarily focuses on system administration such as installation, performance, and maintenance?

The hardware, software, and database that users and regular applications of the company use is called the _____.

Describe the role of the data scientist in an organization, including technology businesses.

What do you call the log of all database maintenance, with information such as dates, license keys, and issues or updates?

_____ is an open source distributed processing framework for managing and processing very large sets of data.

A(n) _____ analyzes massive sets of internal, external, and big data to help an organization make faster and better decisions.

The database architect focuses on database design.

The primary task of a database administrator (DBA) is to ensure that a database is available as needed and is protected and secured from unauthorized users and activities.

_____ is a large set of nontraditional data that may be used to gain meaningful business insights or predict significant business events.

Which of the following SQL statements rescinds privileges for user kchen05 to create constraints and delete data in the Customers table?

Describe what a data visualization expert does to support an organization's efforts.

Which of the following is one of the most identifiable entry-level database industry job titles?

Which of the following is not a typical qualification for a data scientist?

What do organizations install to detect and stop cyberattack threats at the point of attack?

A _____ is a duplicate instance of a single, shared database to balance the workload among CPUs.

Which of the following database professionals uses programming algorithms and applies statistics to analyze large sets of data?

Data scientists look for patterns and trends in data to discover new opportunities and solutions.

Which of the following is not one of the top five database certifications?

Which of the following laws does not govern data access, retention, and destruction?

Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.

Introduction to Database Management

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters

Exam 2: The Relational Model: Introduction, Qbe, and Relational Algebra

Which database professional primarily focuses on system administration such as installation, performance, and maintenance?

The hardware, software, and database that users and regular applications of the company use is called the _____.

Describe the role of the data scientist in an organization, including technology businesses.

What do you call the log of all database maintenance, with information such as dates, license keys, and issues or updates?

_____ is an open source distributed processing framework for managing and processing very large sets of data.

A(n) _____ analyzes massive sets of internal, external, and big data to help an organization make faster and better decisions.

The database architect focuses on database design.

The primary task of a database administrator (DBA) is to ensure that a database is available as needed and is protected and secured from unauthorized users and activities.

_____ is a large set of nontraditional data that may be used to gain meaningful business insights or predict significant business events.

Which of the following SQL statements rescinds privileges for user kchen05 to create constraints and delete data in the Customers table?

Describe what a data visualization expert does to support an organization's efforts.

Which of the following is one of the most identifiable entry-level database industry job titles?

Which of the following is not a typical qualification for a data scientist?

What do organizations install to detect and stop cyberattack threats at the point of attack?

A _____ is a duplicate instance of a single, shared database to balance the workload among CPUs.

Which of the following database professionals uses programming algorithms and applies statistics to analyze large sets of data?

Data scientists look for patterns and trends in data to discover new opportunities and solutions.

Which of the following is not one of the top five database certifications?

Which of the following laws does not govern data access, retention, and destruction?

Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.

Introduction to Database Management

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters