IT EXAM ONE REVIEW QUESTIONS

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Why were data warehouses created?

-Numbers and type of operational databases increased as businesses grew -many companies had information scattered across multiple systems with different formats -completing reporting requests from numerous operational systems took days or weeks

_________ are unique in that they can create a three-dimensional object made of various materials.

3D Printer

Which of the following is NOT an office suite?

Adobe Creative

which of the following occurs during data cleansing? -clean missing records -clean redundant records -clean inaccurate data

All of these

Which of the following products would you choose if you wanted to edit videos?

Apple Final Cut Pro

Both fingerprint scanners and facial recognition are examples of

Biometrics

The most fundamental unit of computing is the __________ , which is typically represented as a 1 or a 0.

Bit

Which optical disc typically holds 25 GB or 50 GB of data?

Blu-ray

You are shopping for a new computer online. The description lists the following: "Intel i73630QM." What part of the computer does that refer to?

CPU

the primary purpose of a data warehouse is to ________________.

Combine strategic information

which of the following is an example of an external database in the data warehouse model?

Competitor information

The quality of a printer's output is measured in:

DPI Dots per inch

If you want to know the maximum number of pixels that a monitor can display on the screen, you would look at its:

DPI-Resolution

______ occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Data gap analysis

________includes the tests and validations used to determine compliance with data governance policies to ensure correctness of data.

Data governance

what is the ultimate outcome of a data warehouse?

Data marts

Recording the same piece of information in multiple places is called

Data redundancy

________ is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Data stewardship

_______ maintains information about various types of objects, events, people, and places

Database

The ability to automatically print to both sides of a piece of paper is known as __________ .

Duplexing

Which type of printer should you purchase if your company needs to print employee ID cards?

Dye-sub

Which type of keyboard is designed to be comfortable and help reduce the chance of hand and wrist strain?

Ergonomic

Which of the following is NOT a popular computer programming language?

Exchange

Application software is made for the computer's proper operation, while system software aims to make users more productive

F

Because of their high speeds and the sharp-looking text they produce, dot matrix printers are preferred by modern businesses.

F

Database has only one logical view but supports multiple physical views

F

Managers in sales, marketing, human resources, and management do not need information to run their departments and make daily decisions

F

One gigabyte is larger than one terabyte.

F

One primary goal of a database is to record each piece of information in multiple places in the database

F

Organizations need to capture and store analytical information to perform operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules.

F

The most popular format for file compression is known as CRM

F

The network is the most prevalent data models for organizing information.

F

Transactional information is useful when making important decisions such as whether the organization should build a new manufacturing plant or hire additional sales personal.

F

Transactional information makes it possible to do many things that previously were difficulty to accomplish, such as spot business trends, prevent diseases, and fight crime.

F

Data warehouses struggle with combining too much standardized information

False

according to Gartner Inc., dirty data is a MIS problem, not a business problem

False

the complete removal of dirty data from a source is practical and possible

False

A data warehouse is a central location in which data is stored and managed

False - a data warehouse is a collection of data from a variety of sources used to support decision making applications and general business intelligence

The primary purpose of a data warehouse is to perform transactional processes

False - analytical

A data miner contains a subset of data warehouse information

False - data mart

ETL, within a data warehouse model, stands for exit, track, and load

False - extraction, transformation, and loading

One of the following is NOT one of the advantages of rational database

Increase information redundancy

Which one of the following is NOT one of the four traits of information?

Information granularity

_____refers to the extent of details within the information (fine and detailed or coarse and abstract)

Information Granularity

Occurs when the same data element has different values.

Information inconsistency

_______is a measure of the quality of information

Information integrity

Which one of the following is one of the four traits of information?

Information quality

what is extraction, transformation, and loading?

It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse

A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.

Logical, Operational

The __________ is the largest circuit board in a personal computer.

Motherboard

__________ combine either inkjet or laser printing capabilities with scanning, photocopying, and faxing capabilities.

Multifunction

A technology known as __________ can translate the image of a scanned document into text that can be edited and formatted.

OCR- Optical Character Recognition

what do data warehouses support?

OLAP and analytical processing

Which of the following is incorrect in terms of data warehousing and business intelligence? Information from other operational applications is not included Operational systems are integrated Operational information is mainly current Operational information frequently has quality issues

Operational systems are integrated

Which of the following is a DBMS (Database management system) that you might find a large business using?

Oracle

A(n) __________ is software designed to keep individuals organized.

