Microsoft-PRO Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Analysis Services (SSAS) solution contains a cube that has the following objects: Dimensions named DimCustomer, DimProduct, and DimGeography Measures named InternetSales and TotalSales Users run reports against all dimensions and measures by authenticating with their Windows accounts. You need to provide a basic view of data to the users to display only DimGeography, DimProduct, and TotalSales by using the least amount of storage space. What should you do?

Create a new perspective for the current cube. Select DimGeography, DimProduct, and TotalSales. Create a new cube.Add DimGeography, DimProduct, and TotalSales. Create a new role.Grant access only to DimGeography, DimProduct, and TotalSales. Create a new data source view.dd the tables used for DimGeography, DimProduct, and TotalSales.

You design a Business Intelligence (BI) solution by using SQL Server 2008. The SQL Server 2008 Integration Services (SSIS) developers use a SQL Server 2008 instance as the primary development environment. All the SSIS packages contain data connection managers that use SQL Server authentication to extract data. The packages are saved by using the EncryptAllWithUserKey package protection level.You plan a package migration strategy from the development environment to a production environment. Migration will be performed by using an automated script. You need to ensure that the packages execute without error in the production environment. What should you do?

Create a package configuration for every package that uses a SQL Server table. Create a package configuration for every package that uses an XML configuration file. Export each package and change the package protection level to DontSaveSensitive. Export each package and change the package protection level to EncryptSensitiveWithPassword.

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Reporting Services (SSRS) instance contains a report. Employees execute the report by using Report Manager. Each employee has his own specific set of parameters to execute the report. Data for the report is updated once daily. For each employee, the report takes more than five minutes to execute. You discover that data retrieval takes most of the time during report execution. You need to reduce the execution time of the report. What should you do?

Create a report execution snapshot. Create a data-driven subscription that uses the NULL delivery method. Create a data-driven subscription that uses the file share delivery method. Create a standard subscription that uses the file share delivery method.

You design a Business Intelligence (BI) solution by using SQL Server 2008. Users have no specialized knowledge of the Transact-SQL (T-SQL) language. You plan to create a reporting solution by using SQL Server 2008 Reporting Services (SSRS). You have data stored in a SQL Server 2008 relational data warehouse. You need to ensure that users are able to create the necessary reports by using data from the data warehouse. What should you do?

Create a shared data source that points to the data warehouse. Instruct the users to use Report Designer in Business Intelligence Development Studio (BIDS) to create the reports by using the shared data source. Create a Report Model from the data warehouse.Instruct the users to use Report Builder 2.0 to create the reports by using the Report Model. Create a shared data source that point to the data warehouse.Instruct the users to use Report Builder 2.0 to create the reports by using the shared data source. Create a Report Model from the data warehouse.Instruct the users to use Report Designer in Business Intelligence Development Studio (BIDS) to create the reports by using the Report Model.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Reporting Services (SSRS) report that meets the following requirements: -Displays sales data for the last 12 months. -Enables users to view the sales information summarized by month. -Enables users to view individual sales orders for any given month. You need to design the report to minimize the impact on bandwidth. What should you do?

Create a standard report that contains all sales orders. Implement report filtering based on the month. Create a standard report that contains all sales orders. Implement grouping for the monthly summaries. Create a standard report that contains the monthly summaries. Create a subreport for the sales orders forany given month. Create a standard report that contains the monthly summaries. Create a drillthrough report for the salesorders for any given month.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have created an extract, transform, and load (ETL) solution by using SQL Server 2008 Integration Services (SSIS). The solution contains 10 child packages and a parent package that executes the child packages in sequence. You plan to deploy the solution to 20 locations that are not connected to each other. You need to deploy the solution by configuring the connection managers of all packages with the appropriate settings. You need to achieve this goal by using the minimum amount of administrative effort. What should you do?

Create an XML configuration file each for the parent package and the child packages. Create an XML configuration file for the parent package. Configure the child packages by using Parentpackage variables. Create a SQL Server configuration each for the parent package and the child packages in a central SQLServer 2008 database. Create a SQL Server configuration for the parent package in a central SQL Server 2008 database.Configure the child packages by using Parent package variables.

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution will contain a total of 100 different reports created by using Report Definition Language (RDL). Each report must meet the following requirements: -Display a common set of calculations based on a parameter value. -Provide a method for setting values on a report URL or in a subscription definition that are not exposed to a user. -The business rules for all reports that determine the calculations change frequently. You need to design a solution that meets the requirements. You need to perform this action by using the minimum amount of development and maintenance effort. What should you do?

