DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a
Microsoft Azure SQL Database 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.)
Answer: See the explanation.
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* To process a table
In SQL Server Management Studio, in the tabular model database which contains the table
you want to process, expand theTablesnode, then right-click on the table you want to
process, and then clickProcess Table.
In theProcess Tabledialog box, in theModelistbox, select one of the following process
modes:
EtcReference: Process Database, Table, or Partition
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00215.jpg
0
0
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00416.jpg
0
0
When development has been finished, we no more have access to the project. What we have i a deployed model to SSAS. We need to connect to it using SSMS that generally would allow you to define all administrative settings, including processing.
Presented answer by Carlos is OK.
0
0