Module 8

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

Hadoopv

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

Hatch Act

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

MySQL Certified Database Analyst

Which of the following is not true about the database industry?

Positions as a data analyst or data scientist continue to grow, but not other database fields.

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

REVOKE REFERENCES, DELETE ON Customers TO kchen05;

What is the primary focus of the latest emerging careers in the database industry?

analysis of internal, external, and big data

Which of the following is not a database policy area that database administrators typically are responsible for?

analyzing sales and expenses

Which of the following does a data analyst typically work with?

business transactions

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

c. data scientist

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

spyware/malware detection software (SMDS)

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.

data analyst

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

data analyst

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

data scientist

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

data scientist

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?

data visualization expert

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

data visualization skills

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

data warehousing

Which of the following database professionals most likely uses SQL to summarize and analyze data to extract trends, insights, and knowledge?

database analyst

Which of the following is typically not a requirement for a successful career as a database administrator?

direct contact with customers

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

parallel database system

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

patterns and trends

Which of the following database professionals is most likely to manage indexes?

performance analyst

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

production system

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

run-book

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

sales transactions