Sophia – Information Technology - Unit 2 Milestone 2 – (100% CORRECT) – Ashford University | Information Technology - Unit 2 Milestone 2 – (100% CORRECT)

Sophia – Information Technology - Unit 2 Milestone 2 – (100% CORRECT) – Ashford University 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 • • 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 44352 Anderson, Tiffany IL 1994 Graduate Econ 98425 Avendano, Marco MN 1994 Graduate Acco 67512 Barrett, Eliza IL 1992 Graduate Math 97156 Brown, Amy MN 1994 Undergraduate Pre-M 36401 Elissa, Jose WI 1997 Undergraduate Acco 97315 Grey, Nicole VT 1999 Undergraduate Thea 54074 Harris, Blake IL 1992 Undergraduate AccoStudent_ID Student_Name State Birth_Year Degree 64782 Jensen, Allan MN 1990 Graduate Econ • 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 15Identify 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