70-448 Exam Questions

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a Product dimension. The dimension contains the Category and Subcategory attributes. The attributes h...

You maintain a SQL Server 2008 Analysis Services (SSAS) database on a production server. The database contains a cube. You add new functionality to the cube on a development server...

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 info...

You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Sales group. You configur...

You maintain a SQL Server 2008 Reporting Services (SSRS) instance. The network security model for the domain that hosts the instance changes. You need to ensure that the instance w...

You plan to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008 failover cluster. Internet Information Services (IIS) is installed on both nodes of the cluster. T...

You maintain a SQL Server 2008 Reporting Services (SSRS) database server. The instance contains a large number of reports that take a long time to execute. The reports contain mult...

You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a folder named Management Reports. All groups can view and modify reports in any fo...

You maintain a SQL Server 2008 Reporting Services (SSRS) instance. A developer accidentally deploys 1000 reports to the SSRS instance. You need to restore the SSRS instance to its...

You create a report by using SQL Server 2008 Reporting Services (SSRS). You plan to deploy the report on a report server. The report will be delivered on a regular basis to a dynam...

You create a report by using SQL Server 2008 Reporting Services (SSRS). The report is complex and takes several minutes to generate. You need to configure the report server to cach...

You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the following exhibit. (Click the Exhibit button.) You need to ensure that the Amo...

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a table named Orders that contains the following columns: OrderKey Shipper OrderAmount You create a dimensi...

You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining extensions (DMX) to query a data mining model. You write the following DMX code segment to qu...

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a key performance indicator (KPI) named GPMargin for your solution. You set the Value expression of the K...

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 me...

You create a SQL Server 2008 Analysis Services (SSAS) solution. You enable proactive caching for a partition. You need to ensure that SSAS can query relational data when multidimen...

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named DimCustomer that contains the following three attributes: - Customer - City - Country T...

You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the following exhibit. (Click the Exhibit button.) The Ownership column contains d...

You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution includes a table named FactOrders that contains two columns as shown in the following table: You need t...

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named DimProduct that contains an attribute named Price. You use the DimProduct dimension in...

You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat files and loads this data to a SQL Server 2008 database. The package contains...

You develop a SQL Server 2008 Integration Services (SSIS) package. You need to modify the path where the package writes event data to a text file. What should you do?

You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business Intelligence Development Studio. The package uses a custom data flow component. The package...

You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a source query to a destination table. You need to insert only those rows that do not alre...

You implement a SQL Server 2008 Integration Services (SSIS) package. The package contains the following components: - A data flow task contained in a For Loop container - A Flat Fi...

You modify a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from a text file and loads this data to a SQL Server 2008 table as shown in the followin...

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two sources. Each source database is located on a different server. Each source i...

You are developing a SQL Server 2008 Integration Services (SSIS) package. The package uses an OLE DB connection manager to connect to a third-party database server. The database do...

You create a SQL Server 2008 Reporting Services (SSRS) report. You plan to create a list of customers by using a List control. For each customer in the List control, you plan to in...

You create a SQL Server 2008 Reporting Services (SSRS) report. The report contains a table. You need to ensure that alternate rows in the table have a pale green background. Which...

You develop a SQL Server 2008 Reporting Services (SSRS) report. A Multidimensional Expressions (MDX) query used in the report contains a parameter to display sales data for various...

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 nee...

You create a report in SQL Server 2008 Reporting Services (SSRS) solution. You write the following code segment in the report. The code segment generates errors when compiled. You...

You develop a SQL Server 2008 Reporting Services (SSRS) solution. You add a report that contains a single dataset and a query parameter. You need to ensure that the report executes...

You design a report by using SQL Server 2008 Reporting Services (SSRS). The report will be included in a Windows Forms application that is distributed to remote users. These users...

You design a report by using SQL Server 2008 Reporting Services (SSRS). Detail information is displayed each time the users render the report. You need to ensure that the following...

You develop a SQL Server 2008 Reporting Services (SSRS) report. The report contains a parameter named Category that is used to filter a list of products. The list uses a dataset th...

You are developing a SQL Server 2008 Integration Services (SSIS) project in Business Intelligence Development Studio. You configure the project properties as shown in the following...

You create a SQL Server 2008 Integration Services (SSIS) package by using SQL Server 2008. You use a development server named SQL_DEV1. There is no network connectivity between the...

You are developing a SQL Server 2008 Integration Services (SSIS) package. The package performs the following tasks: - Processes multiple files by using a ForEach Loopcontainer. - I...

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...

You administer a SQL Server 2008 Analysis Services (SSAS) instance. You plan to troubleshoot query performance by using a Dynamic Management View (DMV). You need to identify query...

You update a role named Managers for the Human Resources cube in your SQL Server 2008 Analysis Services (SSAS) database. The database contains a dimension named Employee. You plan...

You maintain a SQL Server 2008 Analysis Services (SSAS) database. You plan to refresh data in a partition every two hours. You need to implement the incremental processing strategy...

You maintain a SQL Server 2008 Analysis Services (SSAS) database. You create a new measure group in one of the cubes. You have a program that maintains partitions on the production...

You maintain a SQL Server 2008 Analysis Services (SSAS) database in a test environment. You plan to deploy changes from an SSAS project in a development environment to the test env...

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database. You change the DataDir property of the instance to a new folder. You need to ens...

You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary p...

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company wh...