Free Microsoft 70-768 Exam Dumps Questions & Answers

You are responsible for installing new database server instances.
You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects.
You develop both projects by using SQL Server Data Tools.
You need to install the appropriate services to support both projects.
Which two actions should you perform? Each correct answer presents part of the solution.

• A.  Install a multidimensional instance and a Power Pivot instance of SSAS on the same server.
• B.  Install one multidimensional instance of SSAS.
• C.  Install one tabular instance of SSAS.
• D.  Install one tabular instance of SSAS and enable the Data Mining Extensions.
• E.  Install two separate tabular instances of SSAS.

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

You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode.
Which query mode should you select?

• A.  DirectQuery
• B.  In-Memory
• C.  In-Memory with DirectQuery
• D.  DirectQuery with In-Memory

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: Enable Buffer Cache Extensions.
Does the solution meet the goal?

• A.  No
• B.  Yes

Drag and Drop Question
You are a business analyst for a retail company that uses a Microsoft SQL Server Analysis Services (SSAS) multidimensional database to track sales.
The database contains the following objects:

Your company is developing a promotional plaque to recognize the top resellers in the top 10 cities where the company does business. Each plaque must display the sales total for all resellers in the city. In addition, the plaque must display a total for all cities not in the top 10.
You have the following requirements:
You need to provide the information needed for the promotional plaques.
How should you complete the MDX statement? To answer, drag the appropriate MDX segments to the correct locations. Each MDX segment 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. NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1:DYNAMIC SET
Box 2:MEMBER
Box 3:DYNAMIC SET
Box 4:[Geography].[City].[City].members
Box 5:[Measures].[Reseller Sales Amount]
https://docs.microsoft.com/en-us/sql/mdx/aggregate-mdx