Solved MCQ of Data Warehouse set-3

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: left;"><br /></div><table cellpadding="0" cellspacing="0" class="tr-caption-container zemanta-img" style="float: right; margin-left: 1em; text-align: left;"><tbody><tr><td style="text-align: center;"><a href="http://commons.wikipedia.org/wiki/File:OLAP_Cube.png" imageanchor="1" style="margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img alt="OLAP Cube illustration" border="0" class="zemanta-img-inserted zemanta-img-configured" height="242" src="http://upload.wikimedia.org/wikipedia/commons/7/7d/OLAP_Cube.png" style="border: medium none; font-size: 0.8em;" title="Solved MCQ of Data Warehouse" width="280" /></a></td></tr><tr><td class="tr-caption zemanta-img-attribution" style="text-align: center; width: 280px;">OLAP Cube illustration (Photo credit: <a href="http://commons.wikipedia.org/wiki/File:OLAP_Cube.png" rel="nofollow" target="_blank">Wikipedia</a>)</td></tr></tbody></table><div style="text-align: left;"></div><div style="text-align: left;"><br /></div><div style="text-align: left;">1. Data warehouse architecture is based on .......................</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) DBMS</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) RDBMS</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) Sybase</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) <a href="http://www.microsoft.com/sqlserver">SQL Server</a> </div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">2. .......................... supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) Information processing</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) Analytical processing </div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) Data mining</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) Transaction processing</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">3. The core of the multidimensional model is the ....................... , which consists of a large set of facts and a number of dimensions.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) Multidimensional cube</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) Dimensions cube</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) <a href="http://en.wikipedia.org/wiki/OLAP_cube">Data cube</a></div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) Data model</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">4. The data from the operational environment enter ........................ of data warehouse.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) Current detail data</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) Older detail data</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) Lightly Summarized data</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) Highly summarized data</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /><a name='more'></a></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">5. A data warehouse is ......................</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) updated by end users.</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) contains numerous naming conventions and formats</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) organized around important subject areas</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) contain only current data</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">6. Business Intelligence and <a href="http://en.wikipedia.org/wiki/Data_warehouse">data warehousing</a> is used for ..............</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) Forecasting</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) <a href="http://en.wikipedia.org/wiki/Data_mining">Data Mining</a></div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) Analysis of large volumes of product sales data</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) All of the above</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">7. Data warehouse contains ................ data that is never found in the operational environment.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) normalized</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) informational</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) summary</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) denormalized</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">8. ................... are responsible for running queries and reports against data warehouse tables.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) Hardware</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) Software</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) End users</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) Middle ware</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">9. The biggest drawback of the level indicator in the classic star schema is that is limits ............</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) flexibility</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) quantify</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) qualify</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) ability</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">10. ............................. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) <a href="http://en.wikipedia.org/wiki/Operational_database">Operational database</a></div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) Relational database</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) Multidimensional database</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) Data repository</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><h4 style="text-align: left;">Answers:</h4><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">1. Data warehouse architecture is based on .........................</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) RDBMS</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">2. .......................... supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">B) Analytical processing </div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">3. The core of the multidimensional model is the ....................... , which consists of a large set of facts and a number of dimensions.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) Data cube</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">4. The data from the operational environment enter ........................ of data warehouse.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) Current detail data</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">5. A data warehouse is ......................</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) organized around important subject areas</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">6. Business Intelligence and data warehousing is used for ..............</div><div style="text-align: left;"><br /></div><div style="text-align: left;">D) All of the above</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">7. Data warehouse contains ................ data that is never found in the operational environment.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) summary</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">8. ................... are responsible for running queries and reports against data warehouse tables.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) End users</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">9. The biggest drawback of the level indicator in the classic star schema is that is limits ............</div><div style="text-align: left;"><br /></div><div style="text-align: left;">A) flexibility</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;">10. ............................. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.</div><div style="text-align: left;"><br /></div><div style="text-align: left;">C) Multidimensional database</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><h4 style="text-align: left;">Related posts</h4><h4 class="zemanta-related-title" style="text-align: left;"></h4><div style="text-align: left;"><br /></div><br /><ul style="text-align: left;"><li><a href="http://www.siteforinfotech.com/2014/05/mcq-on-data-mining-with-answers-set-1.html">MCQ on Data Mining with Answers set-1</a></li><li><a href="http://www.siteforinfotech.com/2014/06/mcq-on-data-warehouse-with-answers-set-2.html">MCQ on Data Warehouse with Answers set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/08/solved-mcq-of-management-information-system-MIS.html">Solved MCQ of Management Information System set-1</a></li><li><a href="http://www.siteforinfotech.com/2013/08/mcq-of-management-information-system-MIS-with-answer.html">MCQ of Management Information System With Answer set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/05/solved-mcq-of-e-commerce-and-e-banking.html">Solved MCQ of E-Commerce and E-Banking Set-1</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-1.html">Solved MCQ of Data Structure Set-1</a></li><li><a href="http://www.siteforinfotech.com/2012/11/solved-mcq-of-system-analysis-and_28.html">Solved MCQ of System Analysis and Design Set-3</a></li><li><a href="http://www.siteforinfotech.com/2013/12/computer-organization-and-architecture-interview-questions.html">Computer Organization and Architecture Interview Questions set-4</a></li></ul></div>

