Which five code segments should you use?
DRAG DROP
You create a table that contains the following script:
You need to prevent duplicate values in the EmployeeID field.
Which five code segments should you use?
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 type of index should you create for each table?
DRAG DROP
Your network contains a SQL Server 2012 instance named SQL1. SQL1 contains a
database named DB1. DB1 contains three tables.
The tables are configured as shown in the following table.
You plan to create indexes for the tables.
You need to identify which type of index must be created for each table. The solution must
minimize the amount of time required to return information from the tables.
Which type of index should you create for each table? To answer, drag the appropriate index
type to the correct table in the answer area.
You need to design the data access strategy
A group of report writers develop reports. The report writers currently use Report Builder 1.0
and report models. The report writers are not trained on SQL Server query writing. Their
report assignments come from various departments within the organization.
The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS)
in native mode. After the upgrade, reports will retrieve data from a large new data
warehouse that will reside on an instance of the SQL Server 2012 Database Engine.
Reports for each department will retrieve data from only a subset of the data warehouse
tables.
You are designing the data access strategy. You have the following requirements:
Ensure that report writers can create only reports that display data which they have
database permissions to view.
Minimize the effort required to update connection strings for all reports developed by the
report writers.
Minimize the number of fields visible in a specific report for report writers who work for
multiple departments.
You need to design the data access strategy.
What should you do? (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
tabular model.
Which role permission should you use?
Which type of index defragmentation solution should you include in the recommendation?
You have a SQL Server 2012 instance named SQL\Instance1. Instance1 contains a
database named Database1.
You need to recommend an index defragmentation solution for an index named
ContentIndex. ContentIndex must meet the following requirements:
Remain online during the defragmentation.
Update distribution statistics.
Perform defragmentation as quickly as possible.
Which type of index defragmentation solution should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
You need to create a fully automated solution to ensure that reports do not deliver purged data
A company runs SQL Server Database Engine and SQL Server Reporting Services (SSRS)
in native mode. Reports are based on data that is cached in multiple shared datasets.
Source data is purged each day at midnight for regulatory compliance purposes. The shared
datasets may continue to cache data that should not be used in reports. Shared report
schedules are often paused during nightly server maintenance windows.
Reports must not return purged data.
You need to create a fully automated solution to ensure that reports do not deliver purged
data.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
Which Data Analysis Expressions (DAX) expression should you use?
You are developing a SQL Server PowerPivot workbook that sources data from a Microsoft
Azure SQL Database database. The PowerPivot model includes a single table named
FactSales that consists of four columns named Year, Country, Product and Revenue. The
model includes the following two measures.
Sales:=SUM(FactSales[Revenue])
Sales %:=[Sales] / CALCULATE([Sales], ALL(FactSales))
In Microsoft Excel 2010 you create the following PivotTable report.
Users report that the Sales % measure computes an incorrect ratio. The measure should
meet a requirement to compute a ratio over all visible sales values defined by the query
filters. The Grand Total value for the Sales % measure should equal 100%.
You need to fix the Sales % measure to meet the requirement.
Which Data Analysis Expressions (DAX) expression should you use?
Which keyword should you identify?
You have a SQL Azure database.
You need to identify which keyword must be used to create a view that will be indexed.
Which keyword should you identify?
How should you design the report?
You are designing a complex report that displays sales metrics for a customer hierarchy.
The customer hierarchy has six levels and contains approximately 1 million members.
You have the following requirements:
Allow users to easily display and navigate data.
Minimize report processing time.
Simplify the report design and maintenance processes.
You need to design a report that meets the requirements.
How should you design the report? (More than one answer choice may achieve the goal.
Select the BEST answer.)
Which query mode should you select?
You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize
performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode.
Which query mode should you select?