Which three actions should you perform in sequence?
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.)
What should you include in the recommendation?
You plan to create a database that has multiple tables. The tables will contain product
information. Each product has a stock-keeping unit (SKU).
You need to recommend a solution to ensure that each SKU starts with the letters “ADV”
and is followed by 10 digits.
The solution must minimize the amount of development effort required.
What should you include in the recommendation?
You need to ensure that users can receive reports by email according to their preferences
You are designing a subscription strategy for a SQL Server Reporting Services (SSRS)
report.
You have an application that populates a table with user-specific subscription schedules and
report formats.
You need to ensure that users can receive reports by email according to their preferences.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
Which three actions should you perform in sequence?
DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
An existing report aggregates data from a SQL Server database in a chart.
You need to use the chart in a new report and ensure that other users can use the chart in
their reports.
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.)
What should you do?
DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
A report project must access multiple SQL Azure databases. Each database is on a different
host. The databases have identical schema and security configurations.
You have the following requirements:
• The report must support subscriptions.
• Users must be able to select the host when running the report.
What should you do?
To answer, drag the appropriate phrase or phrases from the list to the correct location or
locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Which option should you select?
HOTSPOT
A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A
role named USA allows users to browse data pertaining to the United States. A role named
Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data
pertaining to Canada. You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.
Which three actions should you perform in sequence?
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.)
Which three actions should you perform in sequence?
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
You identify that a dimension, which has a large number of attributes, is issuing a separate
(SELECT DISTINCT) query for each attribute even though they all come from a single
database table. The table does not have a large number of rows.
You need to configure the processing of the dimension to issue only a single SQL query to
the underlying database, and processing must continue if any errors are encountered.
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.)
What should you add to the query?
You have a database that contains a table named Department. Department contains the
names and locations of each department.
You have a table-valued function named ProjectList() that returns a list of all the projects
assigned to a department. The name of the department is passed as an argument to the
ProjectList() function.
You need to create a query that returns a list of all the department names and the project
names. The solution must return only departments that are associated to projects.
What should you add to the query?
You need to ensure that the report displays data filtered by the user-entered value
You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server
Analysis Services (SSAS) cube. The report defines a report parameter of data type
Date/Time with which users can filter the report by a single date. The parameter value
cannot be directly used to filter the Multidimensional Expressions (MDX) query for the
dataset.
You need to ensure that the report displays data filtered by the user-entered value. You must
achieve this goal by using the least amount of development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)