Your success in Microsoft 70 462 pdf is our sole target and we develop all our 70 462 exam braindumps in a way that facilitates the attainment of this target. Not only is our 70 462 training kit pdf study material the best you can find, it is also the most detailed and the most updated. 70 462 training kit pdf Practice Exams for Microsoft SQL Server 70 462 training kit pdf are written to the highest standards of technical accuracy.

Q11. You use a contained database named ContosoDb within a domain. 

You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. 

Which type of user should you create? 

A. User mapped to a certificate 

B. SQL user without login 

C. Domain user 

D. SQL user with login 

Answer:


Q12. You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. 

You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. 

What should you create? 

A. A Database Audit Specification 

B. A Policy 

C. An Alert 

D. A SQL Profiler Trace 

E. A Resource Pool 

F. An Extended Event session 

G. A Server Audit Specification 

Answer:


Q13. You administer a single server that contains a Microsoft SQL Server 2012 default instance. 

You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions. 

You need to ensure that the application login is unable to access other production databases. 

What should you do? 

A. Use the SQL Server default instance and configure an affinity mask. 

B. Install a new named SQL Server instance on the server. 

C. Use the SQL Server default instance and enable Contained Databases. 

D. Install a new default SQL Server instance on the server. 

Answer:


Q14. You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. 

You discover performance issues when large amounts of data are written to tables under heavy system load. 

You need to limit the number of cores that handle I/O. 

What should you configure? 

A. Processor affinity 

B. Lightweight pooling 

C. Max worker threads 

D. I/O affinity 

Answer:


Q15. You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. 

You discover performance issues when complex calculations are performed on large amounts of data under heavy system load. 

You need to limit the number of cores that handle the processing. 

What should you configure? 

A. Max worker threads 

B. Processor affinity 

C. I/O affinity 

D. Lightweight pooling 

Answer: C


Q16. You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. 

An additional node named Node C has been added to the existing cluster. 

You need to ensure that the SQL Server instance can use all nodes of the cluster. 

What should you do? 

A. Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A. 

B. Use Node A to install SQL Server on Node C. 

C. Run the Add Node to SQL Server Failover Cluster Wizard on Node C. 

D. Use Cluster Administrator to add a new Resource Group to Node B. 

Answer:


Q17. You administer all the deployments of Microsoft SQL Server 2012 in your company. 

A database contains a large product catalog that is updated periodically. 

You need to be able to send the entire product catalog to all branch offices on a monthly basis. 

Which configuration should you use? 

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

B. . SQL Server that includes an application database configured to perform transactional replication 

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

. Two servers configured in a Windows Failover Cluster in the same data center 

. SQL Server configured as a clustered instance 

D. . SQL Server that includes an application database configured to perform snapshot replication 

E. . Two servers configured in different data centers 

. SQL Server Availability Group configured in Synchronous-Commit Availability Mode 

. One server configured as an Active Secondary 

F. . Two servers configured on the same subnet 

. SQL Server Availability Group configured in Synchronous-Commit Availability Mode 

G. . Two servers configured in different data centers 

. SQL Server Availability Group configured in Asynchronous-Commit Availability Mode 

Answer:


Q18. You are a database administrator for a Microsoft SQL Server 2012 database named AdventureWorks2012. 

You create an Availability Group defined by the following schema. (Line numbers are included for reference only.) 

You need to implement an AlwaysOnAvailablity Group that will meet the following conditions: 

Production transactions should be minimally affected. 

The secondary server should allow reporting queries to be performed. 

If the primary server goes offline, the secondary server should not automatically take over. 

Which Transact-SQL statement should you insert at line 06? 

A. AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, 

FAILOVER_MODE = MANUAL 

SECONDARY_ROLE ( 

ALLOW_CONNECTIONS = READ_ONLY, 

READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433') 

PRIMARY_ROLE ( 

ALLOW_CONNECTIONS = READ_WRITE, 

READ_ONLY_ROUTING_LIST = NONE) 

B. AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, 

FAILOVER_MODE = MANUAL 

SECONDARY_ROLE ( 

ALLOW_CONNECTIONS = READ_ONLY, 

READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433') 

C. AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, 

FAILOVER_MODE = MANUAL 

SECONDARY_ROLE ( 

ALLOW_CONNECTIONS = READ_ONLY, 

READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433') 

D. AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, 

FAILOVER_MODE = MANUAL 

SECONDARY_ROLE ( 

ALLOW_CONNECTIONS = YES, 

READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433') 

Answer:


Q19. You administer a Microsoft SQL Server 2012 database. 

You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated permissions. 

You need to ensure that the job step can run using a different user account. 

What should you use? 

A. A notification 

B. A schedule 

C. A job category 

D. A proxy 

Answer:


Q20. You develop a Microsoft SQL Server 2012 database that contains tables named Employee and Person. The tables have the following definitions: 

Users are able to use single INSERT statements or INSERT...SELECT statements into this view. You need to ensure that users are able to use a single statement to insert records into both Employee and Person tables by using the VwEmployee view. 

Which Transact-SQL statement should you use? 

A. CREATE TRIGGER TrgVwEmployee ON VwEmployee FOR INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName, FROM inserted INSERT INTO Employee(PersonId, EmployeeNumber) SELECT Id, EmployeeNumber FROM inserted END 

B. CREATE TRIGGER TrgVwEmployee ON VwEmployee INSTEAD OF INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName, FROM inserted INSERT INTO Employee(PersonId, EmployeeNumber) SELECT Id, EmployeeNumber FROM inserted END 

C. CREATE TRIGGER TrgVwEmployee ON VwEmployee 

INSTEAD OF INSERT 

AS 

BEGIN 

DECLARE @ID INT, @FirstName NVARCHAR(25), @LastName NVARCHAR(25), 

@PersonID INT, 

@EmployeeNumber NVARCHAR(15) 

SELECT @ID = ID, @FirstName = FirstName, @LastName = LastName, 

@EmployeeNumber = 

EmployeeNumber 

FROM inserted 

INSERT INTO Person(Id, FirstName, LastName) 

VALUES(@ID, @FirstName, @LastName) 

INSERT INTO Employee(PersonID, EmployeeNumber) 

VALUES(@PersonID, @EmployeeNumber 

End 

D. CREATE TRIGGER TrgVwEmployee ON VwEmployee INSTEAD OF INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName FROM VwEmployee INSERT INTO Employee(PersonID, EmployeeNumber) SELECT Id, EmployeeNumber FROM VwEmployee End 

Answer: B