Ashford University - SOPHIA PATHWAY Sophia - Environmental Science - Final Milestone/ Rated A.|SOPHIA PATHWAY Unit 2 - Milestone 2 Exam With All Correct answers.(100% VERIFIED)

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 Economics 98425 Avendano, Marco MN 1994 Graduate Accounting 67512 Barrett, Eliza IL 1992 Graduate Mathematics 97156 Brown, Amy MN 1994 Undergraduate Pre-Medicine Student_ID Student_Name State Birth_Year Degree 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