0

web technology Online Quiz - 184

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

_________________ 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

BIDS™ is

  1. Business Intelligence for Decision Support

  2. Business Information for Decision Support

  3. Business Intelligence for Decision Services

  4. Business Information for Decision Services


Correct Option: A

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

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

Data in BI architecture flows as follows

  1. Dispersed data -> Collected Data -> Integrated Data -> Information -> Knowledge

  2. Collected Data -> Dispersed data -> Integrated Data -> Information -> Knowledge

  3. Dispersed data -> Collected Data -> Integrated Data -> Knowledge-> Information

  4. Collected Data -> Dispersed data -> Integrated Data -> Knowledge -> Informatio


Correct Option: A

Data Integration involves -----------------------------

  1. Sourcing data from disparate sources and integrating to be central repository

  2. A process to change data from a detailed level to a summary level

  3. A process to change data from a summary level to a detailed level

  4. Separating data from one source into various sources of data


Correct Option: A

______________ is the best OLAP architecture approach for small data and complex model

  1. MOLAP

  2. ROLAP

  3. HOLAP

  4. None of the above


Correct Option: A

ODS (Operational Data Store) provides

  1. Detailed decision making

  2. Operational reporting

  3. Drill through analysis

  4. All of the above


Correct Option: D

This diagram represents a

  1. A Hyper Star

  2. A Relational schema

  3. A Hyper schema

  4. A Star schema


Correct Option: D

Data security includes

  1. Protecting data from accidental loss, corruption

  2. Standardizing data formats

  3. Eliminating irrelevant data

  4. Correcting anomalies


Correct Option: A

___________________________ is recommended for small and medium data volumes, good data quality and off peak loads

  1. ETL

  2. ELT

  3. ELTL

  4. EII


Correct Option: B

__________ architectural style of MDM provides real time central reference

  1. Consolidation

  2. Registry

  3. Coexistence

  4. Transaction


Correct Option: B

Confidentiality, Integrity, Availability are the goals of__________

  1. Data Profiling

  2. Data Security

  3. Data Governance

  4. Master Data Management


Correct Option: B
  1. ETL Tool processing engine

  2. Target database engine

  3. Source database engine

  4. Source and Target database engine


Correct Option: B

The cube structure in OLAP achieves the __________functionality.

  1. Shared

  2. Information

  3. Collection

  4. Multidimensional


Correct Option: D
  1. Filters

  2. Sort

  3. Rank

  4. Data aggregation


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

AI Explanation

To answer this question, you need to understand the different terms related to examining data for statistics and information. Let's go through each option to understand why it is correct or incorrect:

Option A) Data profiling - This option is correct because data profiling is the process of analyzing and examining data to understand its structure, content, and quality. It involves gathering statistics and information about the data, such as the number of missing values, distribution, data types, and patterns.

Option B) Data cleansing - This option is incorrect because data cleansing refers to the process of identifying and correcting or removing errors, inconsistencies, and inaccuracies in the data. While data cleansing may involve examining the data, it is specifically focused on improving data quality rather than gathering statistics and information.

Option C) Business intelligence search - This option is incorrect because business intelligence search refers to the process of searching and retrieving data from various sources to gain insights and make informed decisions. It is more focused on accessing and analyzing data rather than examining it for statistics and information.

Option D) Data governance - This option is incorrect because data governance refers to the overall management and control of data within an organization. It involves establishing policies, procedures, and standards for data management, including data quality, security, and compliance. While data governance may include aspects of examining data, it is a broader concept that encompasses various data management activities.

The correct answer is A) Data profiling. This option is correct because it specifically refers to the process of examining data for statistics and information about the data.

Ad-hoc reporting requires predefined report template

  1. True

  2. False


Correct Option: B

ODS (Operational Data Store) is a Non-Volatile data store

  1. True

  2. False


Correct Option: B

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
- Hide questions