Month: October 2014

QUESTION 51Drag and Drop QuestionYou 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...

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...

QUESTION 31You 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 EXISTINGB.   ...

QUESTION 21Hotspot QuestionsYour company has a private cloud that contains a System Center 2012 Orchestrator infrastructure. You are creating a runbook named runbook1. You need to ensure that the workflow starts when a file is added to a folder. From which category should you add an activity? To answer, select the appropriate category in the...

QUESTION 11Your company has a private cloud that is managed by using a System Center 2012 infrastructure. You plan to deploy a single-tier service to the private cloud. The service is configured to use Network Load Balancing (NLB). You need to create a Hardware Profile for the virtual machines that will be added to the...

QUESTION 1Your company has a private cloud that contains two Active Directory forests named contoso.com and adatum.com. The contoso.com network and the adatum.com network are separated by a firewall.No trusts exist between the forests.You deploy System Center 2012 Operations Manager to adatum.com.You install agents on 100 servers in both forests.You need to ensure that you...

QUESTION 101You 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 solution. A.    Request cross-certification...

QUESTION 91Your 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 that meets...

QUESTION 61Your 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 controllers...

QUESTION 51You 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.B.    Modify...

QUESTION 21You 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 indexes.B.    Implement Unicode...

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...

QUESTION 1You 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 ensure...

QUESTION 41Your 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 Server1...

QUESTION 31You have a server named Server1 that runs Windows Server 2012 R2.From Server Manager, you install the Active Directory Certificate Services server role onServer1.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 that when Admin1 opens the Certification Authority...

QUESTION 91Hotspot QuestionYour 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 are retained in...

QUESTION 81Your 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 to...

QUESTION 71 Your network contains an Active Directory domain named contoso.com. All domain controllers run Windows Server 2012 R2. You pre-create a read-only domain controller (P.QDC) account named RODC1. You export the settings of RODC1 to a file named File1.txt. You need to promote RODC1 by using File1.txt. Which tool should you use? A.    The...

QUESTION 81You are evaluating the deployment of a multi-site Hyper-V failover cluster in the Miami office and the Seattle office to host App2. You need to identify which changes must be made to support the use of the multi-site cluster. Which changes should you identify? A.    Purchase a storage solution that replicates the virtual machines....

QUESTION 71Your network contains two servers named Server1 and Server2 that run Windows Server 2012. Server1 and Server2 are connected to a Fibre Channel Storage Area Network (SAN). Server1 and Server2 are members of a failover cluster named Cluster1. You plan to host the clustered File Server role on the nodes in Cluster1. Cluster1 will...