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
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Applications
Section: Chapter Questions
Problem 5SAT
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.
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
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
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning