Sophia – Information Technology - Unit 2 Milestone 2 ,1OO% CORRECT

Select the data type that can only be classified as a number. • 13:30 • $1,253.12 • 11/10/11 • 83.152 2 __________, developed by Apple, can be used to calculate and organize financial information. • Calc • Keynote • Numbers 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 Charley’s Wholesalers combines data from its produce, meat, and dry goods vendors 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 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 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. 7 Which of the following is the FIELD in a database table? • 6/5/1985 • • Emily Walker • Name 8 Which statement describes an example of database 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 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 44352 Anderson, Tiffany IL 1994 Graduate Econ 98425 Avendano, Marco MN 1994 Graduate Acc 67512 Barrett, Eliza IL 1992 Graduate Mat 97156 Brown, Amy MN 1994 Undergraduate Pre- 36401 Elissa, Jose WI 1997 Undergraduate Acc 97315 Grey, Nicole VT 1999 Undergraduate Thea 54074 Harris, Blake IL 1992 Undergraduate Acc 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 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. 13 Which of the following is a challenge of data warehousing? • Privacy concerns • Cloud computing environments • A high reliance on data quantity • Data originality 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 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? • :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