Most Recent MSBI Interview Questions and Answers pdf download

51. You are managing a SQL Server 2008 Analysis Services (SSAS) instance which includes a database for Company.com. You alter the DataDir attribute of the instance to a new folder. You should make sure that instance utilizes the new folder in least time.Which is the correct answer?
A. You should operate the database.
B. You should operate the database at the same time.
C. You should stop the Analysis Services service.
D. Before stopping the Analysis Services service you should remove the files in the original folder,
Ans:  A

52. You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a dimension called Product for Company.com. You should set the Dimension Data configurations as following:Deny access to the {[ Product].[Country].[USA],[ Product].[Country].[China]} configure of property workers.New workers increased to the property are seen by default. Which is the correct answer?
A. You should increase the whole country members.
B. You should increase property below:
[Country].[ China],[Product].[Country].[ USA]}
C. You should increase property below:
[Country].[ China],[Product].[Country].[ USA]}
D. You should increase property below:
[Country].[ China],[Product].[Country].[ USA]}
Ans:  B

53. You are creating SQL Server 2008 Integration Services (SSIS) packages which is stored in a folder on the network for Company.com.All members of the team can view the packages but not the attribute values. Your task is to make the attribute values be protected by passwor Which is the correct answer below?
A. You should Use a batch file that runs the dtutil program to set the PackageProtectionLevel
property to EncryptSensitiveWithPassword on each of the SSIS packages you have
B. You should Use a batch file that runs the dtutil program to set the PackageProtectionLevel
property to ServerStorage on each of the SSIS packages you have created.
C. You should Use the SSIS package designer to set the PackageProtectionLevel property to
EncryptAllWithUserKey on each of the previously saved packages.
D. You should Use the SSIS package designer to set the PackageProtectionLevel property to
EncryptSensitiveWithUserKey on each of the previously saved packages.
Ans:  A

54. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.
Through utilizing SQL Profiler, you decide to troubleshoot search function t. You should make sure that it will cost a lot of time to query .Which is the correct answer?
A. You should utilize store procedure.
B. You should utilize Query Subcube
C. You should utilize a Dynamic Management View (DMV)
D. You should utilize Transactions Log.
Ans:  B

55. You are developing a report which is difficult and cost a lot of time to produce. You use the technology of SQL Server 2008 Reporting Services (SSRS).You should make sure that you could set the report server to cache the report for 40 minutes at the beginning of the request. Which is the correct answer?
A. Report snapshots should be run for report.
B. You should run report execution caching for report.
C. You should set the data source to utilize a DBCC INDEXDEFRAG.
D. You should set the data source to utilize a DBCC SHRINKFILE. INDEXDEFRAG
Ans:  B

56 . You are managing a SQL Server 2008 Reporting Services (SSRS) sample for Company.com.The report users decide to transfer reports by web tools. You should make sure that you could set the server for e-mail delivery through utilizing a server. Which is the correct answer?
A. You should change the AppSetttings.config file.
B. You should change the RSReportServer.config file
C. You should change the Machine.config file.
D. You should change the Web.config file.
Ans:  B

57. You are developing a SQL Server 2008 Analysis Server (SSAS) method which includes a measure group called TestGroup with a one partition for Company.com. The condition listed below should be includedSearches which utilize TestGroup on the newest version of the information.In a many aspects format, the whole collections which are member of TestGroup are reserved.In order to solve the problem, which is the correct answer?
A. You should configure Real-time hybrid online analytical processing (HOLAP)
B. You should configure Real-time relational offline analytical processing (ROLAP).
C. You should configure scheduled relational offline analytical processing (ROLAP).
D. You should configure scheduled online processing (MOLAP).
Ans:  A

58. You are developing a SQL Server 2008 Reporting Services (SSRS) method for Company.com. There are some components listed below:A hierarchy called Test in a time dimension called DimTestTimeA method called SalesNumber You decide to increase codes to the cube??s calculation11. . . .12Freeze ([Measures].[ SalesNumber],13[DimTestTime].[ Test].[Quarter].[Q0 2008]);14. . . . For every month in the second quarter of 2008, not only should you add the value of the Sales Number measure through 80%. But also you should make sure that the value for the second quarter of 2008 keeps common. Which is the correct answer?
A. You should increase codes below at line 14. Scope([Measures].[DimTime].[Date].[Quarter].
[Q0 2008]);This=[DimTime].[Date].currentmember * 3;End Scope;
B. You should increase codes below at line 11. Scope([Measures].[ SalesNumber],[
DimTestTime].[ Test].[Quarter]. [Q0 2008]);End Scope;
C. You should increase codes below at line 14 [ SalesNumber],Descendants([DimTestTime].[
Test].[Quarter]. [Q0 2008][ DimTestTime].[ Test].[Month]));This=[ DimTestTime].[
Test].currentmember * 5;End Scope;
D. You should increase codes below at line 11. Scope([Measures]
SalesNumber],Descendants([DimTestTime].[ Test].[Second].[ Q0 2008][ DimTestTime].[ Test].[
Second]));This=[ [ Test] [Second].currentmember * 1.5;End Scope;
Ans:  C
Read More Posts =>
Part1 Part2 Part3 Part4 Part5 Part6