Which type of table should you identify?
You plan to modify a procedure that contains hundreds of lines of code.
The modification must support the following guidelines:
Use only tables that are not persistent in the database.
Minimize the amount of time required to execute and recompile procedures.
You need to identify which type of table must be used to support the planned modification.
Which type of table should you identify?
You need to redesign the cube dimension to meet the requirements
An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You
have the following requirements:
Implement drill-down browsing.
Reduce the number of attribute hierarchies but ensure that the information contained within
them is available to users on demand.
Optimize performance.
You need to redesign the cube dimension to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to create a measure to count unique customers
You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?
Which code segment should you execute?
You have a SQL Azure database.
You execute the following script:
You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value
for Column2.
You plan to deploy an application that will search Column2.
You need to create an index on Table1 to support the planned deployment. The solution
must minimize the storage requirements.
Which code segment should you execute?
You need to perform the following maintenance tasks: Identify unused indexes
DRAG DROP
You have a database named database1. Each table in database1 has one index per column.
Users often report that creating items takes a long time.
You need to perform the following maintenance tasks:
Identify unused indexes.
Identify indexes that need to be defragmented.
What should you use?
To answer, drag the appropriate function to the correct management task in the answer
area. (Answer choices may be used once, more than once, or not at all.)
Which code segment should you execute?
DRAG DROP
You have a SQL Server 2012 database named DB1. DB1 contains four filegroups named
FG1, FG2, FG3, and FG4. You execute the following code:
Two million rows are added to dbo.Sales.
You need to move the data from the first partition to a new table named SalesHistory and,
starting on December 31, 2012, repartition dbo.Sales to support new sales data for three
months.
Which code segment should you execute?
To answer, move the appropriate code segments from the list of code segments to the
answer area and arrange them in the correct order.
Which relationship type should you choose?
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named
Category is based on the DimCategory table.
A subset of the data source view is shown in the following graphic.
You need to relate the Category dimension to the Sales measure group.
Which relationship type should you choose?
To answer, select the appropriate option from the drop-down list in the dialog box.
You need to create a time dimension
You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at
the day granularity level. It must also be linked to a measure group named Salary at the
month granularity level.
What should you do?
You need to ensure that every time a new row is added to the Orders table, a table that is used for auditing i
You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a table that is
used for auditing is updated.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
Data is frequently queried at the day level and occasionally at the month level.
You are designing a partitioning strategy for a large fact table in a Manufacturing data
warehouse.
Tens of millions of new inventory fact records are loaded into the data warehouse weekly,
outside of business hours. Most queries against the database are generated by reports and
by cube processing. Data is frequently queried at the day level and occasionally at the
month level.