PIM (Personal Information Manangement)

The USB __________ is the most popular type of plug found on desktop and laptop computers.

Port

__________ is the temporary workspace of a computer. It stores the content you are currently working on.

Ram - Random Access Memory

________stores information in the form of logically related two- dimensional table

Rational database model

Which type of software is used for entering, calculating, and analyzing sets of numbers, as well as creating graphs and charts?

Spreadsheet

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ___________.

Standardizing information

The __________ of a desktop computer is the case that houses the computer's critical parts, such as the processing and storage devices.

System Unit

A programmer or software company will often release a beta version in order to test software in real-world conditions.

T

Analytical information is useful when making important decisions such as whether the organization should build a new manufacturing plant or hire additional sales personal.

T

Analytical information makes it possible to do many things that previously were difficulty to accomplish, such as spot business trends, prevent diseases, and fight crime.

T

Data integrity issues can cause managers to consider the system reports invalid and will, make decisions based on other sources.

T

Data stewardship is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS and the business

T

Erroneous decisions can cost time, money, reputations, and even jobs.

T

In some firms or industries, information that is a few days or weeks old can be relevant, while in others information that is a few minutes old can be almost worthless.

T

In some operating systems, folders may be referred to as directories.

T

Information can tell an organization how its current operations are performing and help it estimate and strategize about how future operations might perform

T

Managers typically interact with QBE tools, and MIS professionals have the skills required to code SQL

T

Modern ROM chips can be electronically reprogrammed.

T

Organizations need to capture and store transactional information to perform operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules.

T

The rational database is the most prevalent data models for organizing information.

T

With a subscription model, users pay a fixed amount of money per month in order to use software.

T

With speech recognition, it is possible to issue commands and search for information by speaking into your mobile device.

T

Without proper cooling, a computer could overheat and malfunction.

T

A(n) __________ is a device that can capture television signals for viewing on a computer.

TV tuner

__________ is the primary storage device of a personal computer.

The hard drive

which of the following statement is true? - the more complete an organization wants its information to be, the less it costs -the more accurate an organization wants its information to be, the less it costs -the less accurate an organization wants its information to be, the more It costs -the more complete and accurate an organization wants its information to be, the more it costs

The more complete and accurate an organization wants its information to be, the more it costs

Which of the following is a pointing device that can be useful if you have very limited space on your desk?

Trackball

One of the following is NOT one of the five characteristics of high-quality information:

Transactional

A Data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks

True

Dirty data is erroneous or flawed data

True

a data mart contains a subset of data warehouse information

True

a repository is a central location in which data is stored and managed

True

data aggregation is a collection of data from various sources for the purpose of data processing

True

one example of data aggregation is to gather info about particular groups based on specific variables such as age, profession, or income

True

the primary purpose of a data warehouse is the perform analytical processes

True

within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing

True

Which type of memory is nothing more than the use of your hard drive when you are running out of RAM?

Virtual Memory

Which of the following describes ETL? -a process that extracts information from internal and external databases -a process that transforms information using a common set of enterprise definitions -a process that loads information into a data ware house

all of these

which of the following statements is true regarding customer information? -customer info can exist in several operational systems -customer info in each operational system could change -customer info in each operational system can be different

all of these

which of the following occurs during data cleansing? -clean data marts -clean redundant customer data -clean accurate data -clean correct data

clean redundant customer data

which of the following are examples of external databases in the data warehouse model?

competitor and industry information, mailing lists, and stock market analysis

Operating systems communicate with most hardware components using:

device drivers

Collectively, all malicious programs are referred to as:

malware

within the beginning stages of data warehouse models process, which of the following are included in the internal databases? -marketing, sales, inventory, and billing -data mart 1, data mart 2, data mart 3 -competitor and industry info, mailing lists, and stock market analysis -marketing information, and stock market analysis numbers

marketing, sales, inventory, and billing

Dividing a hard drive into multiple sections is known as:

partitioning

A(n) _________ is a special environment that allows you to run an operating system on top of another operating system.

virtual machine


संबंधित स्टडी सेट्स

A&P - Chapter 22 Amphibian and Reptilian Anatomy and Physiology

View Set

Chapter 13: Marketing - Helping Buyers Buy

View Set

Mark Twain and Regionalism Study Guide

View Set

Textiles Final - Properties of Fibers

View Set

Ecosystems: Energy and Nutrient Flow Module

View Set

NURS 3110 Spring 2020 Mayerson Evolve Quizzes

View Set