• web technology Online Quiz - 182
Back
0

web technology Online Quiz - 182

Description: web technology Online Quiz - 182
Number of Questions: 20
Created by:
Tags: web technology
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

technology web technology

  1. MOLAP

  2. ROLAP

  3. HOLAP

  4. None of the above

Show answer
Correct Option: A

Balanced scorecard is an example of standard report

technology web technology

  1. True

  2. False

Show answer
Correct Option: B

Data in BI architecture flows as follows

technology web technology

  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

Show answer
Correct Option: A

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

technology web technology

  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

Show answer
Correct Option: A

Data warehouse is which of the following?

technology web technology

  1. Can be updated by end users.

  2. Contains numerous naming conventions and formats.

  3. Organized around important subject areas.

  4. Contains only current data.

Show answer
Correct Option: C

An operational system is which of the following?

technology web technology

  1. A system that is used to run the business in real time and is based on historical data.

  2. A system that is used to run the business in real time and is based on current data.

  3. A system that is used to support decision making and is based on current data.

  4. A system that is used to support decision making and is based on historical data

Show answer
Correct Option: C

Presentation layer is the only visible part of BI Implementation

technology web technology

  1. True

  2. False

Show answer
Correct Option: B

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

AI Explanation

To answer this question, you need to understand the concept of a star schema.

A star schema is a type of data model used in data warehousing. It consists of a fact table that is connected to one or more dimension tables. The fact table contains the quantitative data that you want to analyze, while the dimension tables contain descriptive attributes.

In a star schema, the relationship between a dimension table and a fact table is typically a one-to-many relationship. This means that for each record in the fact table, there can be multiple related records in the dimension table.

Option A) Many-to-many - This option is incorrect because a star schema does not typically have a many-to-many relationship between dimension and fact tables. A many-to-many relationship would require a bridge table to connect the two tables.

Option B) One-to-one - This option is incorrect because a star schema does not typically have a one-to-one relationship between dimension and fact tables. A one-to-one relationship would mean that each record in the fact table corresponds to only one record in the dimension table.

Option C) One-to-many - This option is correct because a star schema typically has a one-to-many relationship between dimension and fact tables. Each record in the fact table can have multiple related records in the dimension table.

Option D) All of the above - This option is incorrect because a star schema does not have a many-to-many or one-to-one relationship between dimension and fact tables. The correct answer is option C, which states that the relationship is one-to-many.

Therefore, the correct answer is C) One-to-many. This option is correct because a star schema typically has a one-to-many relationship between a dimension and fact table.

This is a data management practice that characterizes the content, quality, and structure of your data.

technology web technology

  1. data enrichment

  2. data caving

  3. data refinement

  4. data profiling

Show answer
Correct Option: D
Explanation:

To solve this question, the user needs to have knowledge about data management and its various practices. The user must be able to identify the practice that best describes the characteristics of data content, quality, and structure.

Now, let's go through each option and explain why it is right or wrong:

A. Data enrichment: This practice involves enhancing data with additional information from external sources. It is not related to characterizing the content, quality, and structure of your data. Therefore, this option is incorrect.

B. Data caving: This practice refers to the process of creating and exploring data caves, which are virtual spaces where data can be analyzed and visualized. It is not related to characterizing the content, quality, and structure of your data. Therefore, this option is incorrect.

C. Data refinement: This practice involves improving the quality of data by removing errors, inconsistencies, and redundancies. Although it is related to data quality, it does not address the characterization of data content and structure. Therefore, this option is incorrect.

D. Data profiling: This practice involves analyzing data to understand its content, quality, and structure. It helps to identify potential issues with the data and to establish rules for data integration, transformation, and cleansing. Therefore, this option is the correct answer.

The Answer is: D

What is the process of removing erroneous, incomplete or old data from a database?

technology web technology

  1. data eradication

  2. data cleansing

  3. data unloading

  4. data purging

Show answer
Correct Option: B

________________ 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

  3. Data Governance

  4. Data Quality

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

Metadata for ‘123456TCS’ can be

technology web technology

  1. Format is Employee Number – Number (6), Organization Name – Char (3)

  2. Employee 123456 works for TCS for five years

  3. Employee 123456 has worked in BIPM services

  4. None of the above

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

_________________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

Ad-hoc reporting requires predefined report template

technology web technology

  1. True

  2. False

Show answer
Correct Option: B

The cube structure in OLAP achieves the __________functionality.

technology web technology

  1. Shared

  2. Information

  3. Collection

  4. Multidimensional

Show answer
Correct Option: D

Aggregation provides OLAP with __________

technology web technology

  1. Multidimensional data.

  2. Pre-calculated data.

  3. Nested data.

  4. Slow data retrieval.

Show answer
Correct Option: B

What term in OLAP defines changing the dimensional orientation of the report from the cube data?

technology web technology

  1. Dicing

  2. Slicing

  3. Rotating

  4. Nesting

Show answer
Correct Option: C

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

technology web technology

  1. True

  2. False

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions