Tag: 70-448 Dumps

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 are grouped by the first character in the LastName column. Which expression in the Group properties dialog box should you use?   A. =First(Fields!LastName) B. =Fields!LastName.Value C. =First(Fields!LastName.Value) D. =Fields!LastName.Value.Substring(0,1) 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 as a PDF file, even-numbered pages are rendered blank. You need to modify the report to prevent the rendering of blank pages. What should you do?   A. Reduce the overall width of the report. B. Reduce the page size of the report. C. Reduce 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 use Windows Authentication. You need to ensure that the users of the application can successfully access the SSAS database. You also need to ensure that security restrictions of the roles are applied. What should you do?   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 to ensure that the aggregations designed on FactSales always include the Month attribute. What should you do?   A. Set the Usage property appropriately. B. Set the IsAggregatable property appropriately. C. Set the 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 the manager of the employees. You need to define the relationship between the employees and their manager in the DSV. What should you do?   A. Create a Named Calculation that uses EmployeeKey and ManagerKey B. Create a relationship 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 the local SQL Server 2008 instance. You deploy the package to the MSDB database on the production server. You need to ensure that only users that belong to an appropriate database role can modify and execute the deployed package. You also need to ensure 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 the Deployment utility. B. Use the SETX command line utility. C. Use the DTUTIL command line utility. D. Use the DTEXEC command line utility.   Correct Answer: D Explanation Explanation/Reference:     QUESTION 72 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 by using data from the rows in your data flow. Which data flow component should you use?   A. SQL Server Destination B. OLE DB Destination C. OLE DB Command Transformation D. Data Conversion Transformation   Correct Answer: C Explanation/Reference: 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 method. These servers reside in geographies with a high risk of natural disaster. You need to implement a disaster recovery plan to back up the SSIS packages for availability. What should you back up?   A. The tempdb database B. 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 is processed. Which object should you use?   A. MSAS 2008: Memory B. MSAS 2008: Cache C. MSAS 2008: Proc Aggregations D. MSAS 2008: Storage Engine Query   Correct Answer: D Explanation/Reference:     QUESTION 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 should you set in the DTEXEC command line utility?   A. /CheckF B. /Set C. /conf D. /L   Correct Answer: C Explanation Explanation/Reference:     QUESTION 32 You develop a SQL Server 2008 Integration 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 for analysis. This warehouse also includes a Student Dimension which contains attributes related to each student. The school year is starting, and the district administration wants the Student Dimension updated hourly so that new students can Read more [...]

EnsurepassQUESTION 11 You create a SQL Server 2008 R2 Analysis Services (SSAS) solution. You are configuring security settings for a new database role with the following requirements: Only the West member can be viewed by the database role. All other existing members and any newly added members of the Region attribute will not be visible. Members in attribute hierarchies that include a member of the Region attribute remain visible. The members in other attribute hierarchies remain visible. The Read more [...]

EnsurepassQUESTION 1 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 vender data and has approximately 1000 records. The OLE source contains loan data and has approximately 1,000,000 records. Sample vendor data (Excel source) is shown in the following table: VendorID VendorName 1 VendorA 2 VendorB 3 VendorC 4 VendorD 5 VendorE Sample loan data (OLE DB source) is shown Read more [...]