You need to verify that the database can be restored to a specific point in time
You maintain a SQL Server 2008 instance that contains a database named Finance.
Minimally logged operations are performed on the Finance database.
You need to verify that the database can be restored to a specific point in time.
What should you do?
What behavior should you expect?
You are tasked to analyze blocking behavior of the following query:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
WITH Customers AS (
SELECT *
FROM Customer ),
SalesTotal AS (
SELECT CustomerId, SUM(OrderTotal) AS AllOrderTotal
FROM SalesOrder)
SELECT CustomerId, AllOrderTotal
FROM SalesTotal
WHERE AllOrderTotal > 10000.00Íž
You need to determine if other queries that are using the Customer table will be blocked by this
query. You
also need to determine if this query will be blocked by other queries that are using the Customer
table.
What behavior should you expect?
Which settings from the properties of Printer1 should you modify?
You have a print server named Server1.
You install a printer on Server1. You share the printer as Printer1.
You need to configure Printer1 to be available only from 19:00 to 05:00 every day.
Which settings from the properties of Printer1 should you modify?
You need to ensure that you can successfully ping Server2 from Server1
You have two servers named Server1 and Server2. Both servers run Windows Server 2012 R2. The
servers are configured as shown in the following table.
The routing table for Server1 is shown in the Routing Table exhibit. (Click the Exhibit button.)
From Server1, you attempt to ping Server2, but you receive an error message as shown in the Error
exhibit. (Click the Exhibit button.)
You need to ensure that you can successfully ping Server2 from Server1.
What should you do on Server1?
You need to ensure that client computers can resolve IP addresses to host names
Your network contains multiple subnets.
On one of the subnets, you deploy a server named Server1 that runs Windows Server 2012 R2.
You install the DNS Server server role on Server1, and then you create a standard primary zone
named contoso.com.
You need to ensure that client computers can resolve IP addresses to host names.
What should you do first?
What should you do?
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008.
You are the administrator of the company database. Now you are in charge of a SQL Server
2008 instance. According to the company requirement, the names of all user-defined stored
procedures must contain the prefix usp_on all instances. Besides this, you must make sure
that stored procedures that do not contain this prefix cannot be created by you. What should
you do?
You need to ensure that all of the virtual machines that connect to Switch1 are isolated from the external net
Your network contains an Active Directory domain named contoso.com. The domain contains a
member server named Server1. Server1 runs Windows Server 2012 R2 and has the Hyper-V server
role installed.
You create an external virtual switch named Switch1. Switch1 has the following configurations:
Connection type: External network
Single-root I/O virtualization (SR-IOV): Enabled
Ten virtual machines connect to Switch1.
You need to ensure that all of the virtual machines that connect to Switch1 are isolated from the
external network and can connect to each other only. The solution must minimize network
downtime for the virtual machines.
What should you do?
What should you configure?
HOTSPOT
You have a Hyper-V host named HYPERV1. HYPERV1 hosts a virtual machine named DC1.
You need to prevent the clock on DC1 from synchronizing from the clock on HYPERV1.
What should you configure? To answer, select the appropriate object in the answer area.
Which clause should you use?
You create and populate a table named SiteNavigation by using the following statements:
CREATE TABLE SiteNavigation
(
SiteNavigationId INT PRIMARY KEY,
Linktext VARCHAR(10),
LinkUrl VARCHAR(40),
ParentSiteNavigationId INT NULL REFERENCES SiteNavigation(SiteNavigationId)
)
INSERT INTO SiteNavigation
VALUES (1,’First’,’http://first’,NULL)
,(2,’Second’,’http://second’,1)
,(3,’Third’,’http://third’,1)
,(4,’Fourth’,’http://fourth’,2)
,(5,’Fifth’,’http://fifth’,2)
,(6,’Sixth’,’http://sixth’,2)
,(7,’Seventh’,’http://seventh’,6)
,(8,’Eighth’,’http://eighth’,7)
You are tasked to write a query to list all site references that are more than two levels from the root
node.
The query should produce the following results:
LinkText LinkUrl DistanceFromRoot
Fourth
http://fourth 2
Fifth http://fifth 2
Sixth http://sixth 2
Seventh http://seventh 3
Eighth http://eighth 4
You have written the following query:
WITH DisplayHierarchy
AS (SELECT LinkText, LinkUrl,
SiteNavigationId, ParentSiteNavigationId,
0 AS DistanceFromRoot
FROM SiteNavigation
WHERE ParentSiteNavigationId IS NULL
UNION ALL
SELECT SiteNavigation.LinkText, SiteNavigation.LinkUrl,
SiteNavigation.SiteNavigationId, SiteNavigation.ParentSiteNavigationId,
dh.DistanceFromRoot + 1 AS DistanceFromRoot
FROM SiteNavigation
INNER JOIN DisplayHierarchy dh
ON SiteNavigation.ParentSiteNavigationId = dh.SiteNavigationId)
SELECT LinkText, LinkUrl, DistanceFromRoot
FROM DisplayHierarchy
You need to append a WHERE clause to the query.
Which clause should you use?
What should you configure?
You have a Hyper-V host named Server1 that runs Windows Server 2012 R2. Server1 hosts 50 virtual
machines that run Windows Server 2012 R2.
Your company uses smart cards for authentication.
You need to ensure that you can use smart card authentication when you connect to the virtual
machine by using Virtual Machine Connection.
What should you configure?