Create hidden parameters in each report. Create internal parameters in each report. Implement the function in the

 element of each report.							 ✘


																		  Implement the function in a custom assembly. Reference the assembly in each report.							 ✔
							
							
													

						
																														
						
							
							
								Answer & Solution 
                Discuss in Board
                 Save for Later
							

						
						
							
								Answer & Solution




								Answer: Option B



								Solution:
								It provides fallback for IE8.


										
						8.
							
								You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008
Analysis Services (SSAS) solution by using SQL Server 2008. The solution uses a source database that
contains a table named Customer. The Customer table has multiple columns.
You have read-only access to the database.
You plan to reduce the number of columns in the Customer table. You need to split the Customer table to be
distributed across multiple table definitions.
What should you do?									
							
						
																		  Create multiple data sources for the SSAS solution.							 ✘
							
							
														
						
																		  Create multiple named queries for the SSAS solution.							 ✘
							
							
													
																		  Create multiple data source views for the SSAS solution.							 ✘
							
							
													
																		  Create multiple database views for the source database.							 ✔
							
							
													

						
																														
						
							
							
								Answer & Solution 
                Discuss in Board
                 Save for Later
							

						
						
							
								Answer & Solution




								Answer: Option B



								Solution:
								It provides fallback for IE8.

							

						
						
											
										
						9.
							
								You are the administrator of your company network. You use SQL Server 2008 to develop a
Business Intelligence (BI) solution. You use SQL sever 2008 to work out a SQLServer 2008
Analysis Services (SSAS) solution. There??s a dimension named DimCustomer that represents
customers in the solution. The solution provides a list of top 8 customers in terms of the sales
amount. End users of the solution use filters in Microsoft Excel worksheet to analyze data. You
have to make sure that when the filters are applied, the list is updated. So which named set
expression should you use?									
							
						
																		  CREATE SESSION SET CURRENTCUBE.[Top 10 Customer] AS
TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])							 ✘
							
							
														
						
																		  CREATE HIDDEN SET CURRENTCUBE.[Top 10 Customer] ASTOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])							 ✘
							
							
													
																		  CREATE DYNAMIC SET CURRENTCUBE.[Top 10 Customer] ASTOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])							 ✘
							
							
													
																		  CREATE SET CURRENTCUBE.[Top 10 Customer]ASTOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])							 ✔
							
							
													

						
																														
						
							
							
								Answer & Solution 
                Discuss in Board
                 Save for Later
							

						
						
							
								Answer & Solution




								Answer: Option B



								Solution:
								It provides fallback for IE8.

							

						
						
											
										
						10.
							
								You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008
Analysis Services (SSAS) solution by using SQL Server 2008. The solution contains a dimension named
DimCustomer that represents customers. The solution provides a list of top 10 customers based on the sales
amount. End users of the solution analyze data by using filters in Microsoft Excel worksheet. You need to
ensure that the list is updated when the filters are applied.
Which named set expression should you use?									
							
						
																		  CREATE SET CURRENTCUBE.[Top 10 Customer] AS
TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])							 ✘
							
							
														
						
																		  CREATE DYNAMIC SET CURRENTCUBE.[Top 10 Customer] ASTOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])							 ✘
							
							
													
																		  CREATE HIDDEN SET CURRENTCUBE.[Top 10 Customer] ASTOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])							 ✘
							
							
													
																		  CREATE SESSION SET CURRENTCUBE.[Top 10 Customer] ASTOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])							 ✔
							
							
													

						
																														
						
							
							
								Answer & Solution 
                Discuss in Board
                 Save for Later
							

						
						
							
								Answer & Solution




								Answer: Option B



								Solution:
								It provides fallback for IE8.


				
					Prev
					Next


	
		
			
				
				
					Congratulations
					you have successfully completed the test
					
						Back to Question
						View Result



	
		
		
			
				×
			
			Detail Form
			We will send your result on your email id and phone no. please fill detail
		
		
			
				
					Name
					
				
				
					Email ID
					
					Note: Report will be send to the above Email ID
				
				
					Phone No

Microsoft-PRO Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner