Which three actions should you perform in sequence?
DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report that sources data from
a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube
contains a date dimension and other dimensions. The report design includes two report
parameters named StartDate and FinishDate as shown in the following diagram.
The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the
dataset is filtered by the existing report parameters.
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 code segment should you use?
You have a SQL Server 2012 database that contains a table named Users. The Users
table contains usernames and passwords.
You need to ensure that all new records have a password.
Which code segment should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
You need to configure a data refresh schedule for the workbook that meets the requirements
You deploy a PowerPivot workbook to a document library in a Microsoft SharePoint site.
Workbook data comes from two different sources: Source A and Source B.
The workbook contains three small lookup tables from Source A, and five tables with a total
of 20 million rows from Source B. Data from Source A is updated at 9:00 A.M. and data from
Source B is updated throughout the day.
You have the following requirements:
Refresh the PowerPivot workbook with updated lookup data as soon as possible.
Minimize load on the source systems and the SharePoint environment during business
hours.
Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the
requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to implement the minimum number of required SSAS objects
You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
Dates
Delivery dates
Ship dates
You need to implement the minimum number of required SSAS objects.
What should you do?
You need to ensure that Account1 can connect to DB1
You have a SQL Server 2012 environment that contains two servers. The servers are
configured as shown in the following table.
After the failover is complete, a user receives the following error message when connecting
to DB1 on Server2:
“Msg 916, Level 14, State 1, Line 1
The server principal “Account1” is not able to access the database “DB1” under the
current security context.”
You verify that there is a server login for Account1 on Server2.
You need to ensure that Account1 can connect to DB1.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.
What is the best design to achieve the goal?
You need to design a data warehouse schema to support a multidimensional cube. The fact
table will contain multiple columns representing order dates, shipping dates, and billing
dates. The cube will contain a measure group based on the fact table.
What is the best design to achieve the goal? More than one answer choice may achieve the
goal. Select the BEST answer.
You need to implement the area conversion in the project
You are developing a Microsoft SQL Analysis Services (SSAS) multidimensional project
A fact table named FactHouseSales has a measure column named Area. All values in the
column are stored in square feet. Users must be able to analyze the area in different units.
You create a table named AreaUnit. Each row in the table consists of the unit name and a
square feet conversion factor value.
You need to implement the area conversion in the project.
What should you do?
You need to run two separate SQL statements
You use SQL Server 2014 to maintain the data used by applications at your company.
You need to run two separate SQL statements.
You must guarantee that the following three things happen:
1. Either BOTH statements succeed or BOTH statements fail as a batch.
2. If an error occurs on the first statement, SQL should not attempt to run the second
statement.
3. Error information should be returned to the client.
What should you do?
Which isolation level should you identify?
DRAG DROP
You plan to deploy two stored procedures name USP_1 and USP_2 that read data from a
database.
Your company identifies the following requirements for each stored procedure:
USP_1 cannot allow dirty reads.
USP_2 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.)
You need to set up a rule that every STATE.Country_Abbr must match an existing record in the COUNTRY table
DRAG DROP
You have two existing tables, one named COUNTRY and the other named STATES.
The tables are defined as follows:
You need to set up a rule that every STATE.Country_Abbr must match an existing record in
the COUNTRY table.
Develop the solution by selecting and arranging the required code blocks in the correct order.
You may not need all of the code blocks.