ch8

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

Big data

Compare traditional database careers with new emerging database careers.

In traditional database careers you were involved in designing the database, now in new emerging careers the databases are likely already designed.

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

Organizations set up a disaster recovery plan and archive the data so their are back ups.

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 DBA's role with regard to access privileges?

The DBA decides who to give access privileges to using GRANT

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

The role of data scientists in an organization is to analyze large sets of data.

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

They are able to create charts and graphs so people can better understand and visualize the data.

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

True

The database architect focuses on database design. T/F

True

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. T/F

True

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

Tuning

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

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 uses programming algorithms and applies statistics to analyze large sets of data?

data scientist

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

data scientist

Which of the following is a relatively new career in the database industry?

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 is not a major category of responsibility for typical database administrators?

data-entry management

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

database analyst

Which of the following is not a typical area that a database operations manager focuses on?

database performance

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

direct contact with customers

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.

disaster recovery plan

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

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

spyware/malware detection software

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

spyware/malware detection software (SMDS)

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

statistician

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

strong graphic design skills

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

system DBA

What acronym refers to the traditional business operations of general ledger, accounts payable, and payroll ?

GLAPPR

Which of the following SQL statements allows a user named mgarcia to select, insert, update, delete, and create a constraint in the Products table?

GRANT ALL ON Products TO mgarcia;

Data visualization is not a feature of which software product ?

Hadoop

Which of the following is not a programming language commonly used by data scientists?

Hadoop

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

Hadoop

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

Hatch Act

_____ represents information in the form of a chart, diagram, or picture.

Data visualization

A data analyst is generally responsible for improving the performance of a database T/F

False

A database administrator (DBA) usually reports directly to the chief financial officer (CFO). T/F

False

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

MySQL Certified Database Analyst