[Free] Get all latest Microsoft 70-467 Actual Tests 171-176

Ensurepass

QUESTION 171

DRAG DROP

Several reports are based on the same SQL Server Analysis Services (SSAS) cube. Each report has several datasets defined with complex Multidimensional Expressions (MDX) queries. The company maintains separate development, test and production environments.

 

The reports are running slowly. You plan to analyze report performance. You have the following requirements:

 

clip_image002Monitor query statistics on the production server with as little server overhead as possible.

clip_image002[1]Gather, replay, and analyze statistics on the test server with as little administrative effort as possible.

clip_image002[2]Identify the longest-running queries on both servers.

clip_image002[3]Document statistics on disk reads on both servers.

 

You need to gather statistics and meet the requirements.

 

Which features should you use?

 

To answer, drag the appropriate feature or features to the correct location or locations in the answer area. (Use only features that apply.)

 

clip_image004

 

Correct Answer:

clip_image006

 

 

 

 

 

 

 

 

QUESTION 172

DRAG DROP

You have a business intelligence (BI) solution that uses SQL Server Integration Services (SSIS). The BI solution includes an extract transformation, and load (ETL) system.

 

You are designing a logging and auditing strategy for the ETL system.

 

You need to ensure that an ETL administrator can view the row counts of any data flow path for each package execution.

 

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_image008

 

Correct Answer:

clip_image010

 

 

QUESTION 173

DRAG DROP

You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have access to the original password that was used to create the SSIS catalog.

 

A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.

 

The production server that hosts the SSISDB database fails.

 

Sensitive data that is encrypted in the SSISDB database must not be lost.

 

You need to restore the production SSIS catalog to the disaster recovery server.

 

Which three steps 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_image012

 

Correct Answer:

clip_image014

 

 

QUESTION 174

HOTSPOT

You are developing a SQL Server Reporting Services (SSRS) solution.

 

You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular database configured in DirectQuery mode.

 

You need to configure a shared data source.

 

Which data source type should you use?

 

To answer, select the appropriate type from the drop-down list in the answer area.

 

clip_image015

 

Correct Answer:

clip_image016

 

 

QUESTION 175

You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a Microsoft SharePoint 2010 farm. You need to upgrade to SSRS 2014 with the minimum downtime and hardware requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Install SSRS 2014 on a new SharePoint farm and migrate content to the new farm.

B.

Migrate SSRS content to new servers that run SSRS 2014.

C.

Migrate SSRS content to a separate instance of SSRS 2014 on the same server.

D.

Perform an in-place upgrade of the SSRS environment.

 

Correct Answer: D

Explanation:

We cannot do a side-by-side installation (answer C) because that’s not supported in SharePoint mode so an in-place upgrade is the only option that doesn’t require additional servers.

SQL Server 2014 Reporting Services (SSRS) Native mode can be installed side-by-side with a SQL Server 2012 Native mode deployment.

There is no support for side-by-side deployments of SQL Server 2014 Reporting Services (SSRS) SharePoint mode and any previous versions of SharePoint mode components.

 

 

QUESTION 176

You are designing a partitioning strategy for a SQL Server Analysis Services (SSAS) cube.

 

New data is loaded in real-time into the data warehouse that feeds the cube. Between 10 million and 15 million rows of data are loaded into the main fact table each day from a Microsoft Azure SQL Database.

 

You have the following requirements:

 

clip_image002[4]Maximize cube query performance during business hours.

clip_image002[5]Ensure that data is available in the cube as soon as possible after it is loaded into the data warehouse.

 

You need to design a partitioning strategy that meets the requirements.

 

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

 

A.

Partition the cube by day for history, using hybrid OLAP (HOLAP) storage mode.

Create a daily partition that uses multidimensional OLAP (MOLAP) storage mode during the day.

Reprocess the partition incrementally during the day.

B.

Partition the cube by week for history.

Create a daily partition that uses multidimensional OLAP (MOLAP) storage mode.

Process the partition periodically to add new data.

C.

Partition the cube by day for history, using multidimensional OLAP (MOLAP) storage mode.

Create a daily partition that uses proactive caching during the day.

Reprocess the partition in full MOLAP storage mode at night

D.

Partition the cube by day for history, using multidimensional OLAP (MOLAP) storage mode.

Create a daily partition that uses relational OLAP (ROLAP) storage mode during the day.

Reprocess the partition in full MOLAP storage mode at night.

 

Correct Answer: A

 

Instant Access to Download Testing Software & PDF File for Microsoft 70-467 Real Exam

Instant Access to Try Microsoft 70-467 Free Demo

This entry was posted in 70-467 Actual Tests and tagged , , , , , . Bookmark the permalink.