Online Access Free 70-448 Practice Test

You design a SQL Server 2008 Integration Service (SSIS) data flow that inserts data from a source query to a destination table.
You need to insert only those rows that do not already exist in the destination table. You also need to avoid the records in a status column with "Inactive" status.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A.Use the Conditional Split Transformation.
• B.Use the Fuzzy Lookup transformation.
• C.Use the Merge transformation.
• D.Use the Lookup transformation.
• E.Use the Union All transformation.

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:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
View content, definition, and property for reports.
Which three actions should you perform? (Each correct answer presents part of the solution, Choose
three.)

• A.Assign the Manage All Subscriptions task to the role.
• B.Assign the Manage Reports task to the role.
• C.Assign the Manage Resources task to the role.
• D.Assign the Consume Reports task to the role.
• E.Assign Set Security Policies for Items task to the role.

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by
using your local development environment.
You deploy the package to the file system in the production environment. The users report that the
connection strings contained in the package are blank. The package fails to execute.
You need to change the protection level of the package to ensure that users can view and execute the
package.
Which protection level should you use?

• A.EncryptAllWithUserKey
• B.ServerStorage
• C.DontSaveSensitive
• D.EncryptAllWithPassword

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 in the following table:
VendorID VendorName
1 VendorA
2 VendorB
3 VendorC
4 VendorD
5 VendorE
Sample loan data (OLE DB source) is shown in the following table:
LoanNumber VendorID LoanAmount
I-100 1 120000
I-200 1 130000
I-300 2 150000
I-400 3 150000
I-500 4 160000
I-600 4 170000
I-700 5 180000
The CIO asks you to generate an Excel file with the loan list information for each vendor. You build a SQL Server 2008 Integration Services (SSIS) package that can generate the Excel files dynamically. The Excel files should have the vendor name as the prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).
You get the error message shown in the exhibit. (Click the Exhibit button.)
You need to sort both sources in order to merge join the data.
What should you do?

• A.Set the IsSorted property to True for both the OLE DB and Excel sources.
• B.Sort the data in the select statement of the OLE DB source and use sort transformation after the Excel source.
• C.Use the sort transformation after the OLE DB source and set the IsSorted property to True for the Excel destination.
• D.Set the ISSorted property to True for the OLE DB, sort the data in the selct statement of the OLE DB source, and use sort transformation after the Excel source.

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 multidimensional storage is being updated.
What should you do?

• A.Set the OnlineMode property for the partition to OnCacheComplete.
• B.Set the OnlineMode property for the partition to Immediate.
• C.Set the ProcessingMode property for the partition to LazyAggregations.
• D.Set the ProcessingMode property for the partition to Regular.