最新的Microsoft 070-448免費考試真題

問題1

You maintain a SQL Server 2008 Analysis Service (SSAS) database in a test environment. You plan to deploy changes from as SSAS project in a development environment to the test environment are replaced by the deployment.
What should you do?

A. Back up the development database and restore it to the test environment.

B. Process the database by using the Business Intelligence Design Studio (BIDS).

C. Update the database by using the Synchronize Database Wizard.

D. Update the database by using the Deployment Wizard.

正確答案: A

問題2

You develop a SQL Server 2008 Integration Services (SSIS) package.
The structure of the package is as shown in the following exhibit.
You need to define a variable that contains sensitive information that is only available to the Sequence
Container, the Data Flow Task, and the Execute SQL Task.
What should you do?

A. Create the variable at the package scope.

B. Create the variable at the Data Flow Task scope.

C. Create the variable at the Execute SQL Task scope.

D. Create the variable at the Sequence Container scope.

正確答案: D

問題3

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You add a data source view (DSV) to the solution. The DSV has a table named Employee that includes the
following columns:
EmployeeKey
ManagerKey
The ManagerKey column references the manager of the employees.
You need to define the relationship between the employees and their manager in the DSV.
What should you do?

A. Create a relationship by using EmployeeKey as the source column and ManagerKey as the destination column.

B. Create a Named Calculation that uses EmployeeKey and ManagerKey

C. Create a relationship by using ManagerKey as the source column and EmployeeKey as the destination column.

D. Create a Named Query that uses a relationship with EmployeeKey as the source column and ManagerKey as the destination column.

正確答案: C

問題4

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

A. dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"

B. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)

C. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx

D. dtexec /f " Z:\ Memberinformation.dtsx " /conf "
Z: \Memberinformationconfig,cfg "

E. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx

F. dtexec /sq Memberinformation /ser productionServer / va

G. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx

H. dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation

正確答案: C

問題5

You are developing a sales report by using SQL Server 2008 Reporting Services (SSRS).
The report contains a table.
You need to implement a technology that allows users to open a new report when they click on a field in a
table.
Which SSRS technology should you use?

A. Subreport

B. Interactive Sorting

C. Tablix Data Region

D. Drillthrough action

正確答案: D

問題6

You update a role named Managers for the Human Resources cube in your SQL Server 2008 Analysis
Services (SSAS) database. The database contains a dimension named Employee.
You plan to configure the security for the Managers role.
You need to allow the Managers role to access aggregate data based on only three or less employees.
What should you do?

A. Add members of the [Employee].[Employees] hierarchy that contain three or less children to the denied set for the Managers role.

B. Add the following expression to the Allow Reading property in Cell Data in the Managers role. IIF(Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count <= 3, [Employee]. [Employees].CurrentMember, null)

C. Add the following expression to the Allow Reading property in Cell Data in the Managers role. Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count <= 3

D. Add members of the [Employee].[Employees] hierarchy that contain more than three children to the allowed set for the Managers role.

正確答案: C

問題7

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?

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: D

問題8

You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report uses the "User!UserID" expression in a text box within the report header.
You need to ensure that data-driven subscriptions successfully execute for this report.
What should you do?

A. Remove the expression from the report header.

B. Configure the report to use no credentials.

C. Modify the expression in the report header as "User!UserName."

D. Configure the report to use stored credentials.

正確答案: A

問題9

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a Product dimension.
The dimension contains the Category and Subcategory attributes.
The attributes have a Rigid relationship typE.The data source for the Product dimension changes the
relationship between the Category and Subcategory values.
You need to execute an XML for Analysis (XMLA) command to process the dimension to successfully
reflect the changE.What should you do?

A. Use the ProcessIndexes command.

B. Use the ProcessUpdate command.

C. Use the ProcessClear and the ProcessDefault commands.

D. Use the ProcessAdd command.

正確答案: C

最新的Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan - 070-448免費考試真題

聯系我們

站內鏈接

最新更新