Free Microsoft 70-768 Exam Dumps Questions & Answers

You are administrating a SQL Server Analysis Services (SSAS) tabular database.
You need to create a new role that allows its members to query data and to refresh data in the model.
Which permission should you use? (More than one answer choice may achieve the goal.
Select the BEST answer.)

• A.  Administrator
• B.  Read and Process
• C.  Browse and Manage
• D.  Explore and Manage

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

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.  Yes
• B.  No

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

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

You manage an instance of SQL Server Analysis Services (SSAS). Over the last several months, the usage on the server increased by 50% as users begin to create and run more analyses.
Queries are taking longer to run, and processor usage is consistently above 80%.
You predict that query usage will continue to increase at 5% per month. You need to scale SSAS to accommodate the present and future processing load.
Which three actions could you take?
Each correct answer presents a complete solution.

• A.  Create a new remote SSAS partition.
• B.  Create a new Network Load Balanced (NLB) cluster.
• C.  Create a second instance of SSAS on the same server and dedicate this instance to processing queries.
• D.  Create a second instance of SSAS on a different server and dedicate this instance to processing queries.
• E.  Create a new local SSAS partition.