data warehouse.pdf

Chapter One 1. What is date? Data is what an enterprise runs at every step of an enterprise operation 2. What is database? The database is the container that holds the data 3. What is warehouse? A warehouse is a commercial building for storage of...

Chapter One 1. What is date? Data is what an enterprise runs at every step of an enterprise operation 2. What is database? The database is the container that holds the data 3. What is warehouse? A warehouse is a commercial building for storage of goods 4. Define BIG date? Big Data is a data that is too big to work on a computer 5. List characteristics BIG date? A. Volume. B. Velocity. C. Variety. 6. What is date warehouse? A DWH is a relational DB that is designed for query and analysis rather than for transaction processing 7. List date warehouse environment? A. ETL: extraction, transformation, and loading. B. Statistical analysis. C. Reporting. D. Data mining capabilities 8. What is OLAP tools (Online analytical processing)? OLAP Tools: A software that attempt to facilitate multidimensional analysis  9. List characteristics date warehouse? A. Subject Oriented. B. Integrated. C. Nonvolatile. D. Time Variant. 10. List subject oriented? A. Product. B. Customers. C. Suppliers. D. Sales. etc. 11. What is subject oriented? You can answer questions such as  Who was our best customer for this item last year?  Who is likely to be our best customer next year? 12. Define integrated? A DWH is Constructed by integrating multiple, Heterogeneous data sources. 13. Define nonvolatile? Nonvolatile means that, once entered into the DWH, data should not change 14. Define variant? A time horizon is the length of time data is represented in an environment 15. What is data warehouse (DW) evolution? The story of the DWH begins with the evolution of information and DSS 16. What is date mining? Extract usable data from a larger set of data.  17. Define data warehouse implementation? Exam 70-463- Implementing a Data Warehouse with Microsoft SQL Server 2012 18. Which tools you need? Microsoft.SQL.Server.2014 19. What is date warehouse sample? AdventureWorksDW2012 Data  Chapter Two 1. What is business intelligence? Technology infrastructure for gaining maximum information from available data 2. What is business intelligence used? BI is used to improve business processes 3. List business intelligence BU analyses date about? A. Your most valuable customer B. Highest purchased product C. Least purchased product D. Customer preferences E. Peak purchasing time 4. List business intelligence (BI) components? A. Software solution for gathering. B. Cleansing. C. Integrating. D. Analyzing. E. Sharing data. 5. Define OLAP? OLAP is the most powerful technology available to businesses for real-time decision making. 6. What is OLAP used? OLAP is used to organize large business databases and support business intelligence 7. OLAP? A. Historical data. B. Data that tells Infrequent update. C. Integrated data. D. Analytical queries. 8. List types OLAP? A. MOLAP. B. ROLAP. C. HOLAP. 9. What is Multidimensional OLAP? Data are stored in a multidimensional cubes. 10. What is relational OLAP? ROLAP stores all data in the relational Database.  11. What is ROLAP used? ROLAP uses an SQL reporting tool to query data directly from the data warehouse. 12. What is hybrid OLAP? HOLAP attempts to combine the best features of MOLAP and ROLAP in a single system. 13. What is OLTP? The source data for OLAP is OLTP databases. 14. OLTP? A. Operational Database. B. Data that works Frequent updated and queries. C. Normalization and ACID. D. Accessing individual tuples. 15. What is the difference between OLAP and OLTP? OLTP OLAP System Operational Data Data Warehouse Purpose Daily Transaction Planning, Decimation making Updates Frequently In Frequently Queries simple Complex Time Fast Slow Space Small Large  Chapter Three 1. What is data model? A data model visually represents 2. List types Data Models contains the key Database objects? A. Tables. B. Columns. C. Relationship. D. Constraints. 3. How to create data model? Data Models are created for OLTP and OLAP. 4. How to create OLAP? OLTP: models are created by normalizing data. 5. How to create OLAP? OLAP: models are created by de-normalizing data. 6. List data modeling types? A. Conceptual Data Modeling. B. Logical Data Modeling. C. Physical Data Modeling. 7. What is Conceptual Data Modeling? Conceptual Data Modeling gives an idea to the functional and technical team. 8. How is CDM created by gathering business requirements from various sources? A. Business documents. B. Discussion with functional teams. C. Business analysts. D. Management experts. E. End users who do the reporting on the Database.  9. Features of conceptual data model? A. Entities and the relationships among them. B. No attribute is specified. C. No primary key is specified. 10. Define Logical data model? Logical data model is the actual implementation of a conceptual data model. 11. List Logical data model? A. Entities and relationships among them. B. Attributes for each entity. C. Primary key for each entity. D. Foreign keys. E. Normalization occurs at this level. 12. What is Physical Data model? Physical Data represents how the model will be built in the Database. 13. Physical Data Modeling? A. Database performance. B. Indexing strategy. C. Physical storage. 14. Physical Data Modeling shows table structures? A. Column name. B. Column data type. C. Column constraints. D. Relationships between tables. 15. List types PHDM? A. Convert entities into tables. B. Convert relationships into foreign keys. C. Convert attributes into columns. D. Modify constraints based on physical requirements.