QUESTION 41 You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server. What should you create? A.    an Extended Event session B.    a Read more

QUESTION 31 You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use? A.    CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP Read more

QUESTION 101 You need to implement a solution for the email attachments. Both organizations exchange root CA certificates and install the certificates in the relevant stores. You duplicate the Enrollment Agent certificate template and generate a certificate based on the new template. Which additional two actions should you perform? Each Answer presents part of the Read more

QUESTION 91 Your network contains an Active Directory domain. The domain contains 10 file servers. The file servers connect to a Fibre Channel SAN. You plan to implement 20 Hyper-V hosts in a failover cluster. The Hyper-V hosts will not have host bus adapters (HBAs). You need to recommend a solution for the planned implementation Read more

QUESTION 61 Your network contains an Active Directory forest. The forest contains two domains named contoso.com and fabrikam.com. The forest functional level is Windows 2000. The contoso.com domain contains domain controllers that run either Windows Server 2008 or Windows Server 2008 R2. The domain functional level is Windows Server 2008. The fabrikam.com domain contains domain Read more

QUESTION 51 You have a server named Server1 that runs Windows Server 2012 R2. Server1 has the DNS Server server role installed. You need to configure Server1 to resolve queries for single-label DNS names. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.) A.    Run the Set-DNSServerGlobalNameZone cmdlet. Read more

QUESTION 21 You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by using the following definition:   You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What should you do? A.    Convert all indexes to Column Store Read more

QUESTION 11 You administer a Microsoft SQL Server 2012 database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Which server-level audit action group should you use? A.    SERVER_STATE_CHANGE_GROUP B.    SERVER_PRINCIPAL_IMPERSONATION_GROUP C.    SUCCESSFUL_LOGIN_GROUP D.    SERVER_ROLE_MEMBER_CHANGE_GROUP Answer: D Explanation: http://technet.microsoft.com/en-us/library/cc280663.aspx SERVER_STATE_CHANGE_GROUP This event is Read more

QUESTION 1 You administer a Microsoft SQL Server 2012 database. The database has a table named Customers owned by UserA and another table named Orders owned by UserB. You also have a stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from both tables. You create a new user named UserC. You need to Read more

QUESTION 41 Your network contains a server named Server1 that runs Windows Server 2012 R2. Server1 has the Active Directory Certificate Services server role installed and is configured as a standalone certification authority (CA). You install a second server named Server2. You install the Online Responder role service on Server2. You need to ensure that Read more

QUESTION 31 You have a server named Server1 that runs Windows Server 2012 R2. From Server Manager, you install the Active Directory Certificate Services server role on Server1. A domain administrator named Admin1 logs on to Server1. When Admin1 runs the Certification Authority console, Admin1 receive the following error message.   You need to ensure Read more

QUESTION 91 Hotspot Question Your network contains an Active Directory forest named contoso.com. The forest contains a single domain. All domain controllers run Windows Server 2012 R2 and are configured as DNS servers. All DNS zones are Active Directory-integrated. Active Directory Recycle Bin is enabled. You need to modify the amount of time deleted objects Read more

QUESTION 81 Your network contains an Active Directory domain named adatum.com. The domain contains a domain controller named DC1. On DC1, you create a new volume named E. You restart DC1 in Directory Service Restore Mode. You open ntdsutil.exe and you set NTDS as the active instance. You need to move the Active Directory logs Read more