Solved MCQ of Data Warehouse set-3

OLAP Cube illustration (Photo credit: Wikipedia ) 1. Data warehouse architecture is based on ....................... A) DBMS B) RDBMS C) Syb...

مزيد من المعلومات »

MCQ on Data Warehouse with Answers set-2

<div dir="ltr" style="text-align: left;" trbidi="on"><br /><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container zemanta-img" style="float: right; margin-left: 1em; text-align: right;"><tbody><tr><td style="text-align: center;"><a href="http://commons.wikipedia.org/wiki/File:Data_warehouse_overview.JPG" imageanchor="1" style="margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img alt="Data Warehouse Overview" border="0" class="zemanta-img-inserted zemanta-img-configured" height="263" src="http://upload.wikimedia.org/wikipedia/commons/thumb/4/46/Data_warehouse_overview.JPG/350px-Data_warehouse_overview.JPG" style="border: medium none; font-size: 0.8em;" title="MCQ on Data Warehouse with Answers" width="350" /></a></td></tr><tr><td class="tr-caption zemanta-img-attribution" style="text-align: center; width: 350px;">Data Warehouse Overview (Photo credit: <a href="http://commons.wikipedia.org/wiki/File:Data_warehouse_overview.JPG" target="_blank">Wikipedia</a>)</td></tr></tbody></table><br /><div style="text-align: left;"></div><div style="text-align: left;"></div><div style="text-align: left;"></div><div style="text-align: left;"></div><br />1. The full form of OLAP is<br /><br /><br />A) <a href="http://en.wikipedia.org/wiki/Online_analytical_processing">Online Analytical Processing</a><br /><br />B) Online Advanced Processing<br /><br />C) Online Advanced Preparation<br /><br />D) Online Analytical Performance<br /><br /><br /><br /><br />2. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.<br /><br />A) <a href="http://en.wikipedia.org/wiki/Data_mining">Data Mining</a><br /><br />B) <a href="http://en.wikipedia.org/wiki/Data_warehouse">Data Warehousing</a><br /><br />C) Document Mining<br /><br />D) Text Mining<br /><br /><br /><br /><br />3. The data is stored, retrieved and updated in ....................<br /><br />A) OLAP<br /><br />B) OLTP<br /><br />C) SMTP<br /><br />D) FTP <br /><br /><br /><br /><br />4. An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.<br /><br />A) OLAP<br /><br />B) OLTP<br /><br />C) Both of the above<br /><br />D) None of the above<br /><br /><br /><br /><a name='more'></a><br /><br />5. ........................ is a good alternative to the star schema.<br /><br />A) Star schema<br /><br />B) Snowflake schema<br /><br />C) Fact constellation<br /><br />D) Star-snowflake schema<br /><br /><br /><br /><br />6. The ............................ exposes the information being captured, stored, and managed by operational systems.<br /><br />A) top-down view<br /><br />B) data warehouse view<br /><br />C) data source view<br /><br />D) business query view<br /><br /><br /><br /><br />7. The type of relationship in star schema is ...............<br /><br />A) many to many<br /><br />B) one to one<br /><br />C) one to many<br /><br />D) many to one<br /><br /><br /><br /><br /><br />8. The .................. allows the selection of the relevant information necessary for the data warehouse.<br /><br />A) top-down view<br /><br />B) data warehouse view<br /><br />C) data source view<br /><br />D) business query view<br /><br /><br /><br /><br />9. Which of the following is not a component of a data warehouse?<br /><br />A) Metadata<br /><br />B) Current detail data<br /><br />C) Lightly summarized data<br /><br />D) Component Key<br /><br /><br /><br /><br />10. Which of the following is not a kind of data warehouse application?<br /><br />A) Information processing<br /><br />B) Analytical processing<br /><br />C) Data mining<br /><br />D) Transaction processing<br /><h4 style="text-align: left;"></h4><h4 style="text-align: left;"></h4><h4 style="text-align: left;"></h4><h4 style="text-align: left;"><b><br /></b></h4><h4 style="text-align: left;"><b>Answers:</b></h4><br /><br /><br />1. The full form of OLAP is<br /><br />A) Online Analytical Processing<br /><br /><br />2. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.<br /><br />B) Data Warehousing<br /><br /><br />3. The data is stored, retrieved and updated in ....................<br /><br />B) OLTP<br /><br /><br />4. An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.<br /><br />A) OLAP<br /><br /><br />5. ........................ is a good alternative to the star schema.<br /><br />C) Fact constellation<br /><br /><br />6. The ............................ exposes the information being captured, stored, and managed by operational systems.<br /><br />C) data source view<br /><br /><br />7. The type of relationship in star schema is ...............<br /><br />C) one to many<br /><br /><br />8. The .................. allows the selection of the relevant information necessary for the data warehouse.<br /><br />A) top-down view<br /><br /><br />9. Which of the following is not a component of a data warehouse?<br /><br />D) Component Key<br /><br /><br />10. Which of the following is not a kind of data warehouse application?<br /><br />D) Transaction processing<br /><br /><br /><br /><br /><br /><h4 style="text-align: left;">Related Posts </h4><br /><br /><ul style="text-align: left;"><li><a href="http://www.siteforinfotech.com/2014/05/mcq-on-data-mining-with-answers-set-1.html">MCQ on Data Mining with Answers set-1 </a></li><li><a href="http://www.siteforinfotech.com/2013/08/solved-mcq-of-management-information-system-MIS.html">Solved MCQ of Management Information System set-1</a></li><li><a href="http://www.siteforinfotech.com/2013/08/mcq-of-management-information-system-MIS-with-answer.html">MCQ of Management Information System With Answer set-2</a></li><li><a href="http://www.siteforinfotech.com/2013/05/solved-mcq-of-e-commerce-and-e-banking.html">Solved MCQ of E-Commerce and E-Banking Set-1</a></li><li><a href="http://www.siteforinfotech.com/2012/12/solved-mcq-of-data-structure-set-1.html">Solved MCQ of Data Structure Set-1</a></li><li><a href="http://www.siteforinfotech.com/2012/11/solved-mcq-of-system-analysis-and_28.html">Solved MCQ of System Analysis and Design Set-3</a></li><li><a href="http://www.siteforinfotech.com/2013/12/computer-organization-and-architecture-interview-questions.html">Computer Organization and Architecture Interview Questions set-4</a></li></ul><br /><br /></div>

MCQ on Data Warehouse with Answers set-2

Data Warehouse Overview (Photo credit: Wikipedia ) 1. The full form of OLAP is A) Online Analytical Processing B) Online Advanced Processing...

مزيد من المعلومات »