You need to implement a solution that meets the needs of the sales team while minimizing development and admin
You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used
by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team
does not need any information other than sales-related resources in the tabular model. The
finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing
development and administrative effort.
What should you do?
What should you modify?
You execute the following code:
The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)
You need to prevent the key lookup.
What should you modify?
More than one answer choice may achieve the goal. Select the BEST answer.
Which role permission should you use?
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a
data model.
Which role permission should you use?
Which advanced server option should you modify?
You have a database for a mission-critical web application. The database is stored on a SQL
Server 2012 instance and is the only database on the instance.
The application generates all T-SQL statements dynamically and does not use stored
procedures.
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?
You need to import data to Table1
DRAG DROP
You have a table named Table1. Table1 has 1 million rows.
Table1 has a columnstore index for a column named Column1.
You need to import data to Table1. The solution must minimize the amount of time it takes to
import the data.
What should you do?
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 use the least amount of development effort to achieve this goal
You are developing a SQL Server Analysis Services (SSAS) tabular project.
In the data warehouse, a table named Sales Persons and Territories defines a relationship
between a salesperson’s name, logon ID, and assigned sales territory.
You need to ensure that each salesperson has access to data from only the sales territory
assigned to that salesperson. You need to use the least amount of development effort to
achieve this goal.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to ensure that you can insert rows into the underlying tables by using the view
You have an application that uses a view to access data from multiple tables.
You need to ensure that you can insert rows into the underlying tables by using the view.
What should you do?
Which technologies should you identify?
DRAG DROP
You are designing two stored procedures named Procedure1 and Procedure2.
You identify the following requirements:
Procedure1 must take a parameter that ensures that multiple rows of data can pass into the
stored procedure.
Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct stored procedure in the answer
area. (Answer choices may be used once, more than once, or not at all.)
Which event class should you use?
You are troubleshooting query performance for a SQL Server Analysis Services (SSAS)
cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?
Which query should you use?
You have a database that contains a user-defined function named Schema1.Udfl and two
tables named Schema1.Table1 and Schema1.Table2.
Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as
shown in the following table.
Schema1.Udf1 was defined by using the following code:
You need to write a query that will contain the following columns:
Country
CountryID
CustomerName
The solution must meet the following requirements:
Rows must be returned only if the function returns data.
The amount of time it takes the query to execute must be minimized.
Which query should you use?