070-448 無料問題集「Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan」
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to troubleshoot query performance by using SQL Profiler.
You need to replay the queries issued to the SSAS database.
Which three trace events should you use? (Each correct answer presents part of the solution.
Choose three.)
You plan to troubleshoot query performance by using SQL Profiler.
You need to replay the queries issued to the SSAS database.
Which three trace events should you use? (Each correct answer presents part of the solution.
Choose three.)
正解：A、C、D
解答を投票する
You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat
files and loads this data to a SQL Server 2008 database.
The package contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is
executed on week days, the @IsWeekday variable is set to True. When the package is executed on
holidays, the @IsHoliday variable is set to TruE.You need to implement the following business logic in the
control flow of the package:
When the @IsWeekday variable is set to True, the Perform Weekday Processing Data Flow task is
executed.
When the @IsWeekday variable is set to False, the Perform Weekend Processing Data Flow task is
executed.
When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task is executed.
Which control flow logic should you implement?
files and loads this data to a SQL Server 2008 database.
The package contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is
executed on week days, the @IsWeekday variable is set to True. When the package is executed on
holidays, the @IsHoliday variable is set to TruE.You need to implement the following business logic in the
control flow of the package:
When the @IsWeekday variable is set to True, the Perform Weekday Processing Data Flow task is
executed.
When the @IsWeekday variable is set to False, the Perform Weekend Processing Data Flow task is
executed.
When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task is executed.
Which control flow logic should you implement?
正解：D
解答を投票する
Note: This question is part of a series of questions that use the same or similar answer choices. An answer
choice may be correct for more than one question in the series. Each question is independent of the other
questions in this series. Information and details provided in a question apply only to that question.
You are SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters
names State and City in that order.
When the State parameter is selected, the City parameter should be filtered by the State selected.
You need to enable this functionality.
What should you do?
choice may be correct for more than one question in the series. Each question is independent of the other
questions in this series. Information and details provided in a question apply only to that question.
You are SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters
names State and City in that order.
When the State parameter is selected, the City parameter should be filtered by the State selected.
You need to enable this functionality.
What should you do?
正解：F
解答を投票する
You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a
Data Flow task.
You need to modify the package to write all rows that generate errors to a text file.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Data Flow task.
You need to modify the package to write all rows that generate errors to a text file.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
正解：C、D
解答を投票する
You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report will be included in a Windows Forms application that is distributed to remote users. These users have access to the report server.
You need to ensure that the application renders the report correctly. What should you do?
The report will be included in a Windows Forms application that is distributed to remote users. These users have access to the report server.
You need to ensure that the application renders the report correctly. What should you do?
正解：A
解答を投票する
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimProduct that contains an attribute named Price. You use the
DimProduct dimension in a cube.
You need to ensure that aggregations are not associated with the Price attribute.
What should you do?
You create a dimension named DimProduct that contains an attribute named Price. You use the
DimProduct dimension in a cube.
You need to ensure that aggregations are not associated with the Price attribute.
What should you do?
正解：D
解答を投票する
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in the question apply only to that question.
You maintain the SQL Server 2008 integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses third-party event based scheduler.
You develop a package named Memberinformation.dtsx and save it in the SSIS packages folder on the company network.
You need to deploy this package by connecting with the DBPROD production server SSIS engine. The event based scheduler will execute the deployed SSIS package.
Which command syntax should you use
You maintain the SQL Server 2008 integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses third-party event based scheduler.
You develop a package named Memberinformation.dtsx and save it in the SSIS packages folder on the company network.
You need to deploy this package by connecting with the DBPROD production server SSIS engine. The event based scheduler will execute the deployed SSIS package.
Which command syntax should you use
正解：H
解答を投票する
You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows.
You need to monitor the data that passes through each path in the data flow by using the Business
Intelligence Development Studio. You also need to ensure that data flow logic is retained.
What should you do?
You need to monitor the data that passes through each path in the data flow by using the Business
Intelligence Development Studio. You also need to ensure that data flow logic is retained.
What should you do?
正解：D
解答を投票する
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?
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?
正解：C
解答を投票する
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?
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?
正解：C
解答を投票する