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