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

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 a query for more than 30,000 ms.
Which DMV should you use?

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

You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a tablE.You need to ensure that alternate rows in the table have a pale green
backgrounD.Which code segment should you use for each text box?

• A.=iif(CountRows() / 2, "PaleGreen", "White")
• B.=iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")
• C.=iif(CountRows() Mod 2, "PaleGreen", "White")
• D.=iif(RowNumber(Nothing) / 2, "PaleGreen", "White")

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loop container.
Imports the contents of the files to a table by using a Data Flow task.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package except the Execute SQL task execute within a single
transaction.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.In the package, configure the TransactionOption property to NotSupported.
• B.In the Execute SQL task, configure the TransactionOption property to Supported.
• C.In the Foreach Loop container, configure the TransactionOption property to NotSupported.
• D.In the package, configure the TransactionOption property to Required.
• E.In the Data Flow task, configure the TransactionOption property to Required.
• F.In the Execute SQL task, configure the TransactionOption property to NotSupported.

You design a SQL Server 2008 Integration Services (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.What are two possible
ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

• A.Use the Union All transformation.
• B.Use the Lookup transformation.
• C.Use the Merge transformation.
• D.Use the Merge Join transformation.
• E.Use the Fuzzy Grouping transformation.
• F.Use the Fuzzy Lookup transformation.

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The cube structure is as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension.
What should you do?

• A.Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.
• B.Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.
• C.Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.
• D.Create a regular relationship between DimCustomer and FactTransaction.