Which code segment should you execute?
DRAG DROP
You have a SQL Server 2012 database named Database1. Database1 has a data file
named Database1_data.mdf and a transaction log named Database1jog.ldf.
Database1_data.mdf is 1.5 GB. Database1jog.ldf is 1.5 terabytes.
A full backup of Database1 is performed every day.
You need to reduce the size of the log file. The solution must ensure that you can perform
transaction log backups in the future.
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.
You need to view the server resource consumption when the queries are executed
DRAG DROP
You have a SQL Server 2012 database named database1.
Users report that queries that usually take less than one second to execute, take more than
30 seconds to execute.
You need to view the server resource consumption when the queries are executed.
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.
Which configuration type should you use?
HOTSPOT
You are designing a SQL Server Integration Services (SSIS) package configuration strategy.
The package configuration must meet the following requirements:
Include multiple properties in a configuration.
Support several packages with different configuration settings.
You need to select the appropriate configuration.
Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.
How should you configure the filter?
DRAG DROP
You are designing a dataset for a SQL Server Reporting Services (SSRS) report.
The report includes the report items displayed in the following graphic.
The dataset is sourced from a commonly used stored procedure in an inventory data mart
hosted in a SQL Azure database.
It returns the status for all products across all storage sites. The report must display data for
the storage site that is selected by the Site report parameter. You cannot change the stored
procedure code.
You need to filter the dataset to use only data specific to the selected site.
How should you configure the filter?
To answer, drag the appropriate expression or expressions to the correct location or
locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Which connection type should you choose?
You are developing a SQL Server Reporting Services (SSRS) report for a company that has
a subscription to a dataset from the Microsoft Azure Data Market.
The dataset permits flexible queries.
You need to choose the connection type for the data source.
Which connection type should you choose?
You need to ensure that the query uses the index
You create a table named Customers by using the following code segment:
You create a non-clustered index named IX_Name on the name column.
You write the following query to retrieve all of the customers that have a name that starts
with the letters SMI:
You discover that the query performs a table scan.
You need to ensure that the query uses the index.
What should you do?
You need to design a solution that meets the requirements
You are designing a SQL Server Integration Services (SSIS) solution. The solution will
contain an SSIS project that includes several SSIS packages. Each SSIS package will
define the same connection managers and variables.
You have the following requirements:
• Ensure that the deployment model supports changing the content of connection
strings by using parameters at execution time.
• Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
• Maximize performance at execution time.
• Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to include additional data sourced from a Microsoft Azure SQL Database database in the report
You are designing a SQL Server Reporting Services (SSRS) report.
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a Microsoft Azure SQL Database database
in the report.
What should you do?
How many rows should you identify?
You plan to execute the following code:
You need to identify how many rows will be in dbo.Table1 after you execute the code.
How many rows should you identify?
Which setting should you select?
HOTSPOT
You are configuring the partition storage settings for a SQL Server Analysis Services (SSAS) cube.
The partition storage must meet the following requirements:
Optimize the storage of source data and aggregations in the cube.
Use proactive caching.
Drop cached data that is more than 30 minutes old.
Update the cache when data changes, with a silence interval of 10 seconds.
You need to select the partition storage setting.
Which setting should you select?
To answer, select the appropriate setting in the answer area.