QUESTION NO: 1
You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance.
You need to ascertain the memory consumed by each object in the SSAS instance.
What should you do?
You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance.
You need to ascertain the memory consumed by each object in the SSAS instance.
What should you do?
Correct Answer: A
Vote an answer
QUESTION NO: 2
HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)
HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)
Correct Answer:
QUESTION NO: 3
You need to configure per-user security authentication for reporting against the Sales cube.
What should you do? (Each correct answer presents part of the complete solution. Choose all that apply.)
You need to configure per-user security authentication for reporting against the Sales cube.
What should you do? (Each correct answer presents part of the complete solution. Choose all that apply.)
Correct Answer: A,B
Vote an answer
QUESTION NO: 4
You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dimension.
The marketing team has requested that customer marketing categories be added to the database.
The marketing categories must meet the following requirements:
* A customer member must be able to belong to multiple category members.
* A category member must be able to group several customer members.
* The marketing team must be able to create new categories every month in the data source.
You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dimension.
The marketing team has requested that customer marketing categories be added to the database.
The marketing categories must meet the following requirements:
* A customer member must be able to belong to multiple category members.
* A category member must be able to group several customer members.
* The marketing team must be able to create new categories every month in the data source.
You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: D
Vote an answer
QUESTION NO: 5
You need create the data source view for the StandardReports project.
What should you do?
You need create the data source view for the StandardReports project.
What should you do?
Correct Answer: A
Vote an answer
QUESTION NO: 6
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Revenue 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 revenue.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Revenue 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 revenue.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
Correct Answer: A,C,D
Vote an answer
QUESTION NO: 7
You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate.
You need to ensure that users can slice the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate.
You need to ensure that users can slice the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: D
Vote an answer
QUESTION NO: 8
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a Microsoft Azure SQL Database database. The cube is processed each night at midnight.
The largest partition in the cube takes 12 hours to process, and users are unable to access the cube until noon. The partition must be available for querying as soon as possible after processing commences.
You need to ensure that the partition is available for querying as soon as possible, without using source data to satisfy the query.
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.)
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a Microsoft Azure SQL Database database. The cube is processed each night at midnight.
The largest partition in the cube takes 12 hours to process, and users are unable to access the cube until noon. The partition must be available for querying as soon as possible after processing commences.
You need to ensure that the partition is available for querying as soon as possible, without using source data to satisfy the query.
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.)
Correct Answer:
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* Processing mode has two possible options.
Regular. This is the default setting. When set to regular, partitions will be available to users after data has been loaded and aggregations are created completely.
Lazy Aggregations. When set to lazy aggregations, partitions will be available to user queries immediately after data has been loaded. Aggregations will be created as a separate background process while users start to query the partition.
* Lazy processing performs the task of building indexes and aggregations for dimensions and measure group partitions at a lower priority to reduce foreground processing time and to allow users to query the cube sooner. For lazy processing to occur, you must switch the ProcessingMode = LazyAggregations of your measure group partitions; by default this value is Regular (lazy processing is turned off). When processing a dimension with flexible aggregations such as parent-child or virtual dimension by using the processing enumeration of ProcessUpdate (such as to take into account of member name or hierarchy changes), lazy processing is initiated to ensure that the aggregations are rebuilt on the associated measure group partitions.
* Configure Lazy Processing for the cube, measure group, or partition. If you configure Lazy Processing, the dropped aggregations are recalculated as a background task. While the flexible aggregations are being recalculated, users can continue to query the cube (without the benefit of the flexible aggregations). While the flexible aggregations are being recalculated, queries that would benefit from the flexible aggregations run slower because Analysis Services resolves these queries by scanning the fact data and then summarizing the data at query time. As the flexible aggregations are recalculated, they become available incrementally on a partition-by-partition basis. For a given cube, Lazy Processing is not enabled by default. You can configure it for a cube, measure group, or partition by changing the ProcessingMode property from Regular to LazyAggregations. To manage Lazy Processing, there are a series of server properties such as the LazyProcessing \ MaxObjectsInParallel setting, which controls the number of objects that can be lazy processed at a given time. By default it is set to 2. By increasing this number, you increase the number of objects processed in parallel; however, this also impacts query performance and should therefore be handled with care.
* Incorrect: With Bring Online Immediately enabled, during cache refresh all queries are directed to the relational source database to retrieve the latest data for end users. While this provides users with refreshed data, it can also result in reduced query performance given that Analysis Services needs to redirect queries to the relational source database.
QUESTION NO: 9
You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube includes a dimension named Account and the dimension's Type property is set to Accounts. The Account dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube includes a dimension named Account and the dimension's Type property is set to Accounts. The Account dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: C
Vote an answer
QUESTION NO: 10
You need to deploy the StandardReports project.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
You need to deploy the StandardReports project.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
Correct Answer: C,D
Vote an answer
QUESTION NO: 11
You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain usercreated stored procedures or user-created functions. You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?
You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain usercreated stored procedures or user-created functions. You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?
Correct Answer: B
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).