70-448 무료 덤프문제 온라인 액세스

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. The IIS is virtualized on the
Network Load Balancing (NLB) cluster.
You need to deploy SSRS in a fault-tolerant scale-out deployment.
What should you do?

• A.Install SSRS on both cluster nodes to use separate ReportServer databases.
• B.Install SSRS on both cluster nodes and cluster the SSRS service by using the SQL Server resource group.
• C.Install SSRS on both cluster nodes and cluster the SSRS service by using a new resource group.
• D.Install SSRS on both cluster nodes to use the same ReportServer database.

You are an ETL developer for a mortgage company. Your application has two tables names Vendor and Loan.
Vendor
VendorID VendorName 1 VendorA
2 VendorB
3 VendorC
4 VendorD
5 VendorE
Loan
LoanNumber VendorID LoanAmount
I-100 1 120000
I-200 1 130000
I-300 2 150000
I-400 3 155000
I-500 4 160000
I-600 4 170000
I-700 5 180000
You need to build a SQL Server 2008 Integration Services (SSIS) package that meets the following
requirements:
The package should be able to generate the Excel files dynamically. Each file should have the vendor name
as a prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).
All the vendor names should be added to a variable and loop through the variable to generate and load
separate files for each vendor dynamically.
Which property in the Excel file destination connection manager should you set with a variable?

• A.Provider
• B.Excel File Path
• C.Name
• D.Initial Catalog

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?

• A.Discover_Commands
• B.Discover_Sessions
• C.Discover_Traces
• D.Discover_Connections

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two sources: a Mircosoft Excel sources and ADO.net. The ADO.net source is based on a SELECT statement that uses an ORDER BY clause.
The data flow is as shown in the following exhibit. (Click the Exhibit button.)
When the paths from the two sources are connected to the Merge Join component, the following error
message is displayed:
Data Flow Task: the input is not sorted. The `input "Merge Join Left Input"(48)' must be sorted.
You need to ensure that data from each query is included in each row in the data flow.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A.Add an OLE DB Command transformation for each data flow.
• B.Add a Sort transformation for the Excel source.
• C.Update the sorting properties in the ADO.net source component.
• D.Replace the Merge Join transformation with a Union All transformation.

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?

• A.SQL Server Configuration Manager
• B.SQL Server Management Studio
• C.SQL Server Error and Usage Reporting
• D.SQL Server Business Intelligence Development Studio