Latest MCTS 70-448 Dumps Real Exam Download 41-50

Ensurepass

QUESTION 41

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

You plan to document the Analysis Services performance information.

You need to collect information related to cache hits from the memory when the database is processed.

Which object should you use?

 

A. MSAS 2008: Memory

B. MSAS 2008: Cache

C. MSAS 2008: Proc Aggregations

D. MSAS 2008: Storage Engine Query

 

Correct Answer: D

Explanation/Reference:

 

 

QUESTION 42

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

You plan to update only the Products dimension while processing the cube by using an XML for Analysis (XMLA) script.

You need to ensure that only the dimensions are updated.

What should you do?

 

A. Execute a processIndex command.

B. Execute a processUpdate command.

C. Execute a processStructure command.

D. Execute a processDefault command.

 

Correct Answer: B

Explanation Explanation/Reference: 50.

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

When you process the Analysis Services database using the Process Add option in Management Studio, you discover that a KeyNotFound error occurs.

You need to modify the ErrorConfiguration property so that the error condition id reported and processing continues.

Which object should you modify?

A. Cube

B. Partition

C. Dimension

D. Measure group

 

Answer: D

 

 

QUESTION 43

You develop a report by using SQL Server 2008 Reporting Services (SSRS). The report has a dataset that contains 25 columns of data. You plan to render the dataset to a Microsoft Excel worksheet.

You need to implement drilldown technology when rendering to Excel.

Which type of data region should you use?

 

A. List

B. Textbox

C. Rectangle

D. Matrix

 

Correct Answer: D

Explanation

Explanation/Reference:

 

 

QUESTION 44

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 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. Deploy the report to the report server with a shared dataset.

D. Deploy the report to the report server after adding an assembly creating a connection to the Windows form application.

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 45

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 requires users to enter parameter values before it will run.

The users wish to simplify the process so that the report will run without input.

You need to enable this functionality.

What should you do?

 

A. Add a default value to all parameters

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

C. Remove the filters from the dataset queries and use the parameters to filter the data source.

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

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 46

You develop reports by using SQL Server 2008 Reporting Services (SSRS) Enterprise Edition. You need to use data-driven subscription to distribute reports based on dynamic subscription data. Which role should you use?

 

A. Content Manager

B. Publisher

C. System User

D. Browser

 

Correct Answer: A

Explanation

Explanation/Reference:

 

 

QUESTION 47

You manage the security in SQL Server 2008 R2 Reporting Services (SSRS).

You create a new role.

You need to grant the following permissions to the role:

View and modify security settings for reports, folders, resources, and shared data sources.

Create and delete reports.

Modify report properties.

View content, definition, and property for reports.

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

 

A. Assign the Manage Resources task to the role.

B. Assign the Manage Reports task to the role.

C. Assign the Consume Reports task to the role.

D. Assign Set Security Policies for Items task to the role.

E. Assign the Manage All Subscriptions task to the role.

 

Correct Answer: BCD

Explanation

Explanation/Reference:

 

 

QUESTION 48

You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a folder named Human Resources Report.

All groups can view and modify reports in any folder.

You need to ensure that only the Human Resources group can view and modify reports in the Human Resources Reports folder.

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

 

A. Remove all groups from the Human Resources Reports folder.

B. Create a Human Resources role.

C. Add the Human Resources group to the Human Resources Reports folder and assign the Content Manager role.

D. Assign the Human Resources role to the Human Resources Reports folder.

E. Assign the Human Resources group to the root folder.

 

Correct Answer: AC

Explanation

Explanation/Reference:

 

 

QUESTION 49

You are implementing a disaster recovery strategy for SQL Server 2008 Reporting Services (SSRS).

You want to be able to restore the report catalog database in the event of a failure.

You need to back up the encryption key.

Which command line utility should you use?

 

A. Rsconfig.exe

B. Rs.exe

C. rskeymgmt.exe

D. dtsutil.exe

 

Correct Answer: AC

Explanation/Reference:

 

 

QUESTION 50

You develop a SQL Server 2008 Integration Services (SSIS) project. You receive information on sales leads from the sales department. These leads are contained in Microsoft Excel files. You have to load these leads on a daily basis by designing, configuring, deploying, and scheduling steps.

Because this is a daily task, loading Excel files with the Import and Export Data (32-bit or 64-bit) wizard is NOT an option.

When designing the SSIS package, you receive the error shown below and in the Exhibit. (Click the Exhibit button.)

Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE

DB provider is available.

You need to resolve the error.

Which change should you make to the debug options?

 

A. Set Run64BitRuntime to True.

B. Set Run64BitRuntime to False.

C. Set RunInOptimizedmode to True.

D. Set RunInOptimizedmode to False.

 

Correct Answer: B

Explanation

Explanation/Reference:

 

 

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