Download New Updated (Spring 2015) Microsoft 70-448 Actual Tests 51-60

Ensurepass

 

QUESTION 51

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: C

 

 

QUESTION 52

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

 

 

QUESTION 53

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

 

 

QUESTION 54

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

 

 

QUESTION 55

You maintain an instance of SQL Server 2008 Reporting Services (SSRS). The instance contains several reports. You deploy a report project on the instance by using the Business Intelligence Development Studio (BIDS). You discover that the production data sources on the instance are replaced by the test data sources of the report project. You need to ensure that when the report project is deployed in future, the existing reports are unaffected. What should you do?

 

A.

Configure the OverwriteDataSources property.

B.

Configure the TargetServerURL property.

C.

Configure the TargetDataSourceFolder property.

D.

Configure the TargetReportFolder property.

 

Correct Answer: A

 

 

QUESTION 56

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

 

A.

Use the SSIS log provider for the SQL Profiler.

B.

Use the SSIS log provider for the text file.

C.

Use a Flat File Destination component.

D.

Use a Raw File Destination component.

E.

Add an Error output to the Data Flow component

 

Correct Answer: CE

 

 

 

 

 

 

 

 

 

 

QUESTION 57

You implement a SQL Server 2008 Integration Services (SSIS) package. The package contains the following components:

 

clip_image002A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit button.)

 

clip_image004

 

clip_image002[1]A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click the Exhibit button.)

 

clip_image006

 

clip_image002[2]A String variable named FileName.

clip_image002[3]A String variable named DirectoryPath.

 

You need to update the package so that the DirectoryPath variable returns the directory path for the file path stored in the FileName variable. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

 

A.

Set the RaiseChangedEvent property of the User::FileName variable to True.

B.

Set the EvaluateAsExpression property of the User::DirectoryPath variable to True.

C.

Add a Script task to the OnPostExecute event handler of the Foreach Loop container.

D.

Set the Expression property of the User::DirectoryPath variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) – FINDSTRING( REVERSE( @[User::FileName] ), “\”, 1 ))

E.

Set the Expression property of the User::FileName variable to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) – FINDSTRING( REVERSE( @[User::FileName] ), “\”, 1 ))

 

Correct Answer: BD

 

 

 

 

QUESTION 58

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?

 

A.

Use the Data Viewer tool.

B.

Use the Data Profiling task.

C.

Use the Audit transformation.

D.

Use breakpoints in the Script component.

 

Correct Answer: A

 

 

QUESTION 59

You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a Data Flow task that copies several million rows. The data flow requires a match against a reference table that contains 10,000 rows. Each row in the reference table will be used during the data flow. You need to ensure that the data flow executes in the minimum amount of time. Which data flow component should you select?

 

A.

a Fuzzy Lookup transformation

B.

a Lookup transformation along with the Full cache option

C.

a Lookup transformation along with the No cache option

D.

a Lookup transformation along with the Partial cache option

 

Correct Answer: B

 

 

QUESTION 60

You build and deploy a SQL Server 2008 Integration Services (SSIS) package. During package development, the XML configuration is not specified. You need to apply the configuration to the deployed package. What should you do?

 

A.

Use the Deployment utility.

B.

Use the SETX command line utility.

C.

Use the DTUTIL command line utility.

D.

Use the DTEXEC command line utility.

 

Correct Answer: D

 

Free VCE & PDF File for Microsoft 70-448 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…