Information Technology > Exam > SOPHIA PATHWAY IT Unit 2 Unit 2 - Milestone 2, Complete Answers (Fall 2020) (All)

SOPHIA PATHWAY IT Unit 2 Unit 2 - Milestone 2, Complete Answers (Fall 2020)

Document Content and Description Below

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.1... 52 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 [Show More]

Last updated: 2 years ago

Preview 1 out of 14 pages

Add to cart

Instant download

OR

Reviews( 0 )

Recommended For You

 Information Technology> Exam > Kaperskey Exam. Questions and Answers. (All)

Kaperskey Exam. Questions and Answers.

Question 1 To deploy protection in a network, you need to install Network Agents (1), install Kaspersky Endpoint Security (2), install the Administration Server (3). Select the recommended deployme...

By Kirsch 1 year ago

Exam

$11

0  

 Information Technology> Exam > Sophia – Information Technology - Unit 3 Milestone 3,100% CORRECT (All)

Sophia – Information Technology - Unit 3 Milestone 3,100% CORRECT

The standard interface technology for wireless networks is . The hardware component necessary for computers to connect to these networks is a . • transmission control protocol; IP •...

By securegrades 1 year ago

Exam

$16

0  

 Information Technology> Exam > Sophia University CS-121 / CSCI-E121 sophia milestone 2. (All)

Sophia University CS-121 / CSCI-E121 sophia milestone 2.

Sophia University CS-121 / CSCI-E121 sophia milestone 2. 1 Katelynn and Genevieve want to make flyers to advertise their school's play. They will collaborate on the flyer document online, and remote...

By Expert1 2 years ago

Exam

$9

0  

 Information Technology> Exam > Sophia_Information And Communications Technology|Unit 4 - Milestone 4 (All)

Sophia_Information And Communications Technology|Unit 4 - Milestone 4

Sophia IT Milestone 4 unit 4 Zehra works with a software development team. One of his tasks is to define the overall structure of an application and divide it into components to be developed. What...

By Expert1 2 years ago

Exam

$13

1  

 Information Technology> Exam > Georgia Institute Of Technology - ISYE 6501Midterm Quiz 2 - GT Students and Verified MM Learners _ Midterm Quiz 2 _ ISYE6501x Courseware (All)

Georgia Institute Of Technology - ISYE 6501Midterm Quiz 2 - GT Students and Verified MM Learners _ Midterm Quiz 2 _ ISYE6501x Courseware

Midterm Quiz 2 - GT Students and Veried MM Learners 90 Minute Time Limit Instructions Work alone. Do not collaborate with or copy from anyone else. You may use any of the following resources: One...

By NBS***** 1 year ago

Exam

$6

0  

 Information Technology> Exam > Hinds Community College - IST 1124;IT final milestone_all answers 100% correct. (All)

Hinds Community College - IST 1124;IT final milestone_all answers 100% correct.

IT final milestone. You passed this Milestone 25 questions were answered correctly. 1 Which of the following can be controlled by copyright? • The team logo for a minor league baseball team •...

By Expert1 2 years ago

Exam

$19

0  

 Information Technology> Exam > Sophia University - IT 100 | Sophia Intro to IT Milestone Final. (Summer 2020) Already passed. (All)

Sophia University - IT 100 | Sophia Intro to IT Milestone Final. (Summer 2020) Already passed.

Sophia Intro to IT Milestone Final Score 24/25 1 Game Changer Technologies has four software teams. Each of them is developing four different examples of its new game app. Which software develop...

By Expert1 2 years ago

Exam

$10

1  

 Information Technology> Exam > SOPHIA PATHWAY Information Technology Unit 3 - Milestone 3. (Already Passed) 100% Correct (Fall 2020) (All)

SOPHIA PATHWAY Information Technology Unit 3 - Milestone 3. (Already Passed) 100% Correct (Fall 2020)

SOPHIA PATHWAY Information Technology Unit 3 - Milestone 3. The standard interface technology for wireless networks is __________. The hardware component necessary for computers to connect to thes...

By Expert1 2 years ago

Exam

$15

0  

 Information Technology> Exam > ISM 3541 EXAM 1/KERWIN (LATEST) Download to Score A: Florida State University. (All)

ISM 3541 EXAM 1/KERWIN (LATEST) Download to Score A: Florida State University.

ISM 3541 EXAM 1/KERWIN (LATEST) Download to Score A: Florida State University./ISM 3541 EXAM 1/KERWIN (LATEST) Download to Score A: Florida State University./ISM 3541 EXAM 1/KERWIN (LATEST) Download t...

By Rixx Dennis 1 year ago

Exam

$4

2  

 Information Technology> Exam > Examen Kaspersky Certified| Latest| Download for Grade A+ (All)

Examen Kaspersky Certified| Latest| Download for Grade A+

Question 1 What happens when the extended KSN mode is enabled? 1. When the extended KSN mode is enabled, Kaspersky Security Center switches to the KSN Proxy mode and starts caching all requests se...

By Quiz Merchant 1 year ago

Exam

$12.5

0  

Exam

$15.00

Add to cart

Instant download

OR

Can't Find what you want?

PLACE CUSTOM WRITING ORDER
125
0

Document information


Connected school, study & course



About the document


Uploaded

2 years ago

Number of pages

14

Written in

All

Type

Exam

Seller


Expert1

Member since 2 years ago

799 Documents Sold


Additional information

This document has been written for:

Course

Information Technology

Paper Category

Exam

Uploaded

2 years ago

Downloads

 0

Views

 125

THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

Avoid examination resits

Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.

Get the best grades

Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality

Earn from your notes

Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.

WHAT STUDENTS SAY ABOUT US


What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·