EnsurepassQUESTION 131 You design a report by using SQL Server 2008 Reporting Services (SSRS). The report uses a Table data region and contains a dataset. The dataset has a column named LastName. You need to ensure that the report items…
Read more
EnsurepassQUESTION 121 You create a SQL Server 2008 Reporting Services (SSRS) report. The report contains a report header and a report footer. The report preview shows that the report is rendered correctly. You discover that when the report is rendered…
Read more
EnsurepassQUESTION 111 You maintain a SQL Server Analysis Services (SSAS) database. The database is configured by using multiple security roles. The database is accessed by a Microsoft ASP.NET application that runs on a remote computer. The application is configured to…
Read more
EnsurepassQUESTION 101 You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution has the following components: A dimension named DimTime that contains an attribute named Month A measure group named FactSales that references the DimTime dimension You need…
Read more
EnsurepassQUESTION 91 You create a SQL Server 2008 Analysis Services (SSAS) solution. You add a data source view (DSV) to the solution. The DSV has a table named Employee that includes the following columns: EmployeeKey ManagerKey The ManagerKey column references…
Read more
EnsurepassQUESTION 81 You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by using your local development environment. The package extracts data from a remote server and inserts it in the PROD database on…
Read more
EnsurepassQUESTION 71 You build and deploy a SQL Server 2008 Integration Services (SSIS) package. During package development, the XML configuration is not specified. You need to apply the configuration to the deployed package. What should you do? A. Use…
Read more
EnsurepassQUESTION 61 You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL Server 2008 database. You need to ensure that the data flow updates the existing records in the SQL Server database…
Read more
EnsurepassQUESTION 51 You work for an organization with global operations. You are responsible for the SQL Server 2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and weekly feeds. These packages are deployed via the SQL Server…
Read more
EnsurepassQUESTION 41 You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instance. You plan to document the Analysis Services performance information. You need to collect information related to cache hits from the memory when the database…
Read more
EnsurepassQUESTION 31 You build and deploy a SQL Server 2008 Integration Service (SSIS) package. During package development, the XML configuration is not specified. You need to apply the configuration file to the deployed package stored in files system. Which parameter…
Read more
EnsurepassQUESTION 21 You maintain a SQL server 2008 Analysis Services (SSAS) data warehouse for a school district. All tests are administered via a third-party application. Results are collected in your SSAS data warehouse and moved to a Scores fact table…
Read more