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 Azure 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 Server databases. Each database is on a
different instance. 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 three actions should you perform in sequence?
DRAG DROP
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project
deployment model.
You need to monitor control flow tasks to determine whether any of them are running longer
than usual.
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 validating whether a SQL Server Integration Services (SSIS) package named
Master.dtsx in the SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow
component of the package.
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.)
You need to resolve the issues by configuring the properties of the dimension attributes
HOTSPOT
You have a database named DB1. DB1 contains three tables named FactSales,
DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.
A sample from DimCustomer is shown in the following table.
A sample from FactSales is shown in the following table.
You create a cube named Sales that uses the three tables. FactSales is used as a fact table,
DimCustomer is used to create a dimension named Customer, and DimEmployee is used to
create a dimension named Employee.
Users report the following issues:
When browsing the Customer dimension, the users see a blank member in the state
hierarchy under United Kingdom.
When browsing the Employee dimension, the sales data for Sales Managers and Sales
Supervisors is NOT displayed.
You need to resolve the issues by configuring the properties of the dimension attributes.
What should you do? To answer, select the appropriate value for each property in the answer area.
You need to ensure that usp_GetCustomersByDate completes as quickly as possible
You have database objects that were created by using the following script:
The dbo.Customers table has 1 million rows.
You discover that usp_GetCustomersByDate takes a long time to complete.
The query plan used by the stored procedure is shown in the exhibit. (Click the Exhibit button.)
You need to ensure that usp_GetCustomersByDate completes as quickly as possible.
What should you do?
Which isolation level should you identify?
DRAG DROP
You plan to deploy two stored procedures named SP1 and SP2 that read data from the
database.
Your company identifies the following requirements for each stored procedure:
SP1 must allow dirty reads.
SP2 must place range locks on the data to ensure read consistency.
You need to identify which isolation level you must set for each stored procedure. The
solution must minimize the number of locks.
Which isolation level should you identify?
To answer, drag the appropriate isolation level to the correct stored procedure in the answer
area. (Answer choices may be used once, more than once, or not at all.)
What should you create?
DRAG DROP
You execute the following code:
You discover that the Customers table was created in the dbo schema.
You need to create a code segment to move the table to another schema named Schema2.
What should you create?
To answer, drag the appropriate code segments to the correct location in the answer area.
(Answer choices may be used once, more than once, or not at all.)
You need to design the fact table to meet the requirements
You are designing a fact table in a SQL Server database.
The fact table must meet the following requirements:
Include a columnstore index.
Allow users to choose up to 10 dimension tables and up to five facts at one time.
Maximize performance of queries that aggregate measures by using any of the 10
dimensions.
Support billions of rows.
Use the most efficient design strategy.
You need to design the fact table to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
Which project types should you use?
You are developing a BI Semantic Model (BISM) based on a simple and small dataset
sourced from SQL Server. The data size and complexity of the data relationships will not
change. The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all
that apply.)