Microsoft 70-466 Exam Questions Instant Access

Question 1

You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment.

The production database has been configured with security roles.

You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server.

Which deployment method should you use?

AUse the SQL Server Analysis Services Deployment Wizard.

BBackup and restore the database.

CUse the SQL Server Analysis Services Migration Wizard.

DDeploy the project from SQL Server Data Tools to the production server.

Answer : A

Question 2

You are designing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.

The sales department has the following requirements for the cube:

Include a year-over-year (YOY) calculation

Include a month-over-month (MOM) calculation

You need to ensure that the calculations are implemented in the cube.

Which Multidimensional Expressions (MDX) function should you use?

AUNREGINTERCEPT()

BLASTPERIODS()

CTIMEINTELLIGENCE()

DPARALLELPERIOD()

Answer : D

Question 3

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

You have identified a dimension that is no longer used by any cubes.

You need to delete the dimension.

What should you do?

AWrite a Multidimensional Expressions (MDX) command to drop the dimension from the database.

BWrite a Data Mining Extensions (DMX) command to drop the dimension from the database.

CWrite a T-SQL command to drop the dimension from the database.

DDelete the dimension by using SQL Server Management Studio Object Explorer.

Answer : D

To delete a dimension in SQL Server Data Tools.

In Solution Explorer, right-click the dimension that you want to delete, and then click Delete.

References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/databasedimensions-modify-or-delete-a-database-dimension-in-solution-explorer

Question 4

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance.

You need to ascertain the memory consumed by each object in the SSAS instance.

What should you do?

AUse the $System.discover_object_memory_usage dynamic management view.

BUse SQL Server Profiler to review session events for active sessions.

CUse the Usage Based Optimization wizard to design appropriate aggregations.

DUse the Performance Counter group named Processing.

Answer : A

Question 5

You manage a SQL Server Reporting Services (SSRS) instance.

An application 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?

ARSWindowsKerberos

BRSWindowsNegotiate

CRSWindowsNTLM

DRSWindowsBasic

Answer : D

Ref: http://msdn.microsoft.com/en-us/library/ms157273.aspx

Question 6

You need to develop the multidimensional project to meet the requirements of the Excel users.

What should you do?

ACreate a separate cube for the executive team so that it contains only the data they want to see.

BCreate a perspective for the executive team.

CCreate security roles to restrict access to the executive team.

DCreate a view for the executive team.

Answer : B

Question 7

You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table.

You need to implement a time dimension.

What should you do?

AUse the SQL Server Data Tools Dimension Wizard and generate a time table on the server.

BCreate a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.

CCreate a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.

DCreate a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.

Answer : A

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