Tag: web technology

Questions Related to web technology

________________ provides context to data, acts as the semantic layer between a company’s IT systems and its business users
technology web technology

  1. Metadata

  2. Master data

Show answer
Correct Option: A

An enterprise has multiple ETL and reporting tools. Which of the following Metadata management is recommended
technology web technology

  1. Distributed

  2. Federated

  3. Centralized

  4. Not possible to implement Metadata

Show answer
Correct Option: A

_________________transforms enterprise into agile, accountable, adaptable, and aligned organization

technology web technology

  1. Corporate Performance Management

  2. Analytics BPO

  3. Predictive analysis

  4. None of the above

Show answer
Correct Option: A

Metadata Management is applicable at
technology web technology

  1. Source layer

  2. Report Layer

  3. Data Warehouse

  4. All of the above

Show answer
Correct Option: D

_________________can be used by all level of users
technology web technology

  1. Enterprise report

  2. OLAP reports

  3. GIS

  4. Scorecards

Show answer
Correct Option: A

Data in a data warehouse

technology web technology

  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

Show answer
Correct Option: A

_________________contains the current DSS data at the lowest level of granularity
technology web technology

  1. ODS

  2. Staging Area

  3. Data Warehouse

  4. Data Mart

Show answer
Correct Option: A

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

technology web technology

  1. Many-to-many

  2. One-to-one

  3. One-to-many

  4. All of the above.

Show answer
Correct Option: C

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

  1. Data Quality Management

  2. Data Transformations

  3. Data Mining

  4. Data Security Management

Show answer
Correct Option: A

BIDS™ is

technology web technology

  1. Business Intelligence for Decision Support

  2. Business Information for Decision Support

  3. Business Intelligence for Decision Services

  4. Business Information for Decision Services

Show answer
Correct Option: A