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.)
Build List and Reorder:

Explanation:
--Burgos - YES (but with different's blocks of commands) Reference: http://msdn.microsoft.com/en-us/library/cc280386.aspx Reference: http://msdn.microsoft.com/en-us/library/cc280448.aspx Reference: http://msdn.microsoft.com/en-us/library/cc280404.aspx

You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the primary server is unaffected. Which configuration should you use?

• A. Two servers configured on the same subnet SQL Server Availability Group configured in Synchronous-Commit Availability Mode
• B. Two servers configured in different data centers SQL Server Availability Group configured in Synchronous-Commit Availability Mode One server configured as an Active Secondary
• C. Two servers configured in different data centers SQL Server Availability Group configured in Asynchronous-Commit Availability Mode
• D. Two servers configured in the same data center SQL Server Availability Group configured in Asynchronous-Commit Availability Mode One server configured as an Active Secondary
• E. Two servers configured in a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance
• F. Two servers configured in the same data center A primary server configured to perform log-shipping every 10 minutes A backup server configured as a warm standby
• G. SQL Server that includes an application database configured to perform snapshot replication
• H. SQL Server that includes an application database configured to perform transactional replication

Explanation: Only visible for DumpsFree members. You can sign-up / login (it's free).

You are a database developer of a Microsoft SQL Server 2012 database. The database contains a table named Customers that has the following definition:

You need to ensure that the CustomerId column in the Orders table contains only values that exist in the CustomerId column of the Customer table. Which Transact-SQL statement should you use?

• A. ALTER TABLE Customer ADD OrderID INT NOT NULL;
  ALTER TABLE Customer ADD CONSTRAINT FK_Customer_OrderID FOREIGN KEY (OrderID) REFERENCES Orders (OrderID);
• B. ALTER TABLE Orders ADD CONSTRAINT FK_Orders_CustomerID FOREIGN KEY (CustomerID) REFERENCES Customer (CustomerID)
• C. ALTER TABLE Orders ADD CONSTRAINT CK_Orders_CustomerID CHECK (CustomerID IN (SELECT CustomerId FROM Customer))
• D. ALTER TABLE Orders ADD CONSTRAINT PK_Orders_CustomerID PRIMARY KEY (CustomerID)
• E. ALTER TABLE Customer ADD CONSTRAINT FK_Customer_CustomerID FOREIGN KEY (CustomerID) REFERENCES
  Orders (CustomerID)

Explanation: Only visible for DumpsFree members. You can sign-up / login (it's free).

You develop a database for a travel application. You need to design tables and other database objects. You create the Airline_Schedules table. You need to store the departure and arrival dates and times of flights along with time zone information. What should you do?

• A. Use an appropriate collation.
• B. Use the DATETIME data type.
• C. Use the VARBINARY data type.
• D. Use the DATE data type.
• E. Use a user-defined table type.
• F. Use the DATETIME2 data type.
• G. Use the DATETIMEOFFSET data type.
• H. Use the TODATETIMEOFFSET function.
• I. Use the CAST function.
• J. Use the FORMAT function.

Explanation: Only visible for DumpsFree members. You can sign-up / login (it's free).

You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/ Server01 is the primary replica. You have multiple queries that read data and produce reports from the database. You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica. What should you do?

• A. Set the Availability Mode property of HA/Server01 to Asynchronous commit.
• B. Set the Availability Mode property of HA/Server02 to Asynchronous commit.
• C. Set the Connections in Primary Role property of HA/Server01 to Allow read/write connections.
• D. Set the Readable Secondary property of HA/Server02 to Read-intent only.

Explanation: Only visible for DumpsFree members. You can sign-up / login (it's free).