Download New Updated (Spring 2015) Microsoft 70-448 Actual Tests 41-50

Ensurepass

 

QUESTION 41

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

 

 

QUESTION 42

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

 

Detail information is displayed each time the users render the report.

 

You need to ensure that the following requirements are met:

 

clip_image002Summary information is displayed when the report is initially rendered.

clip_image002[1]Detail information is displayed only when the users click a column header.

 

What should you do?

 

A.

On the column that contains detail information, set the hidden property to True. Set the Visibility can be toggled by another report item property to True.

B.

On the column that contains detail information, set the hidden property to False. Set the Visibility can be toggled by another report item property to False.

C.

On the column that contains detail information, set the hidden property to True. Set the Visibility can be toggled by another report item property to False.

D.

On the column that contains detail information, set the hidden property to False. Set the Visibility can be toggled by another report item property to True.

 

Correct Answer: A

 

 

 

 

QUESTION 43

You develop a SQL Server 2008 Reporting Services (SSRS) report. The report contains a parameter named Category that is used to filter a list of products. The list uses a dataset that contains the following query:

 

clip_image003

 

You modify the report parameter to allow multiple values. You need to modify the report to help search for multiple Category values by using minimum amount of development effort.

 

What should you do?

 

A.

Implement the query in a view.

B.

Implement the query in a table-valued user-defined function.

C.

Modify the query to use the IN operator instead of the = operator.

D.

Implement the query in a stored procedure that uses dynamic SQL to execute the query.

 

Correct Answer: C

 

 

QUESTION 44

You are developing a SQL Server 2008 Integration Services (SSIS) project in Business Intelligence Development Studio.

 

You configure the project properties as shown in the following image.

 

clip_image005

 

You need to create a deployment manifest for all packages in the project.

 

What should you do?

A.

Build the Integration Services project.

B.

Modify the AllowConfigurationChanges property of the project.

C.

Copy each package. Rename each copy with a .SSISDeploymentManifest file extension.

D.

View the code of each Data Transformation Services (DTS) package. Copy the first <DTS:Property> xml node to a file with a .SSISDeploymentManifest file extension.

 

Correct Answer: A

 

 

QUESTION 45

You create a SQL Server 2008 Integration Services (SSIS) package by using SQL Server 2008. You use a development server named SQL_DEV1. There is no network connectivity between the development server and the production server. You deploy the package to the SQL_PROD1 server. The package fails to execute. The error message states that the package cannot connect to the SQL_DEV1 server. You need to modify the package to refer to the SQL_PROD1 server when being executed. What should you do?

 

A.

Modify the properties of the package to use the DontSaveSensitive package protection level.

B.

Modify the deployment manifest file in Microsoft Notepad, and then modify the connection string manually.

C.

On the Connection Managers tab of the Execute Package utility, select the Connection Manager check box, and then modify the connection string.

D.

Modify the properties of the package to use the ServerStorage package protection level.

 

Correct Answer: C

 

 

QUESTION 46

You are developing a SQL Server 2008 Integration Services (SSIS) package.

 

The package performs the following tasks:

 

clip_image002[2]Processes multiple files by using a ForEach Loop container.

clip_image002[3]Imports the contents of the files to a table by using a Data Flow task.

clip_image002[4]Logs the results of the status into a table by using an Execute SQL task.

 

You need to ensure that all the tasks of the package except the Execute SQL task execute within a single transaction.

 

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

 

A.

In the Foreach Loop container, configure the TransactionOption property to NotSupported.

B.

In the Data Flow task, configure the TransactionOption property to Required.

C.

In the package, configure the TransactionOption property to Required.

D.

In the package, configure the TransactionOption property to NotSupported.

E.

In the Execute SQL task, configure the TransactionOption property to NotSupported.

F.

In the Execute SQL task, configure the TransactionOption property to Supported.

 

Correct Answer: CE

 

 

 

QUESTION 47

You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by using your local development environment. The package extracts data from a remote server and inserts it in the PROD database on the local SQL Server 2008 instance. You deploy the package to the MSDB database on the production server. You need to ensure that only users that belong to an appropriate database role can modify and execute the deployed package. You also need to ensure that these users cannot access other packages that are deployed to the server. What should you do?

 

A.

Assign the users to the db_ssisoperator role.

B.

Assign the users to the db_ssisltduser role.

C.

Assign the users to a custom database role in the PROD database.

D.

Assign the users to a custom database role in the MSDB database.

 

Correct Answer: D

 

 

QUESTION 48

You develop a package by using SQL Server 2008 Integration Services (SSIS). You use a local instance of SSIS to develop and test the package. The package uses an XML configuration file that contains a connection string. The connection string includes a user name and a password to connect to the source data. You deploy the package to the production server. You discover that validation errors occur when the package is being executed. You need to ensure that the package executes successfully in the production environment. What should you do?

 

A.

Configure the package to use the DontSaveSensitive package protection level.

B.

Configure the package to use the EncryptSensitiveWithPassword package protection level.

C.

Configure the package to use the EncryptAllWithUserKey package protection level.

D.

Remove the user name and the password from the connection string before you deploy the package.

 

Correct Answer: B

 

 

QUESTION 49

You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster. You have a complex package that takes a long time to run. You need to ensure that if the package executes during a failover, the package can be resumed at the point of failure. What should you do?

 

A.

Cluster the SSIS service. Add the SSIS service to its own cluster resource group.

B.

Cluster the SSIS service. Add the SSIS service to the SQL Server cluster resource group.

C.

Implement checkpoints within your package. Restart the package whenever a failover occurs.

D.

Implement transactions within your package. Restart the package whenever a failover occurs.

 

Correct Answer: C

 

 

 

 

 

 

 

 

QUESTION 50

You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple Execute SQL tasks. You need to configure the package to restart at the point of failure after the package downloads the files. What should you do?

 

A.

Configure the FTP tasks to support transactions.

B.

Configure the Execute SQL tasks to support transactions.

C.

Move all the FTP tasks to a sequence container.

D.

Configure the package to use a checkpoint.

 

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…