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.
Browse and Manage
B.
Administrator
C.
Read and Process
D.
Explore and Manage
Can we refresh data with Read and Process? As per docs you need to have Administrator role
0
0
Read and Process enough to run process command
0
0
https://msdn.microsoft.com/en-us/library/hh213165.aspx
Process is synonim herę for refren. Administrator ca quady data model accord in to dość.
0
0
C is correct
0
0
Passed 70-466 Exam Yesterday and want to share some questions in my test:
QUESTION
A production SQL Server Analysis Services (SSAS) cube is processed daily.
The users query facts by using a hierarchy named Geography from a dimension named Geography. The DimGeography table in the data source view is used as the source of the Geography dimension. The table has the following structure.
The Geography dimension has three attribute hierarchies:
– City
– State-Province
– Country
The attributes have the following relationships defined: City > State-Province > Country.
Each attribute has a key and a name sourced from the related key and name columns in the DimGeography table.
During processing, you receive the following error message:
“Errors in the OLAP storage engine:
A duplicate attribute key has been found when processing:
Table: ‘dbo_DimGeography’,
Column: ‘StateProvinceKey’, Value: ’23’.
The attribute is ‘State-Province’.”
You verify that the data is accurate.
You need to ensure that the dimension Processes successfully.
What should you do?
image_thumb[18]
A. Delete the Geography hierarchy.
B. Relate the State-Province and Country attributes directly to the City attribute.
C. Remove the duplicate data from the DimGeography table.
D. Remove the State-Province attribute.
Answer: B
QUESTION
Drag and Drop Questions
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a SQL Azure database.
The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table.
The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
image_thumb[19]
Answer:
image_thumb[20]
QUESTION
You develop a SQL Server Analysis Services (SSAS) stored procedure.
You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the stored procedure.
What should you do?
A. Register the assembly on the SSAS server instance.
B. Copy the assembly to the SSAS installation directory and register it by using the CREATE
ASSEMBLY T-SQL command.
C. Register the assembly on the SSAS server by using regedit.exe.
D. Register the assembly on the SharePoint server by using regeditexe.
Answer: A
QUESTION
You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the TransactionCost measure is five digits.
You need to ensure that the TransactionCost measure stores values to two digits of precision. What should you do?
A. Add a named calculation in the data source view that casts the data source column to two
digits of precision. Bind the TransactionCost measure to the new column.
B. Add a named query in the data source view that casts the data source column to two digits
of precision. Bind the TransactionCost measure to the new query.
C. Use the FormatString measure property to format TransactionCost as #,##0.00;-#,##0.00.
D. Use the FormatString measure property to format TransactionCost as Currency.
E. Use the MeasureExpression measure property to change the precision of TransactionCost to
two digits.
Answer: A
QUESTION
Hotspot Question
You are developing a SQL Server Analysis Services (S5AS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue, goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue indicator.
Which tab should you select? (To answer, select the appropriate tab in the work area.)
image_thumb[21]
Answer:
image_thumb[22]
QUESTION
Drag and Drop Questions
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenu measure group from a different database.
In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
image_thumb[23]
Answer:
image_thumb[24]
QUESTION
You execute the following code:
You need to reduce the amount of time it takes to execute the query.
What should you do?
image_thumb[25]
A. Replace LEFT(CustomerName ,1) = ‘a’ with CustomerName LIKE ‘a%’.
B. Partition the table and use the CustomerName column for the partition scheme.
C. Replace LEFT(CustomerName ,1) = ‘a’ with SUBSTRING(CustomerName ,1/1) = ‘a’.
D. Replace IX_CustomerName with a clustered index.
Answer: A
Studied Latest 70-466 PDF and VCE Version and almost 89% my test questions were viewed in this file before, it is amazing! Can have a look at this file
0
0