Question 1

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 DBAE) B) and D)
F) A) and D)

Question 2

What do data scientists typically look for as they analyze data?

Accepted Answer

A)   mathematical errors
B)   database performance indicators
C)   missing data
D)   patterns and trendsE) B) and C)
F) A) and C)

Question 3

A _____ completes the statistical and graphical analysis of internal data such as sales figures and operational expenses to help an organization make faster and better decisions.

Accepted Answer

A)   data archivist
B)   database operations manager
C)   task-oriented DBA
D)   data analystE) A) and B)
F) None of the above

Question 4

Which of the following is not a technology that a data warehouse administrator typically manages?

Accepted Answer

A)   business intelligence (BI) 
B)   extract, transform, load (ETL) 
C)   Online Analytical Processing (OLAP) 
D)   spyware/malware detection software (SMDS) E) None of the above
F) All of the above

Question 5

The database architect focuses on database design.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is generally not considered a source of big data?

Accepted Answer

A)   online reviews
B)   social media posts
C)   comments on blogs
D)   sales transactionsE) C) and D)
F) All of the above D

Question 7

Which of the following database professionals most likely helps others understand patterns in data in formats other than lists, summarized reports, and other statistical presentations?

Accepted Answer

A)   data scientist
B)   data visualization expert
C)   business analyst
D)   data modelerE) A) and D)
F) A) and C)

Question 8

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 siteE) B) and D)
F) B) and C)

Question 9

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;E) A) and B)
F) A) and C)

Question 10

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

Accepted Answer

A data scientist analyzes massive sets o...

Question 11

Which of the following is not a major category of responsibility for typical database administrators?

Accepted Answer

A)   database technical functions
B)   database administrative functions
C)   data-entry management
D)   database policy formation and enforcementE) A) and B)
F) A) and C)

Question 12

What is the DBA's role with regard to access privileges?

Accepted Answer

The DBA determines the access privileges...

Question 13

Which of the following database professionals would focus on how large-scale research produces better products?

Accepted Answer

A)   data archivist
B)   data visualization expert
C)   database operations manager
D)   data scientistE) None of the above
F) All of the above D

Question 14

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 certificationE) C) and D)
F) A) and B)

Question 15

A _____specifies the ongoing and emergency actions and procedures required to ensure data remains available if an event such as a cyberattack or hurricane occurs.

Accepted Answer

A)   mission-critical plan
B)   database operation plan
C)   disaster recovery plan
D)   data modeling planE) C) and D)
F) A) and C)

Question 16

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

Accepted Answer

A)   strong graphic design skills
B)   Bachelor's degree in computer science
C)   Microsoft Access and Excel skills
D)   strong SQL skillsE) None of the above
F) All of the above

Question 17

_____ the design of a database includes creating and deleting indexes, minimizing the complexity of each view, and changing the table design.

Accepted Answer

A)   Normalizing
B)   Tuning
C)   Synchronizing
D)   TestingE) A) and B)
F) A) and C)

Question 18

Which of the following is generally not considered a traditional business operation for all sizes of businesses?

Accepted Answer

A)   data warehousing
B)   billing
C)   payroll
D)   accounts receivableE) All of the above
F) None of the above A

Question 19

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-bookE) A) and C)
F) B) and C)

Question 20

Which of the following positions is a typical prerequisite for a data scientist?

Accepted Answer

A)   product manager
B)   chief information officer
C)   statistician
D)   chief security officerE) None of the above
F) A) and D)

Exam 8: Database Industry Careers

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

Correct AnswerverifiedShow Answer

What do data scientists typically look for as they analyze data?

Correct AnswerverifiedShow Answer

A _____ completes the statistical and graphical analysis of internal data such as sales figures and operational expenses to help an organization make faster and better decisions.

Correct AnswerverifiedShow Answer

Which of the following is not a technology that a data warehouse administrator typically manages?

Correct AnswerverifiedShow Answer

The database architect focuses on database design.

Correct AnswerverifiedShow Answer

Which of the following is generally not considered a source of big data?

Correct AnswerverifiedD

Which of the following database professionals most likely helps others understand patterns in data in formats other than lists, summarized reports, and other statistical presentations?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA data scientist analyzes massive sets o...View AnswerShow Answer

Which of the following is not a major category of responsibility for typical database administrators?

Correct AnswerverifiedShow Answer

What is the DBA's role with regard to access privileges?

Correct AnswerverifiedThe DBA determines the access privileges...View AnswerShow Answer

Which of the following database professionals would focus on how large-scale research produces better products?

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

A _____specifies the ongoing and emergency actions and procedures required to ensure data remains available if an event such as a cyberattack or hurricane occurs.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

_____ the design of a database includes creating and deleting indexes, minimizing the complexity of each view, and changing the table design.

Correct AnswerverifiedShow Answer

Which of the following is generally not considered a traditional business operation for all sizes of businesses?

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

Which of the following positions is a typical prerequisite for a data scientist?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data scientist analyzes massive sets o...
View Answer

Correct Answer
verified

Correct Answer
verified
The DBA determines the access privileges...
View Answer

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified