Latest Real 70-462 Tests Dumps and VCE Exam Questions 1-10

Ensurepass

QUESTION 1

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/Server02 to Asynchronous commit.

B.      Set the Readable Secondary property of HA/Server02 to Read-intent only.

C.      Set the Connections in Primary Role property of HA/Server01 to Allow read/write

connections.

D.      Set the Availability Mode property of HA/Server01 to Asynchronous commit.

 

Correct Answer: B

 

 

QUESTION 2

You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain. You plan to configure database mirroring. You need to be able to create database mirroring endpoints on both servers. What should you do?

 

A.      Configure the SQL Server service account to use Network Service.

B.      Use a server certificate.

C.      Use a database certificate.

D.      Configure the SQL Server service account to use Local System.

 

Correct Answer: B

 

 

QUESTION 3

You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages. You create a user account in the msdb database for the AgentPortalUser login. You use the Database Mail Configuration Wizard to create a Database Mail profile. Security has not been configured for the Database Mail profile. You need to ensure that AgentPortalUser can send email messages. What should you do?

 

A.      In the Database Mail Configuration Wizard, configure the Database Mail profile as a private profile for the AgentPortalUser account.

B.      Disable the guest user in the msdb database.

C.      Use the sysmail_help_profileaccount_sp stored procedure to add accounts to the Database Mail profile.

D.      In the Database Mail Configuration Wizard, create an email account for each recipient’s email address in the Database Mail profile.

 

Correct Answer: A

 

 

QUESTION 4

You administer a Microsoft SQL Server 2012 default instance. The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections. What should you do? Choose all that apply.

 

A.      Enable inbound connections on TCP port 1434 in the Windows Firewall on the server.

B.      Execute the following Transact-SQL command: sp_configure ‘remote admin connections’,

C.      Execute the Reconfigure command.

D.      Execute the following Transact-SQL command: sp_configure ‘remote access’, 1

E.       Restart the SQL Server Agent Service.

F.       Enable inbound connections on TCP port 135 in the Windows Firewall on the server.

 

Correct Answer: ABC

 

 

QUESTION 5

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table:

 

clip_image001

 

You discover that Sales_2.ndf is corrupt. You need to recover the corrupted data in the minimum amount of time. What should you do?

 

A.      Perform a file restore.

B.      Perform a transaction log restore.

C.      Perform a restore from a full backup.

D.      Perform a filegroup restore.

 

Correct Answer: A

 

 

QUESTION 6

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics:

 

Ÿ   A data file of 2 terabytes is located on a dedicated LUN (drive D).

Ÿ   A transaction log of 10 GB is located on a dedicated LUN (drive E).

Ÿ   Drive D has 1 terabyte of free disk space.

Ÿ   Drive E has 5 GB of free disk space.

 

The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day. The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database. These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. You implement log shipping of the financial database to another SQL Server 2012 instance. You decide to failover to this secondary database. You need to ensure that all transactions will be replicated to the secondary database. Which backup option should you use?

 

A.      Differential

B.      Transaction Log

C.      FULL

D.      SIMPLE

E.       SKIP

F.       RESTART

G.      STANDBY

H.      CHECKSUM

I.        DBO_ONLY

J.        COPY_ONLY

K.       NORECOVERY

L.       NO_CHECKSUM

M.    CONTINUE_AFTER_ERROR

N.      BULK_LOGGED

 

Correct Answer: K

 

 

QUESTION 7

You administer a Microsoft SQL Server 2012 database that has Trustworthy set to On. You create a stored procedure that returns database-level information from Dynamic Management Views. You grant User1 access to execute the stored procedure. You need to ensure that the stored procedure returns the required information when User1 executes the stored procedure. You need to achieve this goal by granting the minimum permissions required. What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

 

A.      Create a SQL Server login that has VIEW SERVER STATE permissions.

Create an application role and a secured password for the role.

B.      Modify the stored procedure to include the EXECUTE AS OWNER statement.

Grant VIEW SERVER STATE permissions to the owner of the stored procedure.

C.      Create a SQL Server login that has VIEW SERVER STATE permissions.

Modify the stored procedure to include the EXECUTE AS {newlogin} statement.

D.      Grant the db_owner role on the database to User1.

E.       Grant the sysadmin role on the database to User1.

 

Correct Answer: BC

 

 

QUESTION 8

You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database. You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs. You also need to maintain transactional consistency of the data across both servers. You need to achieve these goals without manual intervention. Which configuration should you use?

 

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

SQL Server configured as a clustered instance

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

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

D.        Two servers configured in different data centers

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

One server configured as an Active Secondary

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

F.         Two servers configured in different data centers

SQL Server Availability Group configured in Asynchronous-Commit Availability Mode

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

H.        Two servers configured on the same subnet

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

 

Correct Answer: H

 

 

 

QUESTION 9

You administer a Microsoft SQL Server 2012 database. You create an availability group named haContosoDbs. Your primary replica is available at Server01Contoso01. You need to configure the availability group to have the highest availability. You also need to ensure that no data is lost. Which Transact-SQL statement should you use?

 

A.        ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON ‘Server01Contoso01’

WITH (AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = AUTOMATIC)

 

B.        ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON ‘Server01Contoso01’

WITH (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL)

 

C.        ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON ‘Server01Contoso01’

WITH (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = AUTOMATIC)

 

D.        ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON ‘Server01Contoso01’

WITH (AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL)

 

Correct Answer: C

 

 

QUESTION 10

You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of the tables involved in replication use the XML and varchar(max) data types. Occasionally, merge replication fails due to timeout errors. You need to reduce the occurrence of these timeout errors. What should you do?

 

A.      Set the Merge agent on the problem subscribers to use the slow link agent profile.

B.      Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.

C.      Change the Merge agent on the problem subscribers to run continuously.

D.      Set the Remote Connection Timeout on the Publisher to 0.

 

Correct Answer: A

 

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.