SOPHIA PATHWAY IT Unit 2 Unit 2 - Milestone 2, Complete Answers (Fall 2020)
Select the data type that can only be classified as a number.
•
13:30
•
$1,253.12
•
11/10/11
•
83.152
Designing a Database
...
SOPHIA PATHWAY IT Unit 2 Unit 2 - Milestone 2, Complete Answers (Fall 2020)
Select the data type that can only be classified as a number.
•
13:30
•
$1,253.12
•
11/10/11
•
83.152
Designing a Database
2
__________, developed by Apple, can be used to calculate and organize financial information.
•
Calc
•
Keynote
•
Numbers
•
Excel
Selecting Software
3
Select the scenario that describes a bottom-up approach to data warehouse design.
•
Dave’s Appliances, which has five locations in the city, combines data from each store to a single database, and distributes it to three new data marts.
•
Jaime’s Research Consulting Firm combines data from its clients into a central database, then shares the data with several individual contractors.
•
Hollywood Advertising combines 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 single data warehouse, and distributes it among several data marts.
Data Warehousing
4
Althea launches a program to remove some software she no longer uses.
Which element of the Microsoft Windows operating system is Althea using?
•
Windows Search
•
Start Menu
•
Control Panel
•
Windows Mobility
The Microsoft Windows Operating System
5
While saving a document to her hard drive, Connie's computer screen suddenly changed to display an error message on a blue background. The error code indicated that there was a problem with her computer's RAM.
Connie's computer is affected by a(n) __________.
•
application error
•
file compatibility issue
•
hardware crash
•
system performance issue
Troubleshooting with Microsoft Windows
6
Which of the following correctly describes a record?
•
A record contains all the data about one instance of an item in a database.
•
A record contains all the qualitative data in a database.
•
A record represents a single type of information found in a database.
•
A record is an organized collection of data associated with other data in a database.
Introduction to Databases
7
Which of the following is the FIELD in a database table?
•
6/5/1985
•
[email protected]
•
Emily Walker
•
Name
Introduction to Databases
8
Which statement describes an example of database software?
•
Microsoft Excel enables users to perform calculations and statistical analyses.
•
Microsoft Word enables users to write and edit text documents.
•
Microsoft Access enables users to create, store, and retrieve records.
•
Microsoft PowerPoint enables users to create animated presentations that can be projected on a screen.
Productivity Application Software
9
Sarah is creating custom reports from her company's database.
Select the set of file types that Sarah will use to create these reports.
•
.tif and .db
•
.sql and .xml
•
.txt and .dat
•
.csv and .pptx
Application Software File Types and Formats
10
An enrollment counselor queries the following database table to identify undergraduate accounting majors.
How many records are displayed in the query?
Student_ID Student_Name State Birth_Year Degree Major
44352 Anderson, Tiffany IL 1994 Graduate Economics
98425 Avendano, Marco MN 1994 Graduate Accounting
67512 Barrett, Eliza IL 1992 Graduate Mathematics
97156 Brown, Amy MN 1994 Undergraduate Pre-Medicine
36401 Elissa, Jose WI 1997 Undergraduate Accounting
97315 Grey, Nicole VT 1999 Undergraduate Theatre
54074 Harris, Blake IL 1992 Undergraduate Accounting
64782 Jensen, Allan MN 1990 Graduate Economics
•
1
•
2
•
3
•
4
Managing Data in a Database
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
•
Control Panel
•
Help System
•
Windows Backup
Troubleshooting with Microsoft Windows
12
When Charlie attaches a file to an email message, the computer's __________ is responsible for managing his access to the location where the file is stored.
•
administrator
•
operating system
•
hardware
•
e-mail program
Operating Systems
13
Which of the following is a challenge of data warehousing?
•
Privacy concerns
•
Cloud computing environments
•
A high reliance on data quantity
•
Data originality
Trends and Challenges with Data Warehousing
14
Paul wants to present information about a new product at the upcoming national sales meeting.
Which productivity software should Paul use?
•
IBM DB2
•
Microsoft Excel
•
Google Docs
•
OpenOffice Impress
CONCEPT
Productivity Application Software
15
Identify the true statement about Windows tasks.
•
The GUI controls the process for shutting down Windows.
•
Users can only begin an application by clicking on the associated icon on the desktop.
•
Pressing the Windows key and the E key simultaneously is one way to end a program.
•
The Welcome screen lists the user accounts on the system.
Which productivity software is used to create written memos or reports?
•
PowerPoint
•
Word
•
Excel
•
Access
2
Which of the following correctly describes a record?
•
A record consists of one field.
•
A record appears as a row in a table.
•
A record is a flat file.
•
A record is a set of data organized in columns and rows.
All of the following would appear as records in a database table, EXCEPT:
•
Armstrong
•
Information Technology Specialist
•
Little Rock, AR
•
Last Name
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 __________.
•
CPU
•
monitor
•
keyboard
•
power supply
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?
•
Windows Backup
•
Safe Mode
•
Help System
•
Control Panel
following is a challenge of data warehousing?
•
Cloud computing environments
•
Data originality
•
A high reliance on data quantity
•
Privacy concerns
Which data type should be classified as a date/time?
•
04-15-12 15:25
•
$10.59
•
€ 20
•
0.01
Althea launches a program to remove some software she no longer uses.
Which element of the Microsoft Windows operating system is Althea using?
•
Windows Mobility
•
Windows Search
•
Start Menu
•
Control Panel
Identify the true statement about Windows tasks.
•
Pressing the Windows key and the E key simultaneously is one way to end a program.
•
The GUI controls the process for shutting down Windows.
•
The Welcome screen lists the user accounts on the system.
•
Users can only begin an application by clicking on the associated icon on the desktop.
Katelynn and Genevieve want to make flyers to advertise their school's play. They will collaborate on the flyer document online, and remotely.
Which productivity software should they use?
•
Microsoft Access
•
Google Docs
•
Microsoft PowerPoint
•
Google Sheets
Select the scenario that describes a top-down approach to data warehouse design.
•
O'Reilly's Public House, which has locations in seven states, merges the data marts from each location into a single data warehouse.
•
Mike's Decorating creates data marts from several departments, then combines them into a central data warehouse.
•
Gilbert's Groceries adds all of the data from its vendor, sales, and human resources departments to the central data warehouse, and then divides it between several data marts.
•
Tyson’s Business Innovations creates data marts for its HR and Payroll departments to resolve an employee compensation dispute.
Carrie's computer does not recognize her zip drive when she plugs it into a USB port.
Carrie's computer is experiencing a(n) __________.
•
application crash
•
system performance problem
•
file compatibility issue
•
external error
Jeremy wants to buy a horse. He is looking for a brown Tennessee Walker that is at least five years old AND at least 15 hands tall.
How many records will be displayed in response to 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
__________, developed by Apple, can be used to calculate and organize financial information.
•
Keynote
•
Calc
•
Excel
•
Numbers
Cristina is adding sound files to her presentation.
Select the set of file types that Christina can use to add this media to her presentation.
•
.csv and .jpeg
•
.gif and .wmv
•
.mp3 and .wav
•
.wma and .sql
