New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 101-110

Ensurepass

 

QUESTION 101

A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.

 

You are developing a daily report that summarizes information on manufacturing activity.

 

The report has the following requirements:

 

clip_image002It must have a stale name as one of the report parameters.

clip_image002[1]It must provide a daily summary of manufacturing activity of a selected state.

clip_image002[2]It must require minimal development and maintenance effort.

 

You need to develop the report to meet the requirements.

 

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Build one report for each state and instruct users to execute reports as needed.

B.

Use a report-specific data source that defines an expression-based connection string based on the state parameter.

C.

Build a centralized data repository, schedule a regular Extract Transform, and Load (ETL) process on all manufacturing data, and then use the repository to generate the report.

D.

Use a shared data source that defines an expression-based connection string based on the state parameter.

 

Correct Answer: B

 

 

QUESTION 102

You are creating a new report in SQL Server Report Builder. You add a Microsoft Azure SQL Database data source. Then you add a dataset that has four fields named Year.

Country, Category, and Sales.

 

You must design a matrix as shown in the following table.

 

clip_image003

 

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows {the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.

 

You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.

 

You need to add the countries on the rows of the matrix.

 

Which Row Group option should you select when you add the group?

 

A.

Adjacent Below

B.

Child Group

C.

Parent Group

D.

Adjacent Above

 

Correct Answer: A

 

 

QUESTION 103

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server. Members of the Developer Support role cannot modify the report execution timeout period. You need to enable members of the Developer Support role to modify the report execution timeout period. Which task should you add to the Developer Support role?

 

A.

Manage report server properties

B.

Manage shared schedules

C.

Execute report definitions

D.

Manage jobs

 

Correct Answer: A

 

 

QUESTION 104

DRAG DROP

You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report parameters named StartDate and FinishDate as shown in the following diagram.

clip_image004

 

The Data Type property of the parameters is set to Date/Time.

 

You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.

 

Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

 

clip_image006

 

Correct Answer:

clip_image008

 

 

QUESTION 105

You are managing a SQL Server Reporting Services (SSRS) instance. A website must pass credentials to the local security authority for Reporting Services. You need to configure Reporting Services to issue a challenge/response when a connection is made without credentials. Which authentication type should you configure in the RSReportServer.config file?

 

A.

RSWindowsKerberos only

B.

RSWindowsKerberos and RSWindowsNTLM

C.

RSWindowsBasic

D.

RSWindowsKerberos and RSWindowsNegotiate

 

Correct Answer: D

 

 

QUESTION 106

You are creating a SQL Server Analysis Services (SSAS) multidimensional database.

 

Users need a time dimension for:

 

clip_image002[3]Dates

clip_image002[4]Delivery dates

clip_image002[5]Ship dates

 

You need to implement the minimum number of required SSAS objects.

 

What should you do?

 

A.

Use role playing dimensions.

B.

Use the Business Intelligence Wizard to define dimension intelligence.

C.

Add a measure that uses the Count aggregate function to an existing measure group.

D.

Add a measure that uses the DistinctCount aggregate function to an existing measure group.

E.

Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

F.

Add a measure group that has one measure that uses the DistinctCount aggregate function.

G.

Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

H.

Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

I.

Create several dimensions. Add each dimension to the cube.

J.

Create a dimension. Then add a cube dimension and link it several times to the measure group.

K.

Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relat
ionships to use different dimension attributes.

L.

Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.

M.

Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.

N.

Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.

O.

Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.

 

Correct Answer: A

 

 

QUESTION 107

You are developing a Microsoft SQL Analysis Services (SSAS) multidimensional project. A fact table named FactHouseSales has a measure column named Area. All values in the column are stored in square feet. Users must be able to analyze the area in different units. You create a table named AreaUnit. Each row in the table consists of the unit name and a square feet conversion factor value. You need to implement the area conversion in the project. What should you do?

 

A.

Use role playing dimensions.

B.

Use the Business Intelligence Wizard to define dimension intelligence.

C.

Add a measure that uses the Count aggregate function to an existing measure group.

D.

Add a measure that uses the DistinctCount aggregate function to an existing measure group.

E.

Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.

F.

Add a measure group that has one measure that uses the DistinctCount aggregate function.

G.

Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.

H.

Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.

I.

Create several dimensions. Add each dimension to the cube.

J.

Create a dimension. Then add a cube dimension and link it several times to the measure group.

K.

Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.

L.

Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.

M.

Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.

N.

Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.

O.

Create a new named calculation in the data source view to calculate a rolling sum. Add

a measure that uses the Max aggregate function based on the named calculation.

 

Correct Answer: N

 

 

QUESTION 108

HOTSPOT

You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team.

 

The data warehouse used by the cube contains the time durations of taps run by each runner on the team. The time durations are stored in seconds as an integer.

 

You need to build the following two measures in the cube:

 

clip_image002[6]A measure named Measure1 that must contain the average time duration of the laps run by each runner.

clip_image002[7]A measure named Measure2 that must contain the lap-time duration and the name of the runner who ran the fastest lap.

 

What should you do? To answer, select the appropriate Aggregation Function property for each measure in the answer area.

 

clip_image009

clip_image010

 

Correct Answer:

clip_image011

 

 

QUESTION 109

DRAG DROP

You are developing a SQL Server Analysis Services (S5AS) cube. The cube consists of a single measure group.

 

The measure group consists of one partition that uses MOLAP.

 

The proactive caching policy has the following requirements:

 

clip_image002[8]The cache must be updated when data is changed in the table named tbIOrders.

clip_image002[9]Changes must be notified through the use of the XML for Analysis (XMLA) NotifyTableChange command.

 

You need to configure the proactive caching policy to meet the requirements.

 

Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

 

clip_image013

 

Correct Answer:

clip_image015

 

 

QUESTION 110

DRAG DROP

You are developing a SQL Server Analysis Services (SSAS) cube. You
need to reuse a Revenue measure group from a different database. In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

 

clip_image017

 

Correct Answer:

clip_image019

 

Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-466 Real Exam

Try Microsoft MCSE 70-466 Free Demo