Microsoft 70-768 MCSA: SQL 2016 BI Development Exam Questions

Microsoft 70-768 exam is a required test for Microsoft Certified Professional certification. Microsoft Certified Professional is a technical professional who SQL Server . To help you pass Microsoft 70-768 exam, latest Microsoft 70-768 exam questions are available for you.

Microsoft Exam Questions

Question: 1
You need to configure the server to optimize the afternoon report generation based on the
OrderAnalysis cube.
Which property should you configure?
A. LowMemoryLimit
B. VertiPaqPagingPolicy
C. TotalMemoryLimit
D. VirtualMemoryLimit
Answer: A

Question: 2
DRAG DROP
You need to resolve the issues that the users report.
Which processing options should you use? To answer, drag the appropriate processing option
to the correct location or locations. Each processing option may be used once, more than
once, or not at all. You may need to drag the split bar between panes or scroll to view
content.

Explanation:

Box1: Process Full:

When Process Full is executed against an object that has already been processed, Analysis

Services drops all data in the object, and then processes the object. This kind of processing is

required when a structural change has been made to an object, for example, when an attribute

hierarchy is added, deleted, or renamed.

Box 2: Process Default

Detects the process state of database objects, and performs processing necessary to deliver

unprocessed or partially processed objects to a fully processed state. If you change a data

binding, Process Default will do a Process Full on the affected object.

Box 3:

Not Process Update: Forces a re-read of data and an update of dimension attributes. Flexible

aggregations and indexes on related partitions will be dropped.

Question: 3

DRAG DROP

You need to create the cube processing job and the dimension processing job.

Which processing task should you use for each job? To answer, drag the appropriate

processing tasks to the correct locations. Each processing task may be used once, more than

once, or not at all. You may need to drag the split bar between panes or scroll to view

content.

Explanation:

Box 1: ProcessData

Processes data only without building aggregations or indexes. If there is data is in the

partitions, it will be dropped before re-populating the partition with source data.

Box 2: Process Update

Forces a re-read of data and an update of dimension attributes. Flexible aggregations and

indexes on related partitions will be dropped.

References:https://docs.microsoft.com/en-us/sql/analysis-services/multidimensionalmodels/

processing-options-and-settings-analysis-services