Latest MCTS 70-448 Dumps Real Exam Download 21-30

Ensurepass

QUESTION 21

You maintain a SQL server 2008 Analysis Services (SSAS) data warehouse for a school district. All tests are administered via a third-party application. Results are collected in your SSAS data warehouse and moved to a Scores fact table for analysis. This warehouse also includes a Student Dimension which contains attributes related to each student.

The school year is starting, and the district administration wants the Student Dimension updated hourly so that new students can be identified and tracked. However, test scores located in the Scores fact table should not be updated as part of this incremental processing strategy.

You need to implement this functionality. Which option should you use?

 

A. Process Add

B. Process Update

C. Process Index

D. Process Full

 

Correct Answer: B

Explanation/Reference:

 

 

QUESTION 22

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

 

You develop a SQL Server 2008 Reporting services (SSRS) instance of a report model.

 

The organization requires that users of a report be able to dynamically change the server environment.

 

You need to create a parameter that gives the user the option to choose the server before report execution.

 

What should you do?

 

A. Create a distinct dataset that includes all possible values and attach it to the parameter.

B. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.

C. Create a dynamic data source from a dataset by using the IN operator.

D. Configure the Internal Visibility option for the parameter.

E. Develop a report for each environment.

F. Create a dynamic data source from a dataset that includes a list of distinct servers.

G. Create a dynamic dataset that includes a list of the different users.

H. Configure the Hidden Visibility property.

 

Correct Answer: F

Explanation/Reference:

 

 

QUESTION 23

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

 

You create a SQL Server 2008 Reporting Services (SSRS) report. The report is hosted in a SharePoint environment. The UserID is passed into the report automatically when the user views the report. The UserID will be used to link to other pages on the SharePoint site via url.

 

You need to prevent the user from seeing their UserID.

 

What should you do?

 

A. Create a distinct dataset that includes all possible values and attach it to the parameter.

B. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.

C. Create a dynamic data source from a dataset by using the IN operator.

D. Configure the Internal Visibility option for the parameter.

E. Develop a report for each environment.

F. Create a dynamic data source from a dataset that includes a list of distinct servers.

G. Create a dynamic dataset that includes a list of the different users.

H. Configure the Hidden Visibility property.

 

Correct Answer: H

Explanation/Reference:

 

 

QUESTION 24

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question inthe series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

 

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

An existing report on shoe sales allows the user to see the company’s revenue across many different attributes.

 

You need to create a drop down list that filters the report by one or more shoe colors.

You alter the main dataset and configure the report parameter to accept multiple values.

 

What should you do next?

 

A. Create a distinct dataset that includes all possible values and attach it to the parameter.

B. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.

C. Create a dynamic data source from a dataset by using the IN operator.

D. Configure the Internal Visibility option for the parameter.

E. Develop a report for each environment.

F. Create a dynamic data source from a dataset that includes a list of distinct servers.

G. Create a dynamic dataset that includes a list of the different users.

H. Configure the Hidden Visibility property.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 25

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

 

You are SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters names State and City in that order.

 

When the State parameter is selected, the City parameter should be filtered by the State selected.

 

You need to enable this functionality.

 

What should you do?

 

A. Create a distinct dataset that includes all possible values and attach it to the parameter.

B. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.

C. Create a dynamic data source from a dataset by using the IN operator.

D. Configure the Internal Visibility option for the parameter.

E. Develop a report for each environment.

F. Create a dynamic data source from a dataset that includes a list of distinct servers.

G. Create a dynamic dataset that includes a list of the different users.

H. Configure the Hidden Visibility property.

 

Correct Answer: B

Explanation

Explanation/Reference:

 

 

QUESTION 26

You maintain a SQL Server 2008 Reporting Services Instance.

Some users need to view and run reports in the USA Region folder on the Report Server.

You need to assign these users the minimum permissions required.

Which role should you use?

 

A. Publisher

B. Content Manager

C. Report Builder

D. Brower

 

Correct Answer: D

Explanation

Explanation/Reference:

 

 

QUESTION 27

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL Server 2008 database.

You need to ensure that the data flow updates the existing records and inserts the updated records into the SQL Server database by using data from the rows in your data flow.

Which three data flow components should you use? (Each correct answer presents part of the solution. Choose three.)

 

A. Conditional Split Transformation

B. OLE DB Destination

C. OLE DB Command Transformation

D. Data Conversion Transformation

E. Lookup Transformation

 

Correct Answer: BCE

Explanation/Reference:

 

 

QUESTION 28

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two sources: a Mircosoft Excel sources and ADO.net. The

ADO.net source is based on a SELECT statement that uses an ORDER BY clause.

The data flow is as shown in the following exhibit. (Click the Exhibit button.)

When the paths from the two sources are connected to the Merge Join component, the following error message is displayed:

Data Flow Task: the input is not sorted. The `input “Merge Join Left Input”(48)’ must be sorted.

You need to ensure that data from each query is included in each row in the data flow.

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

 

A. Add a Sort transformation for the Excel source.

B. Add an OLE DB Command transformation for each data flow.

C. Update the sorting properties in the ADO.net source component.

D. Replace the Merge Join transformation with a Union All transformation.

 

Correct Answer: AB

Explanation/Reference:

 

 

QUESTION 29

You design a SQL Server 2008 Integration Service (SSIS) data flow that inserts data from a source query to a destination table.

You need to insert only those rows that do not already exist in the destination table. You also need to avoid the records in a status column with “Inactive” status.

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

 

A. Use the Merge transformation.

B. Use the Lookup transformation.

C. Use the Union All transformation.

D. Use the Fuzzy Lookup transformation.

E. Use the Conditional Split Transformation.

 

Correct Answer: BE

Explanation

Explanation/Reference:

 

 

QUESTION 30

You develop a series of SQL Server 2008 Integration Services (SSIS) packages.

You need to ensure that the following requirements are met:

The package contains configurations.

The configuration information is centrally stored for all packages.

There are dependencies among the packages.

Which three components should you use to configure the package? (Each correct answer presents part of the solution. Choose three.)

 

A. XML configuration file.

B. Environment variable.

C. Registry entry

D. Parent package variable.

E. SQL Server 2008 table.

 

Correct Answer: ADE

Explanation

Explanation/Reference:

 

 

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