Tag: technology

True

False

.asc, .prn, .txt, .csv, .xls, .mdb

.asc, .txt, .csv, .xls., .dbf

asc, .prn, .txt, .csv, .xls, .dbf

asc, .prn, .txt, .csv, .xls, .xml , .dbf

Data Mart & DWH both are normalized and can exist in same tier

Data Mart is normalized but DWH is not and they cannot exist in same tier.

DWH is normalized but Data Mart is not and they can exist in same tier.

Both Data Mart & DWH are denormalized and can exist in same tier.

Deleting the report.

The deletion of all the data fetched by the query.

Deleting the report structure.

Refreshing the report

For one tab

For all tabs of the report

Depends how it is defined as global or local.

B and C both

Create a conditional select using the appropriate database function.

Infer a where clause using the where statement of an objects properties.

Apply a restriction set to a group of users that forces a row level where clause.

A and C

All of the above

Sum

Detail

Measure

Dimension

True

False

You can not include complex calculations and functions in a derived table.

Reduced maintenance of database summary tables

Derived table provides real time data analysis

None

Rows, Values, Columns

Column, Values, Rows

Rows, Columns, Values

Both A and C are true