MSBI Online Tests for interview Preparation

Thank you very much for taking test

Test your caliber

1. Define role play dimensions?
One dimension used multiple times in the cube	One dimension used in different cubes
Shared across cubes	None

2. Define dimension usage in SSAS Cube?
To maintain cube data size	To know the relationships between dimensions and fact
To build business logic	None

3. MDX stands?
Memory, Distribution, extensions	Memory, dimension, expressions
Multi, dimension, expressions	None

4. DSV stands?
Data source View	It is view
It has relationships and metadata	All of the above

5. How many types of actions available in the Cube?
One	Two
Three	None

6. What do you understand by dynamic named set (SSAS 2008)?
To create dynamic set of members	To create set of members
None	Both a and b

7. How many types of dimension are possible in SSAS?
Four	Five
Six	Seven

8. In which scenario, you would like to go for materializing dimension?
To increase speed	To decrease memory size
Both	None

9. You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server 2008 database for Company.com. In order to develop a failure recovery plan that is published for a SQL Server. Which is the correct answer?
You should back up the master database	You should back up the local database
You should back up the system database	You should back up the systemdb databse

10. What are the options to deploy SSAS cube in production?
Using BIDS	Using SSMS
Using XMLA	All the above

11. Describe Reporting Lifecycle?
Reports and reports models	Report authoring, Management, Delivery
Both	None

12. What can SQL Server Reporting Services do?
To create files	To create tables
To create Reports	None

13. Define reporting processing?
Report data processing	Report rendering process
Report delivery process	All of the above

14. How many default rending options are available in SSRS2008?
Four	Five
Two	One

15. What is the usage of Report Builder?
To create reports	To create reports for users
Business users create reports	None

16. You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard you should make query logging enable. Which is the correct answer? Which is the correct answer?
You should make the QueryLogSampling server attribute default value	You should make the QueryLogSampling server attribute 5
You should configure the server property of DefaultFolders	You should configure the QueryLogConnectionString server attribute and set a valid connection string

17. How many architecture components of SSRS 2008?
Five	Six
Seven	None

18. Explain on SSRS2008 Reporting Items?
Tablix,Chart,List	Sub Report
Both A and B	None

19. What does mean by nested datasets?
Used datasets with in dataset	A dataset
None	A table

20. How many command line utilities of SSRS2008?
Three	Four
One	None