37. Which options are more flexible at storing data than a spreadsheet? A. database B. data warehouse C. CSV (comma separated values) Select an answer: A and C A, B, and C B and C A and B

Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Big Data
Section: Chapter Questions
Problem 15RQ
icon
Related questions
Question

37. Which options are more flexible at storing data than a spreadsheet? A. database B. data warehouse C. CSV (comma separated values)

Select an answer:

A and C

A, B, and C

B and C

A and B

 

38. An annual review of total compensation shows one total in the payroll database and a different total in the HR software. What should be your next step?

Select an answer:

Report using only the payroll database data.

Append the data from both the payroll and HR software data.

Report using only the HR software data.

Determine which system has the accurate value for total compensation (system of record).

 

39. When profiling a dataset for the first time, you note that a row is blank in the first column. What should be your first action?

Select an answer:

Keep the row.

Delete the row.

Confirm the row is empty.

Promote the headers.

 

40. Which process includes determining the volume of data, identifying basic information of the different field values, and uncovering basic transformation requirements in a data set?

Select an answer:

data transformation

data modeling

data cleaning

data profiling

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Concurrency control
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning