Which four Transact-SQL statements should you use?
You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso
database has a table named ProductPrices in a schema named Sales.
You need to create a script that writes audit events into the application log whenever data in the ProductPrices
table is updated.
Which four Transact-SQL statements should you use? (To answer, move the appropriate statements from the
list of statements to the answer area and arrange them in the correct order.)
Select and Place:
You need to log health-monitoring events with severity level of error to the Windows application eventlog
You deploy an ASP.NET application to an IIS server.
You need to log health-monitoring events with severity level of error to the Windows application eventlog.
What should you do?
Which three actions should you perform in sequence?
You administer a Microsoft SQL Server 2012 database.
Your database is experiencing deadlock issues. You need to be able to monitor deadlocks.
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.)
Select and Place:
Which code segment should you use?
You are implementing an ASP.NET page.
The page includes a method named GetCustomerOrderDataSet that returns a DataSet.
The DataSet includes a DataTable named CustomerDetailsTable and a DataTable named OrderDetailsTable.
You need to display the data in OrderDetailsTable in a DetailsView control named dtlView.
Which code segment should you use?
Which four actions should you perform in sequence?
You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a
local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server
Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database.
When you execute the SQL Server Agent job, it failsdue to a permissions failure on a share on a remote
server.
You need to ensure that the SQL Server Agent job can execute the SSIS package.
Which four 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.)
Select and Place:
You need to configure the ObjectDataSource control to pass the value of the pid field to GetProductsByProductI
You are implementing an ASP.NET page.
You add and configure the following ObjectDataSource.
<asp:ObjectDataSource SelectMethod=”GetProductByProductId” ID=”odc”
runat=”server” TypeName=”ProductDAL”>
<SelectParameters>
<asp:Parameter Name=”productId” Type=”Int32″ />
</SelectParameters>
</asp:ObjectDataSource>
The page will be called with a query string field named pid.
You need to configure the ObjectDataSource control to pass the value of the pid field to
GetProductsByProductId method.
What should you do?
Which three actions should you perform in sequence?
You administer a Microsoft SQL Server 2012 database.
You need to convert the database to a contained database. You also need to ensure that all users are
converted to contained users.
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.)
Select and Place:
You need to cache the retrieved data so that the database is not queried each time the Web page is accessed
You are implementing an ASP.NET Web application that retrieves data from a Microsoft SQL Server database.
You add a page that includes the following data source control.
<asp:SqlDataSource id=”sqlds” runat=”server” ConnectionString=”<%$
ConnectionStrings:MyDB %>” SelectCommand=”SELECT * FROM Companies” />
The page is accessed frequently, but the data in the database rarely changes.
You need to cache the retrieved data so that the database is not queried each time the Web page is accessed.
What should you do?
Which four actions should you perform in sequence?
You administer a Microsoft SQL Server 2012 clustered instance that has two nodes named Node 1 and Node 2.
Node 1 fails and the cluster fails over to Node 2.
You need to replace Node 1 and add it to the cluster.
Which four 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.)
Select and Place:
Which code segment should you use?
You are implementing an ASP.NET page.
Client-side script requires data.
Your application includes a class named Person witha Name property of type string.
The code-behind file of the page includes the following code segment.
public string JsonValue;
List<Person> people = GetPeopleList();
JavaScriptSerializer json = new JavaScriptSerializer();
You need to use the JavaScriptSerializerclass to serialize only the Name property of each item in the people
list.
Which code segment should you use?