0

web technology Online Quiz - 183

Description: web technology Online Quiz - 183
Number of Questions: 20
Created by:
Tags: web technology
Attempted 0/20 Correct 0 Score 0

@ctive data warehouse architecture has separate and segregated data marts

  1. True

  2. False


Correct Option: B

Presentation layer is the only visible part of BI Implementation

  1. True

  2. False


Correct Option: B

Data in a fact table can be at different grains

  1. True

  2. False


Correct Option: B

Balanced scorecard is an example of standard report

  1. True

  2. False


Correct Option: B

Clustering, Scatter graph, Decision tree , histogram are some of GIS(Graphical Information system) visualizations

  1. True

  2. False


Correct Option: B

Ad hoc, Prestored reports , OLAP are samples for Pull mode of Information delivery

  1. True

  2. False


Correct Option: B

Does the upgrade to R8 require a restart of Lotus Notes in windows

  1. True

  2. False


Correct Option: A

Independent data marts are often created because an organization focuses on a series of short-term business objectives.

  1. True

  2. False


Correct Option: B

Data in a fact table can be at different grains

  1. True

  2. False


Correct Option: B

_________________ eliminates bad data and increase the reliability, effectiveness, and usability of data

  1. Data Quality Management

  2. Data Transformations

  3. Data Mining

  4. Data Security Management


Correct Option: A

Following systems can be source for business intelligence

  1. Be-spoke applications

  2. Document Management systems

  3. Enterprise applications

  4. All of the above


Correct Option: D
  1. ETL Tool processing engine

  2. Target database engine

  3. Source database engine

  4. Source and Target database engine


Correct Option: B

Which of the following statements are true about Business Intelligence

  1. Integrates disparate data into meaningful information

  2. Collects only historical data for past data analysis

  3. Defines business rules

  4. All of the above


Correct Option: A

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Integrates disparate data into meaningful information - This option is correct. Business Intelligence involves the process of collecting, organizing, and analyzing data from various sources to generate meaningful insights and information.

Option B) Collects only historical data for past data analysis - This option is incorrect. While Business Intelligence does involve analyzing historical data, it also includes real-time data analysis and forecasting to provide insights for decision-making.

Option C) Defines business rules - This option is incorrect. Business rules are typically defined in the context of business processes and operations, but they are not a direct part of Business Intelligence.

Option D) All of the above - This option is incorrect. Only option A is true for Business Intelligence.

The correct answer is option A. This option is correct because Business Intelligence involves the integration of disparate data into meaningful information.

Data in a data warehouse

  1. Can be normalized but often isn't

  2. In a flat file format

  3. Must be in normalized form to at least 2NF

  4. Must be in normalized form to at least 3NF


Correct Option: A
  1. A Hyper Star

  2. A Relational schema

  3. A Hyper schema

  4. A Star schema


Correct Option: D

Confidentiality, Integrity, Availability are the goals of__________

  1. Data Profiling

  2. Data Security

  3. Data Governance

  4. Master Data Management


Correct Option: B

Which of the following terms best characterizes the process of examining data for statistics and information about the data?

  1. Data profiling

  2. Data cleansing

  3. Business intelligence search

  4. Data governance


Correct Option: A
Explanation:

To solve this question, the user needs to have an understanding of data analysis. The user must be able to identify the process of examining data for statistics and information about the data.

Option A: Data profiling involves the process of examining the data to understand its content, structure, and relationships. It is used to understand the quality of the data to ensure that it is accurate, complete, and consistent. This option best characterizes the process of examining data for statistics and information about the data.

Option B: Data cleansing involves the process of identifying and correcting or removing errors, inconsistencies, and redundancies in the data. While data cleansing is an important part of data analysis, it does not best characterize the process of examining data for statistics and information about the data.

Option C: Business intelligence search involves the use of data mining and analytical tools to analyze business data and provide insights into trends and patterns. While this is an important aspect of data analysis, it is not the best term to characterize the process of examining data for statistics and information about the data.

Option D: Data governance involves the management of the availability, usability, integrity, and security of the data used in an organization. While data governance is important for ensuring the quality of the data, it does not best characterize the process of examining data for statistics and information about the data.

The Answer is: A. Data profiling.

  1. Enterprise Information Management

  2. Enterprise Transaction Management

  3. Enterprise Business Intelligence

  4. None of the above


Correct Option: A
- Hide questions