Which six actions should you perform in sequence?
DRAG DROP
You administer three Microsoft SQL Server 2008 R2 instances.
Database mirroring is configured in High-Safety mode with Automatic Failover between the following three
servers:
· SQL1 is the Principal server.
· SQL2 is the mirror server.
· SQL3 is the witness server.
You need to upgrade SQL1 and SQL2 to SQL Server 2012. You need to ensure that downtime is minimized
during the upgrade.
Which six 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 three actions should you perform in sequence?
DRAG DROP
You administer three Microsoft SQL Server 2012 servers named ServerA, ServerB, and ServerC. ServerA is
the acting principal and ServerB is the mirror.
You need to add ServerC as a witness to the existing mirroring session between ServerA and ServerB. You
need to achieve this goal without delaying synchronization.
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 two actions should you perform?
You create a custom server control named Task that contains the following code segment. (Line numbers are
included for reference only.)
01 namespace DevControls
02 {
03 public class Task : WebControl
04 {
05 [DefaultValue(“”)]
06 public string Title { … }
07
08 protected override void RenderContents(HtmlTextWriter output)
09 {
10 output.Write(Title);
11 }
12 }
13 }
You need to ensure that adding a Task control from the Toolbox creates markup in the following format.
<Dev:Task ID=”Task1″ runat=”server” Title=”New Task” />
Which two actions should you perform? (Each correctanswer presents part of the solution. Choose two.)
You need to prepare the AdventureWorks database fordatabase mirroring
You administer two Microsoft SQL Server 2012 servers named ServerA and ServerB. You use a database
named AdventureWorks.
You need to prepare the AdventureWorks database fordatabase mirroring. ServerB will act as the mirrorin a
mirroring partnership along with ServerA.
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 dynamically add values to the end of the drop-down list
You are implementing an ASP.NET page that includes the following drop-down list.
<asp:PlaceHolder ID=”dynamicControls” runat=”server”>
<asp:DropDownList ID=”MyDropDown” runat=”server”>
<asp:ListItem Text=”abc” value=”abc” />
<asp:ListItem Text=”def” value=”def” />
</asp:DropDownList>
</asp:PlaceHolder>
You need to dynamically add values to the end of the drop-down list.
What should you do?
Which three actions should you perform in sequence?
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance
named SQL2005 and a development SQL Server 2012 instance named SQL2012.
The development team develops a new application that uses the SQL Server 2012 functionality. You are
planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new
application.
You need to migrate the database without affecting the production environment.
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:
What are two possible ways to achieve this goal?
You create an ASP.NET page that contains the following tag.
<h1 id=”hdr1″ runat=”server”>Page Name</h1>
You need to write code that will change the contents of the tag dynamically when the page is loaded.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose
two.)
Which four Transact-SQL statements should you use?
You administer a Microsoft SQL Server 2012 database.
You use an OrderDetail table that has the followingdefinition:
You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only
rows that contain a value in the SpecialOfferID column.
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:
Which code segment should you use?
You are creating an ASP.NET Web site.
The site is configured to use Membership and Role management providers.
You need to check whether the currently logged-on user is a member of a role named Administrators.
Which code segment should you use?
You need to ensure that the JavaScript for each of these controls that is used in an ASP.NET page…
You are implementing custom ASP.NET server controls.
You have a base class named RotaryGaugeControl and two subclasses named CompassGaugeControl and
SpeedGaugeControl.
Each control requires its own client JavaScript code in order to function properly.
The JavaScript includes functions that are used to create the proper HTML elements for the control.
You need to ensure that the JavaScript for each of these controls that is used in an ASP.NET page is included
in the generated HTML page only once, even if the ASP.NET page uses multiple instances of the given control.
What should you do?