Latest MCTS 70-448 Dumps Real Exam Download 131-140

Ensurepass

QUESTION 131

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?

 

A. =First(Fields!LastName)

B. =Fields!LastName.Value

C. =First(Fields!LastName.Value)

D. =Fields!LastName.Value.Substring(0,1)

 

Correct Answer: D

Explanation

Explanation/Reference:

 

 

QUESTION 132

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 no access to the report server.

You need to ensure that the application renders the report correctly.

What should you do?

 

A. Use the ReportViewer control along with the LocalReport property.

B. Use the ReportViewer control along with the RemoteReport property. 

C. Use the Render method of the Reporting Services Simple Object Access Protocol (SOAP) API.

D. Use the RenderStream method of the Reporting Services Simple Object Access Protocol (SOAP) API.

 

Correct Answer: A

Explanation

Explanation/Reference:

 

 

QUESTION 133

You create a report by using SQL Server 2008 Reporting Services (SSRS).

The report is complex and takes several minutes to generate.

You need to configure the report server to cache the report for 30 minutes after the initial request.

What should you do?

 

A. Implement report snapshots.

B. Implement report execution caching.

C. Configure the data source to use snapshot isolation.

D. Configure the data source to use a database snapshot.

 

Correct Answer: B

Explanation

Explanation/Reference:

 

 

QUESTION 134

You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instancE.The report contains query parameters that allow users to filter the contents of the report. The report queries the data source randomly.

You configure the report to be rendered from a report execution snapshot.

You need to ensure that users can continue to use parameters to filter the report.

What should you do?

 

A. Add a default value to all parameters.

B. Modify the datasets to use the Table query type.

C. Remove the filters from the dataset queries. Use the parameters to filter the datasets.

D. Move the queries to the stored procedures. Use the stored procedures to populate and filter the datasets of the report.

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 135

You create a report by using SQL Server 2008 Reporting Services (SSRS).

You plan to deploy the report on a report server. The report will be delivered on a regular basis to a dynamic list of subscribers.

You need to create a new subscription on the report server.

What should you do?

 

A. Select the report you created, and then click the New Subscription button.

B. Select the My Subscriptions page, and then click the New Data-driven Subscription button.

C. Select the report you created. Click the Subscriptions tab, and then click the New Data-driven Subscription button.

D. Select the report you created. Click the Subscriptions tab, and then click the New Subscription button.

 

Correct Answer: C

Explanation Explanation/Reference:

 

 

 

QUESTION 136

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. Configure the report to use stored credentials.

D. Modify the expression in the report header as “User!UserName.”

 

Correct Answer: A

Explanation

Explanation/Reference:

 

 

QUESTION 137

You maintain a SQL Server 2008 Reporting Services (SSRS) instance.

Your instance supports several different rendering extensions.

You need to configure the server so that all reports render only to Microsoft Excel.

What should you do?

 

A. Modify the Global.asax filE.B.Modify the Web.config file.

B. Modify the RSMgrPolicy.config file.

C. Modify the RSReportServer.config file.

 

Correct Answer:

Explanation/Reference:

 

 

QUESTION 138

You install and configure SQL Server 2008 Reporting Services (SSRS) instance.

The users of the report server plan to deliver reports through e-mail messages.

You need to configure the report server for e-mail message delivery by using a remote SMTP server.

What should you do?

 

A. Modify the rssrvpolicy.config file.

B. Modify the RSReportServer.config file.

C. Modify the Web.config file.

D. Modify the Global.asax file.

 

Correct Answer: B

Explanation

Explanation/Reference:

 

 

QUESTION 139

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 to use the same ReportServer database.

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 and cluster the SSRS service by using the SQL Server resource group.

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 140

You are managing the security in SQL Server 2008 Reporting Services (SSRS).

You assign a new user to a role.

You need to grant the permissions to the user to publish reports and manage content only in a private folder.

What should you do?

 

A. Assign the user to the Publisher role.

B. Assign the user to the My Reports role.

C. Assign the user to the Content Manager and the Browser roles.

D. Assign the user to the Content Manager and the Report Builder roles.

 

Correct Answer: B

Explanation

Explanation/Reference:

 

 

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