70-448 Exam Questions

You manage the security in SQL Server 2008 R2 Reporting Services (SSRS). You create a new role. You need to grant the following permissions to the role: Which two actions should yo...

You are designing a SQL Server 2008 Integration Services (SSIS) package. The package will be used to extract data from a SQL Server 2008 database and load data to a Microsoft Offic...

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You plan to process the aggregations of a cube by using an XML for Analysts (XMLA) script. You need to ensure that...

You administer an instance of SQL Server Analysis Services (SSAS). To troubleshoot access rights issues, you need to find out which roles are applied to a user. Which event should...

You are developing a SQL Server 2008 Reporting Services (SSRS) report. The organization requires a drilldown report that color coordinates the values of students' test scores. All...

You create a SQL Server 2008 Reporting Services (SSRS) report for a school district. The school district needs to be able to retrieve the median value of all test scores. You build...

You have a SQL Server 2008 R2 Analysis Services (SSAS) solution. You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder table with columns for OrderTot...

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You are developing a new data mining structure. You need to set the Microsoft Clustering Algorithm to meet the fol...

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your organization wants to track the times that products are ordered, shipped, and received in an existing cube. You...

You are a SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters named Region and City in that order. When the Region parameter is selected,...

You create a SQL Server 2008 Reporting Services (SSRS) report. The report is hosted in a SharePoint environment. The UserID is passed into the report automatically when the user vi...

You develop a SQL Server 2008 Reporting Services (SSRS) instance of a report model. The organization requires that users of a report be able to dynamically change the server enviro...

You maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company. An existing report on shoe sales allows the user to see the company's revenue across many diff...

You develop reports by using SQL Server 2008 Reporting Services (SSRS) Enterprise Edition. You need to use data-driven subscription to distribute reports based on dynamic subscript...

You are responsible for the SQL Server 2008 Integration Services (SSIS) instance at your organization. This instance uses SQL Server Authentication. Other developers develop, confi...

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company. You develop a package named Memberinformation.dtsx with Windows...

You are a BI developer for a financial firm. You are developing a SQL Server 2008 Integration Services (SSIS) instance to load 13 million records into TABLE_C three times daily fro...

You develop a package in SQL Server 2008 Integration Services (SSIS). You need to deploy the package so that it meets the following requirements: - Only authorized users can view a...

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses a third-party event based scheduler....

You maintain a SQL Server 2008 Analysis Services (SSAS) server. You add two new measure groups to an existing cube. You need to deploy only one of these measure groups to the produ...

You maintain a SQL Server 2008 Analysis Services (SSAS) server. After several databases are deployed to the server, you notice that the drives are nearing capacity. You need to mov...

You develop a series of SQL Server 2008 Integration Services (SSIS) packages. There are dependencies among the packages. You need to configure the packages. Which configuration typ...

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 are implementing a disaster recovery strategy for SQL Server 2008 Reporting Services (SSRS). You want to be able to restore the report catalog database in the event of a failur...

You maintain a SQL Server 2008 Reporting Services instance. Some users need to view and run reports in the Eastern Region folder on the Report Server. You need to assign these user...

You are working as reporting administrator for a product development company. The company uses SQL Server 2008 Reporting Services (SSRS) deployed in native mode. You need to deploy...

You install and configure a SQL Server 2008 Reporting Services (SSRS) instance on a server named ReportServer in the domain ABC.Com. SSRS is using a local database. You need to set...

You develop a report by using SQL Server 2008 Reporting Services (SSRS). The report has a dataset that contains 25 columns of data. You plan to render the dataset to a Microsoft Ex...

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 maintain a SQL Server 2008 Analysis Services (SSAS) instance. You plan to update only the Products dimension while processing the cube by using an XML for Analysis (XMLA) scrip...

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Engineering group. You configure a new role na...

Your company network includes a SQL Server 2008 R2 database server with the SQL Server 2008 Analysis Services (SSAS) role enabled. You design a cube named Materials with a measure...

You are an ETL developer for a mortgage company. In your application you have to load data from a Microsoft Excel source and an OLE DB source. The Excel source contains vendor data...

You develop a SQL Server 2008 Integration Services (SSIS) package. You need to modify the package to log event data from a text file to the SQL Server database. Which two actions s...

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

You maintain a SQL Server 2008 Integration Services (SSIS) instance. You develop a package that creates the temporary table *employee_stgl and then loads the data from an Excel sou...

You maintain a SQL Server 2008 Integration Services (SSIS) instance. You use the Execute SQL task to create a table in a Control Flow. Following the Execute SQL task is a Data Flow...

You design a report by using SQL Server 2008 Reporting Services (SSRS). The report contains a dataset that has 25 million rows of data. The report is rendered by using the HTML ren...

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You need to configure the analysis services query log for the SSAS instance. Which tool should you use?

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You have a cube that contains an unprocessed dimension. When a user attempts to process the cube, the dimension da...

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

Your organization has five departments. You are developing a SQL Server 2008 Integration Services (SSIS) project to calculate salary increases and bonuses under each particular man...

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 maintain a SQL Server Integration Services (SSIS) instance that uses Windows Authentication. You need to determine if there is a package named DailyLoad in the MSDB database on...

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

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You plan to process a cube by using an XML for Analysis (XMLA) script. You need to ensure that aggregations are po...

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You plan to run the Usage-Based Optimization Wizard. You need to enable query logging. What should you do?

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

You are maintaining a SQL Server 2008 Analysis Services (SSAS) solution in the production environment. You modify the solution to include two new measure groups in the development...

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a dimension named Customer. You need to configure the Dimension Data settings to meet the following r...