Do You Know How To Do Business?
Settings
-
+
Anyone can start a business, but to successfully maintain the one, you need to be street smart as well as book smart. Do you think you would be an asset to the business you want to work in based on the amount of knowledge you have on businesses and how to achieve their goals and objectives? Take up the quiz below and find out how much you know about it. !
- 1.Define Lookup transformation?
- A.
Used as reference table.
- B.
Used as master table.
- C.
Used as fact table
- D.
None.
- 2.Define synchronous transformations?
- A.
Input rows count and Output rows count are same
- B.
Input rows count and Output rows count are not same.
- C.
Input rows count and Output rows count are different.
- D.
None.
- 3.How to rename file using SSIS tasks?
- A.
Using lookup.
- B.
Using Data flow.
- C.
Using File system task
- D.
None.
- 4.
- A.
To maintain data load statistics in ETL process.
- B.
To know the errors.
- C.
To know the Primary keys.
- D.
None
- 5.How many container tasks available in SSIS?
- A.
One.
- B.
Two.
- C.
Three.
- D.
Four.
- 6.Define role play dimensions?
- A.
One dimension used multiple times in the cube.
- B.
One dimension used in different cubes.
- C.
Shared across cubes.
- D.
None.
- 7.Define dimension usage in SSAS Cube?
- A.
To maintain cube data size.
- B.
To know the relationships between dimensions and fact.
- C.
To build business logic.
- D.
None.
- 8.MDX stands?
- A.
Memory, Distribution, extensions.
- B.
Memory, dimension, expressions.
- C.
Multi, dimension, expressions.
- D.
None
- 9.DSV stands?
- A.
Data source View.
- B.
It is view.
- C.
It has relationships and metadata.
- D.
All above.
- 10.How many types of actions available in the Cube?
- A.
One.
- B.
Two.
- C.
Three.
- D.
None.
- 11.What do you understand by dynamic named set (SSAS 2008)?
- A.
To create dynamic set of members.
- B.
To create set of members.
- C.
Both a and b.
- D.
None
- 12.In which scenario, you would like to go for materializing dimension?
- A.
To increase speed.
- B.
To decrease memory size.
- C.
Both.
- D.
None
- 13.What are different storage mode options?
- A.
MOLAP, HOLAP and ROLAP.
- B.
Process modes.
- C.
Process options.
- D.
None.
- 14.
- A.
Using BIDS.
- B.
Using SSMS.
- C.
Using XMLA.
- D.
All the above.
- 15.
- A.
To create files.
- B.
To create tables.
- C.
To create Reports.
- D.
None.
- 16.
- A.
To create reports.
- B.
To create reports for users.
- C.
Business users create reports.
- D.
None
- 17.Explain report model in SSRS 2008?
- A.
Model used by Report Builder.
- B.
Model used by reports.
- C.
Both.
- D.
None
- 18.How many architecture components of SSRS 2008?
- A.
Five.
- B.
Six.
- C.
Seven.
- D.
None.
- 19.Explain on SSRS2008 Reporting Items?
- A.
Tablix,Chart,List
- B.
Sub Report.
- C.
Both A and B.
- D.
None
- 20.How many command line utilities of SSRS2008?
- A.
Three.
- B.
Four.
- C.
One.
- D.
None
Back to top