Free Microsoft 70-768 Exam Dumps Questions & Answers

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Sales.
The Sales table includes a single date column.
The Sales table must meet the following requirements:
- Queries must be able to return all rows.
- Must be able to support four different processing schedules for
different date ranges.
- Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.What should you do?

• A.  Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.
• B.  Create four partitions for the Sales table. Use row filter queries for each partition.
• C.  Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
• D.  Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?

• A.  Select
• B.  Browser
• C.  Read
• D.  Administrator
• E.  Process
• F.  Explorer

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server.
The data size and complexity of the data relationships will not change.
The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

• A.  a tabular project that uses the DirectQuery query mode
• B.  a multidimensional project that uses the MOLAP storage mode
• C.  a multidimensional project that uses the ROLAP storage mode
• D.  a tabular project that uses the In-Memory query mode
• E.  a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010

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 one tabular instance of SSAS and enable the Data Mining Extensions.
• B.  Install two separate tabular instances of SSAS.
• C.  Install one multidimensional instance of SSAS.
• D.  Install a multidimensional instance and a Power Pivot instance of SSAS on the same server.
• E.  Install one tabular instance of SSAS.

Hotspot Question
You need to configure the project option settings to minimize deployment time for the CustomerAnalysis data model.
What should you do? To answer, select the appropriate setting from each list in the answer area.

Correct Answer:

Explanation:
Scenario:
Box 1, Processing option:Default
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.
Note: Processing Method This setting controls whether the deployed objects are processed after deployment and the type of processing that will be performed. There are three processing options:
Default processing (default)
Full processing
None
Box 2, Transactional deployment: False
If this option is False, Analysis Services deploys the metadata changes in a single transaction, and deploys each processing command in its own transaction.
Scenario: The CustomerAnalysis data model will contain a large amount of data and needs to be shared with other developers even if a deployment fails. Each time you deploy a change during development, processing takes a long time.
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/deployment- script-files-specifying-processing-options
Topic 2, Background
Wide World Importers imports and sells clothing. The company has a multidimensional Microsoft SQL Server Analysis Services instance. The server has 80 gigabytes (GB) of available physical memory. The following installed services are running on the server:
* SQL Server Database Engine
* SQL Server Analysis Services (multidimensional)
The database engine instance has been configured for a hard cap of 50 GB, and it cannot be lowered. The instance contains the following cubes: SalesAnalysis, OrderAnalysis.
Reports that are generated based on data from the OrderAnalysis cube take more time to complete when they are generated in the afternoon each day. You examine the server and observe that it is under significant memory pressure.
Processing for all cubes must occur automatically in increments. You create one job to process the cubes and another job to process the dimensions. You must configure a processing task for each job that optimizes performance. As the cubes grown in size, the overnight processing of the cubes often do not complete during the allowed maintenance time window.
Sales Analysis
The SalesAnalysis cube is currently being tested before being used in production. Users report that day name attribute values are sorted alphabetically. Day name attribute values must be sorted chronologically. Users report that they are unable to query the cube while any cube processing operations are in progress. You need to maximize data availability during cube processing and ensure that you process both dimensions and measures.
Order Analysis
The OrderAnalysis cube is used for reporting and ad-hoc queries from Microsoft Excel. The data warehouse team adds a new table named Fact.Transaction to the cube. The Fact.Transaction table includes a column named Total Including Tax. You must add a new measure named Transactions ?Total Including Tax to the cube. The measure must be calculated as the sum of the Total Including Tax column across any selected relevant dimensions.
Finance
The Finance cube is used to analyze General Ledger entries for the company.
Requirements
- You must minimize the time that it takes to process cubes while
meeting the following requirements:
- The Sales cube requires overnight processing of dimensions, cubes,
measure groups, and partitions.
- The OrderAnalysis cube requires overnight processing of dimensions
only.
- The Finance cube requires overnight processing of dimensions only.