Question 1

_________________contains the current DSS data at the lowest level of granularity

technology web technology

ODS
Staging Area
Data Warehouse
Data Mart

Answer

Correct Option: A

Question 2

A star schema has what type of relationship between a dimension and fact table?

technology web technology

Many-to-many
One-to-one
One-to-many
All of the above.

Answer

Correct Option: C

Question 3

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

technology web technology

Data Quality Management
Data Transformations
Data Mining
Data Security Management

Answer

Correct Option: A

Question 4

BIDS™ is

technology web technology

Business Intelligence for Decision Support
Business Information for Decision Support
Business Intelligence for Decision Services
Business Information for Decision Services

Answer

Correct Option: A

Question 5

Which of the following statements are true about Business Intelligence

technology web technology

Integrates disparate data into meaningful information
Collects only historical data for past data analysis
Defines business rules
All of the above

Answer

Correct Option: A

Question 6

Following systems can be source for business intelligence

technology web technology

Be-spoke applications
Document Management systems
Enterprise applications
All of the above

Answer

Correct Option: D

Question 7

Data in BI architecture flows as follows

technology web technology

Dispersed data -> Collected Data -> Integrated Data -> Information -> Knowledge
Collected Data -> Dispersed data -> Integrated Data -> Information -> Knowledge
Dispersed data -> Collected Data -> Integrated Data -> Knowledge-> Information
Collected Data -> Dispersed data -> Integrated Data -> Knowledge -> Informatio

Answer

Correct Option: A

Question 8

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

technology web technology

Sourcing data from disparate sources and integrating to be central repository
A process to change data from a detailed level to a summary level
A process to change data from a summary level to a detailed level
Separating data from one source into various sources of data

Answer

Correct Option: A

Question 9

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

technology web technology

MOLAP
ROLAP
HOLAP
None of the above

Answer

Correct Option: A

Question 10

ODS (Operational Data Store) provides

technology web technology

Detailed decision making
Operational reporting
Drill through analysis
All of the above

Answer

Correct Option: D

Question 11

This diagram represents a

technology web technology

A Hyper Star
A Relational schema
A Hyper schema
A Star schema

Answer

Correct Option: D

Question 12

Data security includes

technology web technology

Protecting data from accidental loss, corruption
Standardizing data formats
Eliminating irrelevant data
Correcting anomalies

Answer

Correct Option: A

Question 13

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

technology web technology

ETL
ELT
ELTL
EII

Answer

Correct Option: B

Question 14

__________ architectural style of MDM provides real time central reference

technology web technology

Consolidation
Registry
Coexistence
Transaction

Answer

Correct Option: B

Question 15

Confidentiality, Integrity, Availability are the goals of__________

technology web technology

Data Profiling
Data Security
Data Governance
Master Data Management

Answer

Correct Option: B

Question 16

ELT uses ------------------------- for processing

technology web technology

ETL Tool processing engine
Target database engine
Source database engine
Source and Target database engine

Answer

Correct Option: B

Question 17

The cube structure in OLAP achieves the __________functionality.

technology web technology

Shared
Information
Collection
Multidimensional

Answer

Correct Option: D

Question 18

Topn/Bottom n can be achieved using

technology web technology

Filters
Sort
Rank
Data aggregation

Answer

Correct Option: B

Question 19

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

technology web technology

Data profiling
Data cleansing
Business intelligence search
Data governance

Answer

Correct Option: A

Question 20

_____________is a focus area of data governance

technology web technology

Enterprise Information Management
Enterprise Transaction Management
Enterprise Business Intelligence
None of the above

Answer

Correct Option: A

Description: web technology Online Quiz - 186
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: web technology

web technology Online Quiz - 186

Find more quizzes from top tags