Online Access Free 70-768 Exam Questions

What property do you set for each measure to improve the legibility of values in a client application?

• A.MeasureExpression
• B.AggregateFunction
• C.FormatString
• D.DataType

Drag and Drop Question
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.

Correct Answer:

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.

What type of partitioning strategy should you implement to support the analysis of hourly Internet sales transactions?

• A.Create one partition per day dynamically by running an SSIS package daily to build the new partition. Load the data for the current day by performing a Process Full operation on the partition.
• B.Convert the model to DirectQuery. Add columnstore indexes to the source tables. In the model, define a sample partition for all tables to view data during development.
• C.Create one partition per hour per day dynamically by running an SSIS package each hour to build the new partition. Load the data for the current hour by performing a Process Add, and then execute a Process Recalc on the partition
• D.Set the model to DirectQuery With In-Memory Mode. Define a sample partition for the Internet Sales table to view data during development.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a travel agency that specializes in vacation packages. Vacation bookings and packages are stored in a SQL Server database. You use the model as the basis for customer emails that highlight vacation packages that are currently underbooked, or projected to be underbooked.
The company plans to incorporate cruise ship vacation packages. Cruise ship vacation packages include new features such as region availability and cruise line specialties that require changes to the tabular model.
You must ensure that the tabular model reflects the new vacation packages.
You need to configure the tabular data model.
What should you do?

• A.Process the model in Process Data mode.
• B.Ensure that the Transactional Deployment property is set to False.
• C.Ensure that DirectQuery is disabled for the model.
• D.Ensure that DirectQuery is enabled for the model.
• E.Ensure that the Transactional Deployment property is set to True.
• F.Process the model in Process Defrag mode.
• G.Process the model in Process Full mode.

You use Microsoft SQL Server Profile to evaluate a query named Query.
The Profiler report indicates the following issues:
- At each level of the query plan, a low total number of rows are
processed.
- The query uses many operations.
This results in a high overall cost for the query.
You need to identify the information that will be useful for the optimizer.
What should you do?

• A.Start a SQL Server Profiler trace for the event class Soft Warnings in the Errors and Warnings event category.
• B.Create one Extended Events session with the sqlserver.missing_join_predicate event added.
• C.Start a SQL Server Profiler trace for the event class Auto Stats in the Performance event category.
• D.Create one Extended Events session with the sqlserver.missing_column_statistics eventadded.