Latest MCTS 70-448 Dumps Real Exam Download 11-20

Ensurepass

QUESTION 11

You create a SQL Server 2008 R2 Analysis Services (SSAS) solution.

You are configuring security settings for a new database role with the following requirements:

Only the West member can be viewed by the database role. All other existing members and any newly added members of the Region attribute will not be visible.

Members in attribute hierarchies that include a member of the Region attribute remain visible. The members in other attribute hierarchies remain visible.

The state of Washington is visible.

The aggregated totals for the ALL Level and Region attributes include only the values for members that are visible.

You need to ensure that the database role has these security settings.

What should you do? (Each correct answer presents part of the solution. Choose two.)

 

A. Set the Region attribute’s IsAllowed = False, DeniedSet = “Except(Region..Members,{West})”, ApplyDenied = False, and VisualTools = False.

B. Set the Region attribute’s IsAllowed = True, DeniedSet = “Except(Region..Members,{West})”, ApplyDenied = False, and VisualTools = True.

C. Set the State attribute’s IsAllowed = True, AllowedSet = “Except(Region..Members,{West})”, ApplyDenied = True, and VisualTools = False.

D. Set the State attribute’s IsAllowed = True, AllowedSet = “Except(Region..Members,{West} + {Washington})”, ApplyDenied = False, and VisualTools = False.

 

Correct Answer: BD

Explanation

Explanation/Reference:

 

 

QUESTION 12

You create a SQL Server 2008 R2 Reporting Services (SSRS) solution. The organization requires a drilldown report that color coordinates the values of the student’s’ test scores. All average scores 70% or higher should have a green background. All lower average scores should have a red background.

You need to enable this functionality.

Which expression should you use?

 

A. =iif(avg(Fields!TestScore.Value) >= .70,”Green”,”Red”

B. =iif(Fields!TestScore.Value >= .70 THEN “Green” ELSE “Red”)

C. =iif(Fields!TestScore.Value >= .70,Green”,”Red”)

D. =iif(avg(Fields!TestScore.Value) >= .70 THEN “Green”,”Red”

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 13

You create a SQL Server 2008 R2 Reporting Services (SSRS) solution.

The school district needs to be able to retrieve the median value of all tests scores.

You build a custom function named Median that accepts the test scores and returns the median test score.

You need to run this custom function.

Which expression should you use?

 

A. =Execute Function Median(Fields!TestScores)

B. =Code.Function.Median()

C. =Code.Median(Fields!TestScores)

D. =Execute.Median(Fields!TestScores)

 

Correct Answer: C

Explanation

Explanation/Reference:

 

 

QUESTION 14

You are developing a SQL Server 2008 Reporting Services (SSRS) report which utilizes a matrix.

You define a group based on the Name column in the main report dataset. The format of the data in the column includes “FirstName  LastName.”

You need to group the matrix by FirstName.

Which expression should you use?

 

A. =First(Fields!Name.Valuse)

B. =Left(Fields!Name.Value,9)

C. =Left(Fields!Name.Value,Len(Fields!ClassName.Value)

D. =(Fields!Name.Value,InStr(Fields!ClassName.Value,”-“))

 

Correct Answer: D

Explanation

Explanation/Reference:

 

 

QUESTION 15

You are developing a SQL Server 2008 Reporting Services (SSRS) report that will be run by managers only. Each manager’s EmpID will be passed into the report at runtime.

The managers want to be able to see a graphical display of sales grouped by product. Each store’s data should be displayed on a separate page.

You need to enable this functionality.

What should you use?

 

A. Image

B. Matrix

C. Table

D. List

 

Correct Answer: D

Explanation/Reference:

 

 

QUESTION 16

You are developing a SQL Server 2008 Reporting Service (SSRS) report for a DotNetNuke (DNN) application. The DNN application and SSRS are located on the same server. A custom module has been built in DNN to display the reports.

You need to enable the DNN application to connect to the report.

What should you do?

 

A. Modify the RSReportServer.config file.

B. Deploy the report to the Report Server.

C. Use the SSRS Web service.

D. Modify the properties of ServerURL.

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 17

You are working as reporting administrator for a product development company. The company uses SQL Server 2008 Reporting Services (SSRS) deployed in a native mode.

You need to deploy multiple reports via InstallShield.

Which three components are you required to use? (Each correct answer presents part of the solution. Choose three.)

 

A. Rsconfig utility

B. RS.exe

C. ReportService2005.asmx

D. Report Builder

E. .RSS File

 

Correct Answer: BCE

Explanation

Explanation/Reference:

 

 

QUESTION 18

You are an ETL developer. You maintain a SQL Server 2008 Integration Services (SSIS) instance.

You need to develop a parent package that meets the following requirements:

The parent package can execute child packages by using multiple execute Package tasks.

A notification needs to be sent before executing the parent package and after executing all child packages.

If any packages have errors during execution, the subsequent package should run after the failure.

Only one error notification email should be sent that lists all package errors from the parent package.

What should you do? (Each correct answer presents part of the solution. Choose three.)

 

A. Set the precedence constraints between child packages to success.

B. Set the precedence constraints between child packages Completion.

C. Add a Send Mail Task to the child packages’ OnPostExecution event handler.

D. A Add a Send Mail Task to the child packages’ OnPostExecution event handler.

E. dd a Send Mail Task to the parent packages’ OnError event handler.

 

Correct Answer: BDE

Explanation

Explanation/Reference:

 

 

QUESTION 19

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.)

 

A. Audit Login event with all its data columns.

B. Query Begin event with all its data columns.

C. Query End event class with all its data columns.

D. Audit Logout event class with all its data columns.

E. Command Events class with all its data columns.

 

Correct Answer: ABC

Explanation

Explanation/Reference:

 

 

QUESTION 20

You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instance.

You need to collect information to determine if performance issues are related to hardware limitations or latch wait contention.

Which three objects should you use? (To answer, select the appropriate objects in the answer area. Each correct answer presents part of the solution. Choose three.)

 

A. Correct

B. Wrong

C. Wrong

D. Correct

E. Wrong

F. Correct

 

Correct Answer: ADF

Explanation/Reference:

 

 

Download Lates MCTS 70-448 Real Free Tests , help you to pass exam 100%.