Data Resource Management — 35% of assessment

Question 1

When using extract, transform, and load (ETL), what is done during the “transform” step?

Answer 1

The data are normalized and structured.

Question 2

What is the key characteristic that differentiates a datamart from a data warehouse?

Answer 2

A datamart is smaller and more specialized in its focus than a data warehouse.

Question 3

A marketing employee is tasked with mailing discount coupons to the company’s top 100 customers by sales volume. The marketing employee only has lists of customers’ names, customers’ addresses, and the sales generated by each customer. Which process should this employee use to ensure coupons are mailed to the correct customers?

Answer 3

Data mining

Question 4

What is the velocity of big data?

Answer 4

The speed of data produced in a given time

Question 5

What is it called when an organization implements security procedures to protect the hardware, network, and software from intrusion?

Answer 5

System-level security

Question 6

Which term is used to refer to data that come from many different sources in various structures?

Answer 6

Disparate data

Question 7

What are scrubbed data?

Answer 7

Data that have been validated for accuracy

Question 8

When a company spends money on data management, it uses a metric to measure the benefit of this spending relative to the cost.
What is this metric called?

Answer 8

Return on investment

Question 9

One perpetual issue with corporate data is ensuring the data are accurate and valid. Procedures that apply to end users, managers, and IT personnel are often put in place to ensure good data.
What is the term that describes this effort?

Answer 9

Data governance

Question 10

Which level of management gets the most detailed reports directly from the transaction processing system?

Answer 10

Supervisors

Question 11

A large online retailer uses a decision support system (DSS) to develop scenarios for the executive team to evaluate.
What is the primary source of the data used by this DSS?

Answer 11

The transaction processing system (TPS)

Question 12

What is a key capability of a decision support system?

Answer 12

It compiles data from many systems to assist in decision-making.

Question 13

Endothon Company buys cabinet hardware from one manufacturer. Due to limited storage space for inventory, Endothon has partnered with the manufacturer to ship hardware just when it is needed.
Which component of the IT supply chain could the company set up to efficiently communicate what it needs each week?

Answer 13

An extranet that provides the manufacturer access to data at Endothon

Question 14

The IT department of a company has been asked to provide systems for financial and investment management.
Which business department has the greatest need for this type of system?

Answer 14

Accounting

Question 15

Which strategy can be used to help a company’s web page appear on the first page of search results in a browser?

Answer 15

Search engine optimization

Question 16

Which technology enables people without computer programming skills to design and publish their own websites?

Answer 16

Browser-based web development tools

Question 17

Every device on the internet has a unique numerical label that identifies it. With so many devices requiring an internet address, a new protocol has been developed that can provide unique identifiers to over 280 trillion devices.
What is the designation of this new protocol?

Answer 17

Internet Protocol version 6 (IPv6)

Question 18

A small online retailer has grown rapidly over the past year, and now during times of high activity, the retailer’s web server is nearly at capacity. The retailer anticipates continued rapid growth but is concerned that this growth may stall if the economy goes into recession.
What is an appropriate strategic planning decision for this retailer to make in order to ensure adequate server capacity?

Answer 18

Use a cloud web hosting service

Question 19

A freelance graphic designer plans to create some marketing images to use in a portfolio as samples for prospective clients.
Which action will give the graphic designer initial copyright protection of these marketing images?

Answer 19

Creating the marketing images

Question 20

A start-up software company has designed a program that uses publicly available GPS data to show the location of all city buses and trains in a large metropolitan area.
Which legal protection prohibits unethical duplication of this computer program?

Answer 20

Copyright

Question 21

An IT manager for a large organization is working on setting up a system to digitally retain all accounting records and wants to ensure that the system’s accounting record retention policies are set in accordance with federal law.
Which law should the IT manager become familiar with?

Answer 21

Sarbanes-Oxley Act

Question 22

An analyst publishes a paper on cybersecurity. In that paper, he includes several pages of a report written by another author, but he does not attribute those pages to the other author.
Which type of law prohibits this kind of unethical behavior?

Answer 22

Copyright

Question 23

Which communication technology has a range of approximately 30 feet and allows smartphones, tablets, and handheld product scanner devices to communicate with a network?

Answer 23

Bluetooth

Question 24

What is an example of an Internet of Things (IoT) device?

Answer 24

A light bulb that can be turned on or off with a smartphone

Question 25

Where does IoT data collection begin?

Answer 25

The edge

Question 26

Which type of technology can be used to monitor every product in a warehouse to enable real-time inventory tracking and updates?

Answer 26

Radio-frequency identification (RFID)

Question 27

A homeowner arrives at home in the evening. A timer has turned on an exterior light before her arrival, and the surveillance camera records her walking to the door. She unlocks the door using a mobile app, and a motion sensor turns on an interior light when she enters the house.
What is an example of Internet of Things (IoT) technology in this scenario?

Answer 27

the door lock

Question 28

How does the healthcare industry use Internet of Things (IoT) devices?

Answer 28

To monitor patients’ heart rate and oxygen levels

Question 29

A large automobile maker has added sensors to its assembly line equipment to alert managers to manufacturing anomalies via a mobile application (app) on their smartphones. This Internet of Things (IoT) system connects proprietary manufacturing components.
What is the greatest risk created by incorporating this IoT system?

Answer 29

Increased security risk

Question 30

Which approach facilitates live communication when a business has employees that are in different locations and telecommute for work?

Answer 30

Real-time communication

Question 31

A company produces a mobile app that provides recipes and cooking tutorials.
Which category of app is this?

Answer 31

Lifestyle

Question 32

Which file format is suitable to use when sharing a legal contract that requires a digital signature?

Answer 32

PDF