Microsoft 70-455 Real Exam Questions
Upgrade: Transition Your MCITP SQL Server 2005 BI Developer to MCITP SQL Server 2008 BI Developer
This is an upgrade exam designed to assess candidates’ knowledge of implementing and maintaining solutions by using the Microsoft SQL Server 2008 Business Intelligence tool suite.
1: 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?
A.CREATE SET CURRENTCUBE.[Top 10 Customer] ASTOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
B.CREATE DYNAMIC SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
C.CREATE HIDDEN SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
D.CREATE SESSION SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
Correct Answers: B
2: You design a Business Intelligence (BI) solution by using SQL Server 2008.
You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution contains a cube that has a measure named SalesAmount. The measure contains customer sales data for the last six months.
The cube has a single partition that has the storage property set to real-time hybrid online analytical processing (HOLAP).
Queries against the cube must return current sales data that is entered one hour before cube processing. The partition takes two hours to process and the response time for the queries is slow.
You need to improve the cube processing and query response time.
What should you do?
A.Change the storage setting of the partition to multidimensional online analytical processing (MOLAP).
B.Change the storage setting of the partition to real-time relational online analytical processing (ROLAP).
C.Create a partition for each customer. Set the storage setting of every partition to low-latency multidimensional online analytical processing (MOLAP).
D.Create a partition for every month. Set the storage setting of the partition for the current month to low-latency multidimensional online analytical processing (MOLAP) and that of the other partitions to MOLAP.
Correct Answers: D
3: You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do?
A.Add a reference to the assemblies in the Report Properties References tab.
B.Write the calculation logic used by the calculations by using T-SQL functions.
C.Write the code of the calculation logic into the Report Properties Custom Code tab.
D.Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services (SSRS).
Correct Answers: A
4: You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to analyze customer interests for the various sections of the Web site of your company. Information required for analysis is stored in the log files on the Web server. You plan to design a SQL Server 2008 Integration Services (SSIS) solution to load the information from the log files into a database. You need to enumerate the log files that are stored on the Web server. Which control flow element should you use?
A.File System task
B.Data Profiling task
C.Sequence container
D.Foreach Loop container
Correct Answers: D
5: You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server Integration Services (SSIS) solution that contains 20 packages. You need to run the packages in a predefined order. Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)
A.Use precedence constraints.
B.Use the task host container.
C.Use the Execute Package task.
D.Use the system variables for the packages.
E.Use data flow paths.
Correct Answers: A C
6: You design a Business Intelligence (BI) solution by using SQL Server 2008.
You develop SQL Server 2008 Integration Services (SSIS) projects. You plan to deploy the projects in the following manner:
A parent package on an instance that is named SSIS1.
Three child packages individually on three instances that are named SSIS2, SSIS3, and SSIS4.
You need to ensure that the parent package can discover the execution state of the child packages.
What should you do?
A.Configure the parent package to log its events to a SQL Server log provider.
B.Configure the child packages to log their events to a SQL Server log provider.
C.Configure the parent package to log its events to a SQL Server Profiler log provider.
D.Configure the child packages to log their events to a SQL Server Profiler log provider.
Correct Answers: B
7: You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a solution that analyzes the usage of discount vouchers issued by the company. The data warehouse of the company contains a dimension table named Vouchers. The dimension table contains two columns named VoucherNumber and CustomerFullName. A value for the CustomerFullName column is not available till the voucher is used. You need to configure the Slowly Changing Dimension transformation to load the Vouchers dimension even if there is a NULL value in the CustomerFullName column. What should you do?
A.Enable the support for inferred members.
B.Set the Change Type option to Fixed Attribute for the CustomerFullName column.
C.Set the Change Type option to Historical Attribute for the VoucherNumber column.
D.Set the Change Type option to Changing Attribute for the VoucherNumber column.
Correct Answers: A
8: You design a Business Intelligence (BI) solution by using SQL Server 2008. You want to deploy a SQL Server 2008 Analysis Services (SSAS) cube that contains 700 dimension attributes and 100 million Fact rows. The cube reads from a remote data source and increases several measure groups by 1 million rows everyday. You plan to increase the number of users by 200 percent for the cube. You need to capture the baseline performance on the overall system during cube processing. What should you do?
A.Configure the data collector to collect Performance Counters statistics during cube processing.
B.Configure the data collector to collect Query Activity statistics during cube processing.
C.Use the sp_monitor system stored procedure to monitor cube processing events.
D.Use the sp_trace_setfilter system stored procedure to monitor cube processing events.
Correct Answers: A
9: You administer a Microsoft SQL Server 2005 Reporting Services (SSRS) instance.
The instance has the following features:
Deployed as a single server
Configured to use Native mode
A custom data extension developed by using Microsoft .NET Framework 2.0
You plan to upgrade the instance to SQL Server 2008 Reporting Services.
You need to upgrade the instance without loss of functionality.
What should you do?
A.Uninstall Internet Information Services (IIS).
B.Upgrade the data extension to .NET Framework 3.5.
C.Edit the RSWebapplication.config file to refer to the upgraded SSRS endpoint location.
D.Install a new instance of SSRS. Migrate the existing configuration files and database to the new instance.
Correct Answers: D
10: You design a Business Intelligence (BI) solution by using SQL Server 2008. The SQL Server 2008 instance hosts a database. The database is currently scheduled for a full backup on a monthly basis. The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup. The database uses the bulk-logged recovery model. You need to back up the database changes to a tape drive every night by using minimum storage space and time. Which backup strategy should you use?
A.File backup
B.Partial backup
C.Differential backup
D.Differential Partial backup
Correct Answers: D
Download | Password: certificatexam.com