Which code segment should you execute?
You have a SQL Server 2012 database named DB1. You have a backup device named
Device1.
You discover that the log file for the database is full.
You need to ensure that DB1 can complete transactions. The solution must not affect the
chain of log sequence numbers (LSNs).
Which code segment should you execute?
You need to optimize the partition structure and design aggregations to improve query performance and minimize
You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube
named Sales. Before the initial deployment of the cube, partition design was optimized for
processing time. The cube currently includes five partitions named FactSalesl through
FactSales5. Each partition contains from 1 million to 2 million rows.
The FactSales5 partition contains the current year’s information. The other partitions contain
information from prior years; one year per partition. Currently, no aggregations are defined
on the partitions.
You remove fact rows that are more than five years old from the fact table in the data source
and configure query logs on the SSAS server.
Several queries and reports are running very slowly.
You need to optimize the partition structure and design aggregations to improve query
performance and minimize administrative overhead.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to hide the tables and columns
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and
tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?
Which three actions should you perform in sequence?
DRAG DROP
You are planning the installation of PowerPivot for SharePoint.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the
Default Account username used to provision shared services in the SharePoint farm.
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 developing a SQL Server Analysis Services (SAS) multidimensional project that is
configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create
and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to
use a remote server to process data contained within the partition.
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 recommend creating?
You have a Microsoft SQL Azure database named DBAzure1.
You create a table in DBAzure1 by using the following script:
You need to recommend a solution to ensure that each combination of CustomerContact
and CustomerDetails is not duplicated.
What should you recommend creating?
Which encryption type and data type should you identity?
DRAG DROP
You plan to create a new table that will contain a column named Salary. Salary will contain
highly sensitive data.
Salary must meet the following requirements:
Contain numeric data.
Contain only encrypted data that remains encrypted in memory.
You need to identify which encryption type and data type must be used for Salary.
Which encryption type and data type should you identity?
To answer, drag the appropriate encryption type and data type to the correct identifier in the answer area.
Which item should you configure?
HOTSPOT
A school stores information about teachers, students, classes, and enrollments in a
Windows Azure SQL Database database. The database includes a table that maps the user
IDs of teachers to the subjects they teach.
Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their
credentials.
You are developing a report that displays a table of class enrollments for a specific subject.
The report will prompt teachers to select from their mapped subjects. The table is based on
a dataset named ClassData. To minimize report execution time, the ClassData dataset has
been configured to cache all class enrollment data.
You need to ensure that the report parameter displays the correct subjects for each teacher.
Which item should you configure? To answer, select the appropriate item in the answer area.
Which data access strategy should you use?
You are planning to develop a SQL Server Analysis Services (SSAS) tabular project. The
project will be deployed to a SSAS server that has 16 GB of RAM.
The project will source data from a SQL Server database that contains a fact table named
Sales. The fact table has more than 60 billion rows of data.
You need to select an appropriate design to maximize query performance.
Which data access strategy should you use? (More than one answer choice may achieve
the goal. Select the BEST answer.)
Which option should you include?
You plan to create a new table that has the following requirements:
Uses a GUID data type as the primary key.
Uses a clustered index as the primary key.
Minimizes fragmentation.
You need to recommend which option to include in the CREATE statement.
Which option should you include?
More than one answer choice may achieve the goal. Select the BEST answer.