Southern New Hampshire University
IT -200 fundamentals of information technology
Questions and answers for milestone 6
1
Select the scenario that describes a bottom-up approach to data warehouse design.
Jaime’s Research Consulting Firm combines data from its
clients into a central database, then redistributes the data to
several individual contractors.
Hollywood Advertising combines established data marts from
its San Diego, Los Angeles, and San Francisco offices into a
single data warehouse.
Charley’s Wholesalers combines data from its produce, meat, and
dry goods vendors into a centralized data warehouse, then
redistributes it among several data marts.
Dave’s Appliances, which is expanding to new locations in the city,
collects data into a centralized database, and then redistributes it
to three new data marts.
RATIONALE
Hollywood Advertising is designing a bottom-up data warehouse. Bottom-up designs first build data marts for
different departments, then merge the data marts into a single data warehouse. The other answer choices use a
top-down data warehouse design. Top-down design collects data from several data marts into a central database,
then redistributes the data into new data marts when necessary.
CReOpNoCrtEaPnTissue with
this question Data
Warehousing
2
Which of the following is a challenge of data warehousing?
Privacy concerns
Updating data
Low quantities of data
Cloud computing environments
RATIONALE
It has become easy to collect data from a variety of sources and combine them to perform new forms of analysis.
Some firms combine publicly-accessible data with information obtained from the government and other sources to
create warehouses of data (about people and companies) for sale. Therefore privacy must be carefully considered.
CONCEPT
Trends and Challenges with Data Warehousing
Report an issue with this question
3
Which statement describes an example of database software?
Microsoft PowerPoint enables users to create animated
presentations that can be projected on a screen.
Microsoft Access enables users to create, store, and retrieve
records.
Microsoft Excel enables users to perform calculations and
statistical analyses.
Microsoft Word enables users to write and edit text documents.
RATIONALE
Microsoft Access is a database management system used to store and retrieve records. It combines a relational
database with a graphical user interface and software-development tools.
CONCEPT
Productivity Application Software
Report an issue with this question
4
While saving a document to her hard drive, Connie's computer screen suddenly changed to display an error
message on a blue background before shutting down. The error code indicated that there was a problem with
her computer's RAM.
Connie's computer experienced a(n) .
application error
file compatibility issue
system performance issue
hardware crash
RATIONALE
Connie's computer is affected by a hardware crash. A computer can crash due to faulty hardware. Computer
hardware can fail after long periods of use.
CONCEPT
Troubleshooting with Microsoft Windows
Report an issue with this question
5
Identify the true statement about Windows tasks.
The most common way to open an application is by using the
command line.
Clicking on the Internet Explorer icon is a shortcut way to display
all Microsoft Office programs.
Pressing the enter button begins the boot process.
You can view all files on a computer by using File Explorer
(formerly known as Windows Explorer).
RATIONALE
You can view all of the files on a computer by using File Explorer (formerly called Windows Explorer).
Pressing the power button begins the boot process. The most common way to begin an application is by accessing
the Start menu. Clicking on the Internet Explorer icon is not a shortcut way to display all Microsoft Office programs.
Clicking on that icon will open the Internet Explorer web browser.
CONCEPT
Using the Microsoft Windows Operating System
Report an issue with this question
6
Jeremy wants to buy a horse. He is looking for a Tennessee Walker that is at least five years old AND at least
15 hands tall from the below database table.
How many records from the below table are returned by his query?
COLOR BREED HANDS AGE
Brown
Tennessee Walker
14.5
7
Black
Tennessee Walker
16
5
Brown
Thoroughbred
16.5
8
Brown
Tennessee Walker
14
5
Brown
Tennessee Walker
15.5
2
Black
Thoroughbred
15
3
Black
Tennessee Walker
15
9
1
2
0
3
RATIONALE
Jeremy's query returns only data that matches BREED = Tennessee Walker, HANDS >= 15, and AGE >= 5, which is
two records - the second record and the last record.
CONCEPT
Managing Data in a Database
Report an issue with this question
7
, which was created by OpenOffice, enables users to create slideshow presentations.
Access
Impress
Pages
Writer
RATIONALE
Impress, which was created by OpenOffice, enables users to create slideshow presentations. Impress is similar to
Microsoft's PowerPoint.
Impress users can open Microsoft PowerPoint files (.ppt) as well as those created in its open document
presentation format (.odp), which is recognized internationally.
CONCEPT
Selecting Software
Report an issue with this question
8
Paul wants to present information about a new product at the upcoming national sales meeting.
Which productivity software should Paul use?
OpenOffice Impress
Microsoft Excel
Google Docs
IBM DB2
RATIONALE
OpenOffice Impress is presentation software from Apache that Paul can use for the meeting.
CONCEPT
Productivity Application Software
Report an issue with this question
9
Giuseppe is adding a new entry to a school's faculty database for a teacher who just joined the school. He
will be adding the teacher's name, email address, and the subject they teach in the new entry.
The entry Giuseppe is adding to the database with all of the teacher's information is an example of what
kind of database element?
A record
Quantitative data
A field
A column
RATIONALE
A record contains all the data about one instance of an item in a database. Each record in the database is a row
from a table that has information corresponding to each field or column in the table, like name or email address. In
this case, since Giuseppe is adding a new entry to the faculty database with all the information about one teacher,
he would be adding a new record.
CONCEPT
Introduction to Databases
Report an issue with this question
10
Which of the following is the FIELD in a database table?
$1,345.20
$969.78
Account_Balance
$2,109.49
RATIONALE
"Account_Balance" is typically found in the column of a database table because it is a field in which there should be
information for all clients. "$1345.20", "$2,109.49", and "$969.78" would be found in rows because they are specific
data about a particular record.
CONCEPT
Introduction to Databases
Report an issue with this question
11
Brian has a corrupted file that tries to load when his computer is booting up. To solve this problem, he restarts
the computer, then presses F8 to display the Advanced Boot Options menu.
Which solution is Brian using?
Safe Mode
Help System
Control Panel
Windows Backup
RATIONALE
Brian restarts his computer and then presses F8 to access the Advanced Boot Options menu. This activates the
Safe Mode. Safe Mode is a diagnostic state of a computer operating system (OS). It is used to repair problems
with an OS.
CONCEPT
Troubleshooting with Microsoft Windows
Report an issue with this question
12
Jeremiah searches his computer for movie files that he recently shot during his vacation in Belize.
Select the set of file types that Jeremiah should look for.
.wma and .mpg
.mpg and .key
.avi and .wmv
.mov and .ods
RATIONALE
The set of file types that Jeremiah should look for is .avi and .wmv. Video file formats are used to store digital
video data on a computer system.
CONCEPT
Application Software File Types and Formats
Report an issue with this question
13
Luis has an organized system of icons, files, and folders on his computer's home screen.
Which element of the Microsoft Windows operating system is Luis using?
Device Manager
Start Menu
Control Panel
Desktop
RATIONALE
The description refers to the Desktop of the Microsoft Windows operating system on Luis' computer.
CReOpNoCrtEaPnTissue with this question
The Microsoft Windows Operating System
14
Select the data type that can only be classified as a number.
83.152
$1,253.12
11/10/11
13:30
RATIONALE
The appropriate type for "83.152" is number. The appropriate type for "$1,253.13" is currency. The appropriate
type for both "13:30" and "11/10/11" is date/time.
CONCEPT
Designing a Database
Report an issue with this question
15
Because a computer typically runs a variety of programs simultaneously, the role of the operating
system is to ensure that all programs have access to the .
power supply
keyboard
monitor
CPU
RATIONALE
The CPU manages the commands it receives from the computer software. When a computer is multitasking, the
