Microsoft 70-466 Exam Questions Instant Access

Question 1

You have an application that uses a view to access data from multiple tables.

You need to ensure that you can insert rows into the underlying tables by using the view.

What should you do?

ADefine the view by using the SCHEMABINDING option.

BDefine the view by using the CHECK option.

CCreate an INSTEAD OF trigger on the view.

DMaterialize the view.

Answer : C

Using INSTEAD OF triggers you can override an INSERT, UPDATE, or DELETE operation on a view. For

example, you might define an INSTEAD OF INSERT trigger on a view to replace the standard INSERT statement.

References: https://msdn.microsoft.com/en-us/library/def01zh2.aspx

Question 2

You manage a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode.

You identify a problem with the operations performed by the Report Server Web service.

You need to view the Report Server trace logs. In which directory should you view the files?

A%ProgramFiles%\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

B%ProgramFiles%\Common Files\Microsoft Shared\Web Server Extensions\14\Web Services\ReportServer\LogFiles

C%ProgramFiles%\Common Files\ReportServer\LogFiles

D%ProgramFiles%\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles

Answer : D

Question 3

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.

The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.

You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.

What should you do?

ACreate a separate partition for each team.

BCreate a separate data source for each team.

CCreate a perspective for the sales team.

DEnable client side security to filter non-sales data.

Answer : C

Question 4

You need to configure the partition storage settings to support the reporting requirements.

Which partition storage setting should you use?

AHigh-latency MOLAP

BIn-Memory

CLow-latency MOLAP

DDirectQuery

ELazyAggregations

FRegular

Answer : C

Question 5

You are developing a SQL Server Analysis Services (SSAS) tabular project.

In the data warehouse, a table named Sales Persons and Territories defines a relationship between a salesperson's name, logon ID, and assigned sales territory.

You need to ensure that each salesperson has access to data from only the sales territory assigned to that salesperson. You need to use the least amount of development effort to achieve this goal.

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

ACreate a new role named Sales Persons with Read permission. Add each salesperson's logon as a member to the role.

BAdd the Sales Persons and Territories table to the model, define the relationships, and then implement dynamic security by using row filters. Grant each salesperson access to the model.

CCreate a new Active Directory Domain Services (AD DS) security group and add each salesperson as a member. Then create a new role named Sales Persons with Read permission. Add the group as a member to the new role.

DCreate a separate tabular model for each sales territory and assign each tabular model a corresponding sales territory name. Grant each salesperson access to the corresponding tabular model of the assigned sales territory.

Answer : B

Question 6

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Revenue and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates.

You need to create a measure to report on year-over-year growth of revenue.

What should you do? (Each answer presents a complete solution. Choose all that apply.)

AOption A

BOption B

COption C

DOption D

Answer : A, C, D

Question 7

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.

You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.

What should you do before the partition can be write-enabled?

AImplement the cube as a local cube.

BEnsure that the measure group measures only use semiadditive aggregation functions.

CImplement the linked measure group as a local measure group.

DEnsure that the measure group measures only use nonadditive aggregation functions

Answer : C

Microsoft Implementing Data Models and Reports with Microsoft SQL Server 2012 70-466 Exam Questions