Von der kostenlosen Demo über die 70 Übungsfragen bis hin zum Kundenservice: Fast2test begleitet Sie im Jahr 2026 durch die gesamte Vorbereitung auf die 070-768 Prüfung. Alles, was Sie für Ihre Microsoft Developing SQL Data Models brauchen, finden Sie an einem Ort.

Microsoft 070-768 Prüfungsübersicht:

Microsoft 070-768 Prüfungsthemen:

Ihre Fragen zur 070-768 Prüfung – kompakt beantwortet

Microsoft Developing SQL Data Models 070-768 Prüfungsfragen mit Lösungen

Frage #1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You deploy a tabular data model to an instance of Microsoft SQL Server Analysis Services (SSAS). The model uses an in-memory cache to store and query data. The data set is already the same size as the available RAM on the server. Data volumes are likely to continue to increase rapidly.
Your data model contains multiple calculated tables.
The data model must begin processing each day at 2:00 and processing should be complete by
4:00 the same day. You observe that the data processing operation often does not complete before 7:00. This is adversely affecting team members.
You need to improve the performance.
Solution: Change the storage mode for the data model to DirectQuery.
Does the solution meet the goal?

A. No
B. Yes

Frage #2

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

A. 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.
B. 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.
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.

Frage #3

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

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

Frage #4

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model defines a measure named Profit 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 profit.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

A. Define the following calculation. Year Over Year Profit Growth:=CALCULATE([Profit], DATEADD('Date'[Date], 1, YEAR))
B. Define the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit], PARALLELPERIOD('Date'[Date], -12, MONTH))
C. Use the Business Intelligence Wizard and then use the Define time intelligence enhancement.
D. Define the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit], SAMEPERIODLASTYEAR('Date'[Date]))

Frage #5

You are building a Microsoft SQL Server Analysis Services multidimensional model over a SQL Server database.
In a cube named OrderAnalysis, there is a standard cube dimension named Stock Item.
This dimension has the following attributes:
Users report that the attributes Stock Item Key and Photo are distracting and are not providing any value.
They have asked for the attributes to be removed. However, these attributes are needed by other cubes.
You need to hide the specified attributes from the end users of the OrderAnalysis cube. You do not want to change the structure of the dimension.
Which change should you make to the properties for the Stock Item Key and Photo attributes?

A. Set the AttributeHierarchyEnabledproperty to False.
B. Set the AttributeHierarchyVisible property to False.
C. Set the AttributeVisibility property to Hidden.
D. Set the AttributeHierarchyDisplayFolder property to Hidden.
E. Set the Usage property to Regular.

Fragen und Antworten: