DBW 301 Final Exam | Verified with 100% Correct Answers

DBW 301 Final Exam | Verified with 100% Correct Answers ..... table contains the values we want to analyze. A. Fact B. Dimension C. Aggregate D. Center ........ focus is on how managers view the business. A. Data warehouse B. OLTP C. Business system D. OLAP ......... reveals business trends. A. Data warehouse B. OLTP C. Business system D. OLAP ........... acts as the glue that connects all parts of the data warehouse. A. Metadata B. ETL C. Operational Metadata Extraction and Transformation Metadata ............ may answer questions on overall process. A. OLTP B. OLAP C. Business Intelligence D. Data warehouse ............ systems capture details of events or transactions. A. OLTP B. Data warehouse C. OLAP D. Business Intelligence ............. indicator of high-quality data ensures that there are no missing values for a given attribute in the system. A. Accuracy B. Domain Integrity C. Data Type D. Completeness ............. indicator of high-quality data ensures the data value of an attribute falls in the range of allowable, defined values. A. Accuracy B. Domain Integrity C. Data Type D. Consistency ............. indicator of high-quality data ensures the form and content of a data field is the same across multiple source systems. A. Accuracy B. Domain Integrity C. Data Type D. Consistency ............. indicator of high-quality data ensures the value stored in the system for a data element is the right value for that occurrence of the data element. A. Accuracy B. Domain Integrity C. Data Type D. Consistency ............. indicator of high-quality data ensures value for a data attribute is actually stored as the data type defined for that attribute. A. Accuracy B. Domain Integrity C. Data Type D. Consistency ............... signifies that the data warehouse stores the information around a particular subject such as product, customer, sales etc. A. Subject oriented B. Integrated C. Time-Variant D. Nonvolatile ................. means populating all the data warehouse tables for the very first time. A. Initial load B. Incremental load C. Load all D. Load ............................. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model. A. Operational database B. Relational database C. Multidimensional database D. Data repository ...............represents the level of detail in the fact table. A. Data granularity B. Aggregation C. Data level D. Data size ............systems focus on individual events. A. Data warehouse B. OLTP C. Business system D. OLAP ...........means applying ongoing changes as necessary in a periodic manner. A. Incremental load B. Updating load C. Full refresh D. Immediate load A fact is a measure taken at the .............of all the dimensions. A. intersection B. union C. combination D. cross A goal of data mining includes which of the following? A. To explain some observed event or condition B. To confirm that data exists C. To analyze data for expected relationships D. To create a new data warehouse A table may contain some ............. indexes. Select one answer only. A. Bitmap B. Clustered C. non-clustered, bitmap D. non-clustered A value of delimited should be selected for delimited files. A. Sort B. Format C. OLTP D. String A Web-enabled data warehouse adapts the Web for information delivery and collaboration among the users. Is this true? A. YES B. NO ACCESSIBLE characteristic of strategic information means: A. Every business factor must have one and only one value. B. Easily accessible with intuitive access paths, and responsive for analysis. C. Information must be accurate and must conform to business rules. D. Must have a single, enterprise-wide view. Accurate requirements definition in a data warehouse project is many times more important than in other types of projects. A. True B. False An OLAP cube is an array of data understood in terms of...... dimensions. A. 3 B. 2 C. 1 D. its 0 or more Bayesian classifiers is : A. A class of learning algorithm that tries to find an optimum classification of a set of examples using the probabilistic theory. B. Any mechanism employed by a learning system to constrain the search space of a hypothesis C. An approach to the design of learning algorithms that is inspired by the fact that when people encounter new situations, they often explain them by reference to familiar experiences, adapting the explanations to fit the new situation. D. None of these Benefits from a data warehouse accrue only after the users put it to full use. A. True B. False BIDS (Business Intelligence Development Studio) provides environment for developing your OLAP Cube and Deploy on SQL Server. A. True B. False Building a data warehouse is very different from building an operational system. A. True B. False Business metadata comes from sources more varied than those for technical metadata. A. True B. False CREDIBLE characteristic of strategic information means: A. Every business factor must have one and only one value. B. Easily accessible with intuitive access paths, and responsive for analysis. C. Information must be accurate and must conform to business rules. D. Must have a single, enterprise-wide view. Data granularity in a data warehouse refers to the level of detail. A. True B. False DATA INTEGRITY characteristic of strategic information means: A. Every business factor must have one and only one value. B. Easily accessible with intuitive access paths, and responsive for analysis. C. Information must be accurate and must conform to business rules. D. Must have a single, enterprise-wide view. Data Mining means we want to mining the data? A. YES B. NO Data on salary may be represented as monthly salary, weekly salary, and bimonthly salary in different source payroll systems. What do you call the above problem in ETL? A. Inconsistency B. Consistency C. Diverse D. Multiple-form Data warehouse architecture is just an overall guideline. It is not a blueprint for the data warehouse. A. True B. False Degenerated dimensions ............ A. contain only one attribute B. contain many attributes C. contain no attribute D. contain a primary key and a fact value Dimension tables contain the ...... of analysis. A. criterions B. measurements C. facts D. values Dimensional Modeling is suitable for............ A. OLTP systems B. Data warehouse systems C. OLTP and Data warehouse systems D. OLAP Entity-Relationship Modeling is suitable for............ A. OLTP systems B. Data warehouse systems C. OLTP and Data warehouse systems D. OLAP ETL stands for ............... A. data extraction, transformation, and loading. B. data extraction, transaction, and loading. C. data extraction, transfer, and loading. D. data extraction, transformation, and launching. Fact tables generally occupy the most of the storage capacity. A. True B. False IF You are using Classification to build the mobile application for forecasting. What kind of output you should store in your mobile application? A. Everything B. The Training data C. Model D. All of others In a data warehouse, the metadata component is unique, with no truly matching component in operational systems. A. True B. False In a fact table, there are 3 kinds of attributes: (choose one answer only) A. Dimension foreign keys B. Degenerated dimensions C. Facts D. All the others In a table, there is only one ............. index. A. Bitmap B. Clustered C. non-clustered D. Tree In an operational system, data is usually kept at the lowest level of detail. A. True B. False In any analytical system, time is a critical dimension. A. True B. False In Bottom-Up Approach of designing a data warehouse, data marts are created first to provide analytical and reporting capabilities for specific business subjects based on the dimensional data model. A. True B. False In data quality, which is (are) the Sources of Data Pollution? (choose one answer only) A. System Conversions B. Poor Database Design C. Heterogeneous System Integration D. All the others In data warehouse, Data Extraction function has to deal with numerous data sources. You have to employ the appropriate technique for each data source. A. True B. False In designing a data warehouse, Top-Down Approach will create a data warehouse as a centralized repository for the entire enterprise. A. True B. False In ETL, .............tables are loaded first. A. Dimension B. Fact C. Dimension and Fact D. None of the others In SQL (Structured Query Language), Which statement(s) is (are) TRUE regarding to the term cardinality? 1) Low-cardinality refers to columns with few unique values. 2) The lower the cardinality, the less duplicated elements in a column. 3) SQL databases use cardinality to help determine the optimal query plan for a given query. A. 1 and 2 B. 1 and 3 C. 2 and 3 D. There isn't statement. In the data warehouse architecture, ................ sits on top of all the other components. It coordinates the services and activities within the data warehouse. A. Metadata Component B. Management and Control Component C. Data source Component D. Data Storage Component In the dimensional model, the attributes of the data warehouse are divided into ..........and dimension tables A. center B. fact C. summary D. aggregate In which case, indexes can improve the performance? A. Insert data B. Update data C. Read data D. None of the others Indexing in data warehouse database reduces performance of ........ A. Information delivery B. ETL C. Loading data into data warehouse D. OLAP INTEGRATED characteristic of strategic information means: A. Every business factor must have one and only one value. B. Easily accessible with intuitive access paths, and responsive for analysis. C. Information must be accurate and must conform to business rules. D. Must have a single, enterprise-wide view. Is that true, if one says that OLAP report on the past while Data Mining predicts the future? A. YES B. NO It is used to push data into a relation database table. This control will be the destination for most fact table data flows. A. Web Scraping B. Data inspection C. OLE DB Source D. OLE DB Destination Justification the benefits of a data warehouse through stiff ROI (Return on investment) calculations is always easy. A. True B. False Layer in neuron network is just the representation of a gap (hyper plane) that separate the data into different classes. A. Yes B. No Let business requirements drive your data warehouse, not technology A. True B. False Maintaining metadata in a modern data warehouse is just for documentation. A. True B. False Metadata in a data warehouse is similar to the .............or the data catalog in a database management system. A. data dictionary B. data structure C. data tables D. data constraints MOLAP refers to ............OLAP. A. Multiple B. Multidimensional C. Many-to-Many D. Mix OLAP stands for A. Offline Analytical Processing B. Online Analytical Processing C. Online Analytical Production D. Object Analytical Processing OLAP systems provide ............. and roll-up capabilities. A. drill-down B. drop-down C. top-down D. up-down OLTP is stand for Online Transaction Processing. A. True B. False