104 Part I EXAM PREPARATION APPLY YOUR KNOWLEDGE
104 Part I EXAM PREPARATION APPLY YOUR KNOWLEDGE 11. A small manufacturing company has a considerable number of data sources because no standardization has occurred across any platform. One of the database servers has SQL Server installed; the others come from a variety of vendors. For a project you are working on, you need to gather data from the SQL Server and merge it together with data from two other sources. You then need to bring the data into Excel to do some charting. How would you accomplish this? A. Export the data from the other sources into a comma-delimited file for import to SQL Server. Then export from SQL Server the data that is to be imported into Excel. B. Export the data from all three sources so that it can be imported into Excel. C. Use SQL Server to transfer all the data from all sources directly into Excel. D. Use Excel to transfer data from all three sources into a spreadsheet. 12. A small scientific laboratory needs a powerful database server to perform analysis of complex measures performed on scientists regular experiments. The lab requires exact accuracy with all calculations because the results determine the fracture points of various metals. Which data type offers the most accurate results? A. smallmoney B. money C. float D. real E. decimal 13. In a large department store, an inventory database is maintained for all products sold. Data is updated frequently by multiple computer terminals. Forty computer terminals throughout the offices and store can access the database simultaneously to perform updates. You want to minimize conflict situations and reduce the load on the server as much as possible. The client systems have very little processing power of their own. What architecture would you select for this system? A. Single-tier B. Two-tier thin client C. Two-tier thick client D. N-tier E. Internet 14. You are implementing a database for a military warehouse that needs to track the components that make up their equipment. Each piece of equipment has more than a hundred parts, each of which is made up of many smaller components. Any given aircraft has thousands of components from wheel assemblies to jet engines. A wheel assembly is made up of approximately 50 other components, each of which may come from a different supplier. Many of the separate parts are used in other components. What set of entities would be used in this structure? A. Suppliers, Equipment, Components, Parts B. Suppliers, Equipment, Components, Parts, Supplier/Parts C. Suppliers, Equipment, Components, Parts, Equipment/Parts D. Suppliers, Equipment, Components, Parts,
For high quality website hosting services please check cheap web hosting website.