Latest MCSE 70-462 Real Exam Download 11-20

Ensurepass

QUESTION 11

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 12

You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured.

 

When SQL Server Agent jobs fail, the error messages returned by the job steps do not provide the required detail.

 

The following error message is an example error message:

"The job failed. The Job was invoked by User CONTOSO\ServiceAccount. The last step to run was step 1 (Subplan_1)."

 

You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained. What should you do?

A. Configure output files.

B. Expand agent logging to include information from all events.
C. Disable the Limit size of job history log feature.

D. Configure event forwarding.

 

Correct Answer: B

 

 

QUESTION 13

You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support

FILETABLES. What should you do? Choose all that apply.

 

A. Disable FILESTREAM on the Database.

B. Enable FILESTREAM on the Server Instance.

C. Configure the Database for Partial Containment.
D. Create a non-empty FILESTREAM file group.

E. Enable Contained Databases on the Server Instance.

F. Set the FILESTREAM directory name on the Database.

 

Correct Answer: BDF

 

 

QUESTION 14

You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?

 

A. Configure the application as data-tiered.

B. Open port 1433 on the Windows firewall on the server.

C. Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.

D. Start the SQL Server Browser Service.

 

Correct Answer: D

 

 

QUESTION 15

You administer a Microsoft SQL Server 2012 database. You configure Transparent Data Encryption (TDE)

on the Orders database by using the following statements:


CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘MyPassword1!’

CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = ‘TDE Certificate’;

 

BACKUP CERTIFICATE TDE_Certificate TO FILE = ”d:\TDE_Certificate.cer’

WITH PRIVATE KEY (FILE = ‘D:\TDE_Certificate.key’, ENCRYPTION BY PASSWORD =

‘MyPassword1!’);

 

CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256

ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate; ALTER DATABASE Orders SET ENCRYPTION ON;

 

You attempt to restore the Orders database and the restore fails. You copy the encryption file to the original location. A hardware failure occurs and so a new server must be installed and configured. After installing SQL Server to the new server, you restore the Orders database and copy the encryption files to their original location. However, you are unable to access the database. You need to be able to restore the database. Which Transact-SQL statement should you use before attempting the restore?

 

A. ALTER DATABASE Master SET ENCRYPTION OFF;

B. CREATE CERTIFICATE TDE_Certificate FROM FILE = ‘d:\TDE_Certificate.cer’

WITH PRIVATE KEY (FILE = ‘D:\TDE_Certificate.key’, DECRYPTION BY PASSWORD =

‘MyPassword1!’);

C. CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = ‘TDE Certificate’; USE Orders;

CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256

ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate;

D. CREATE CERTIFICATE TDE_Certificate FROM FILE = ‘d:\TDE_Certificate.cer’;

 

Correct Answer: B

 

 

QUESTION 16

You administer a single server that contains a Microsoft SQL Server 2012 default instance on which several production databases have been deployed.

 

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

You need to ensure that the login for the ticketing application cannot access other production databases. What should you do?

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

B. Use the SQL Server default instance and configure a user-defined server role. Add the login for the ticketing application to this role.

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

 

Correct Answer: C

 

 

QUESTION 17

You administer a Microsoft SQL Server 2012 database.

 

The database contains a customer table created by using the following definition:


 

clip_image001

 

You need to ensure that the minimum amount of disk space is used to store the data in the customer table.

 

What should you do?

 

A. Implement row-level compression.
B. Implement page-level compression.

C. Convert all indexes to Column Store indexes.
D. Implement Unicode compression.

 

Correct Answer: B

 

 

QUESTION 18

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 19

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 20

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_image002

 

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

Download Latest 70-462 Real Free Tests , help you to pass exam 100%.

 

Leave a Reply

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