Valid Microsoft 70-768 dumps questions shared by Pass4itsure for helping to pass the Microsoft 70-768 exam! Get the newest Pass4itsure 70-768 exam dumps with VCE and PDF here: https://www.pass4itsure.com/70-768.html (50 Q&As Dumps).
Suitable for 70-768 complete Microsoft learning pathway
The content is rich and diverse, and learning will not become boring. You can learn in multiple ways through the Microsoft 70-768 exam.
- Download
- Watch the video
- Answer practice questions, the actual test
Free Microsoft 70-768 dumps download
[PDF] Free Microsoft 70-768 dumps download https://drive.google.com/file/d/18PoNz37iM_-7kb_66iqDTbmI4LM54O92/view?usp=sharing
Pass4itsure offers the latest Microsoft 70-768 practice test free of charge 1-13
QUESTION 1
You need to configure the server to optimize the afternoon report generation based on the OrderAnalysis cube. Which
property should you configure?
A. LowMemoryLimit
B. VertiPaqPagingPolicy
C. TotalMemoryLimit
D. VirtualMemoryLimit
Correct Answer: A
LowMemoryLimit: For multidimensional instances, a lower threshold at which the server first begins releasing memory
allocated to infrequently used objects.
From scenario: 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.
QUESTION 2
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 have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location,
customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets. You identify the
following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: A
QUESTION 3
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 have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location,
customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets. You identify the
following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
QUESTION 4
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.
Select and Place:
Correct Answer:
Box 1:DYNAMIC SET Box 2:MEMBER Box 3:DYNAMIC SET Box 4:[Geography].[City].[City].members Box
5:[Measures].[Reseller Sales Amount] References: https://docs.microsoft.com/en-us/sql/mdx/aggregate-mdx
QUESTION 5
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.
Hot Area:
Correct Answer:
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.
References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensionalmodels/deployment-script-filesspecifying-processing-options
QUESTION 6
A database named DB2 uses the InMemory query mode. Users frequently run the following query:
You need to ensure no users see the PriorYearSales measure in the field list for the Sales table. What should you do?
A. Create a perspective, and ensure that the PriorYearSales measure is not added to the perspective. Ensure that users connect to the model by using the perspective.
B. Set the Display Folder property for PriorYearSales toHidden.
C. Remove the PriorYearSales measure from the default field set of the Sales table.
D. Create a role using Read permissions, and define a DAX expression to filter out the PriorYearSales measure. Add all
users to the role.
Correct Answer: A
Using perspectives in the data model might help you expose a subset of tables, columns, and measures that are useful
for a particular type of analysis. Usually, every user needs only a subset of data you create, and showing him or her the
model through perspectives can offer a better user experience.
From scenario; The PriorYearSales measure is referenced by other measures, and is not intended to be analyzed
directly by users.
References: Microsoft SQL Server 2012 Analysis Services, The BISM Tabular Model, Microsoft Press (July 2012), page 305
QUESTION 7
You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional project. You are developing a dimension
that uses data from the following table:
The ManagerKey column defines a foreign key constraint that references the EmployeeKey column. The table stores
employee history information by using slowly changing dimensions (SCD). Changes to EmployeeName, Phone, or
ManagerKey are managed as SCD Type 1 changes. Changes to SalesRegion are managed as SCD Type 2 changes.
You create the following attributes, and set the KeyColumns and NameColumn properties to the columns listed in the
table below:
You need to add a parent-child hierarchy to the dimension to enable navigating the organization hierarchy.
In the table below, identify the attribute that you must use for each attribute usage type.
NOTE: Make only one selection in each column.
Hot Area:
Correct Answer:
The ManagerKey column, the Manager attribute, defines a foreign key constraint that references the EmployeeKey
column, the Employee attribute.
QUESTION 8
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 have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order
data for customers in the United States only. The database contains the following objects:
You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status. The KPI must
contain:
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
QUESTION 9
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. Ensure that DirectQuery is enabled for the model.
B. Ensure that DirectQuery is disabled for the model.
C. Ensure that the Transactional Deployment property is set to True.
D. Ensure that the Transactional Deployment property is set to False.
E. Process the model in Process Full mode.
F. Process the model in Process Data mode.
G. Process the model in Process Defrag mode.
Correct Answer: E
Process Full processes an Analysis Services object and all the objects that it contains. 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.
QUESTION 10
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.
A company has an e-commerce website. When a customer places an order, information about the transaction is
inserted into tables in a Microsoft SQL Server relational database named OLTP1. The company has a SQL Server
Analysis
Services (SSAS) instance that is configured to use Tabular mode. SSAS uses data from OLTP1 to populate a data
model.
Sales analysts build reports based on the SSAS model. Reports must be able to access data as soon as it is available
in the relational database.
You need to configure and deploy an Analysis Services project to the Analysis Services instance that allows near realtime data source access.
Solution: In the Deployment Option property for the report, you set the Query Mode to InMemory.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
With InMemory the queries can use the cache only. References: https://msdn.microsoft.com/enus/library/hh230898(v=sql.120).aspx
QUESTION 11
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
Correct Answer: A
By default, tabular models use an in-memory cache to store and query data. When tabular models query data residing
in-memory, even complex queries can be incredibly fast. However, there are some limitations to using cached data.
Namely, large data sets can exceed available memory, and data freshness requirements can be difficult if not
impossible to achieve on a regular processing schedule.
DirectQuery overcomes these limitations while also leveraging RDBMS features making query execution more efficient.
With DirectQuery: +
Data is up-to-date, and there is no extra management overhead of having to maintain a separate copy of the data (in the
in-memory cache). Changes to the underlying source data can be immediately reflected in queries against the data
model. Datasets can be larger than the memory capacity of an Analysis Services server.
Etc.
References: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/directquery-mode-ssas-tabular
QUESTION 12
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 have a Microsoft SQL Server Analysis Services (SSAS) instance that is configured to use multidimensional mode.
You create the following cube:
Users need to be able to analyze sales by color.
You need to create a dimension that contains all of the colors for products sold by the company.
Which relationship type should you use between the InternetSales table and the new dimension?
A. no relationship
B. regular
C. fact
D. referenced
E. many-to-many
F. data mining
Correct Answer: B
A regular dimension relationship between a cube dimension and a measure group exists when the key column for the
dimension is joined directly to the fact table. References: https://docs.microsoft.com/en-us/sql/analysisservices/multidimensional-models-olap-logical-cube-objects/dimension-relationships
QUESTION 13
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 have a Microsoft SQL Server Analysis Services (SSAS) instance that is configured to use multidimensional mode.
You create the following cube:
Users need to be able to analyze sales by product and color.
You need to create the dimension.
Which relationship type should you use between the InternetSales table and the new dimension?
A. no relationship
B. regular
C. fact
D. referenced
E. many-to-many
F. data mining
Correct Answer: D
A reference dimension relationship between a cube dimension and a measure group exists when the key column for the
dimension is joined indirectly to the fact table through a key in another dimension table, as shown in the following
illustration.
A reference dimension relationship represents the relationship between dimension tables and a fact table in a snowflake
schema design. When dimension tables are connected in a snowflake schema, you can define a single dimension using
columns from multiple tables, or you can define separate dimensions based on the separate dimension tables and then
define a link between them using the reference dimension relationship setting. The following figure shows one fact table
named InternetSales, and two dimension tables called Customer and Geography, in a snowflake schema.
You can create two dimensions related to the InternetSales measure group: a dimension based on the Customer table,
and a dimension based on the Geography table. You can then relate the Geography dimension to the InternetSales
measure group using a reference dimension relationship using the Customer dimension.
What customers say about Pass4itsure
Latest discount code “2020PASS” – Pass4itsure
Summarize:
[Q1-Q13] Free Microsoft 70-768 dumps pdf download https://drive.google.com/file/d/18PoNz37iM_-7kb_66iqDTbmI4LM54O92/view?usp=sharing
Share all the resources: Latest Microsoft 70-768 practice questions, latest Microsoft 70-768 pdf dumps, Microsoft 70-768 exam video learning. Latest update Microsoft 70-768 dumps https://www.pass4itsure.com/70-768.html Study hard and practices a lot. This will help you prepare for the 70-768 exam. Good luck!
