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 SSRS to use a new domain user account named ReportUser. The
password for ReportUser is Alphabet01.
Which script should you run?

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 Excel worksheet.
You need to implement drilldown technology when rendering to Excel.
Which type of data region should you use?

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 sessions that execute more than 10 commands prior to
disconnecting. Which DMV should you use?

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) script.
You need to ensure that only the dimensions are updated.
What should you do?

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 named Engineering and Design by using the following allowed
permission set:
{[Employees].[Department].[Engineering and Design]}
You assign the Engineering group to the Engineering and Design role.
You need to ensure that users in the Engineering and Design role can only view data for
their department.
What should you do?

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 group named MaterialsInventory. This
group has a measure, QuantityOnHand, which shows the total stock in inventory for the
company by time.
You need to determine the inventory at the end of a quarter.
What should you do?

DRAG DROP
You are an ETL Developer for a mortgage company. You have two staging sources named
Stg_Vendor and Stg_Loan that you need to load into a destination table named Loan.
Stg_Vendor is a Microsoft Excel source.
The following table shows Stg_Vendor (Excel source) sample data:

The following table shows Stg_Loan sample data:

The following table shows Loan sample data:

You need to build the ETL package.
What should you do? (To answer, drag the appropriate components to the correct locations
in the answer area.
Each component may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.)

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 and has approximately 1000 records.
The OLE DB source contains loan data and has approximately 1,000,000 records.
Sample vendor data (Excel source) is shown in the following table:

Sample loan data (OLE DB source) is shown in the following table:

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?

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 should you perform? (Each correct answer presents part of the solution.
Choose two.)

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