Pass Guarantee 70-462 Exam By Taking CertBus New Microsoft 70-462 VCE And PDF Braindumps
Which certification is the most popular and worthy to get? No doubt the 70-462 Administering Microsoft SQL Server 2012 Databases exam is a worth challenging task but you should take among all the IT certifications . CertBus is providing the latest version of 70-462 PDF and VCE dumps now. Comprehensive understanding on 70-462 Administering Microsoft SQL Server 2012 Databases exam syllabus through CertBus 100% pass guarantee of the success on your 70-462 Administering Microsoft SQL Server 2012 Databases exam taking.
We CertBus has our own expert team. They selected and published the latest 70-462 preparation materials from Microsoft Official Exam-Center: http://www.certgod.com/70-462.html
QUESTION NO:22
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
Answer: K
Explanation:
According to these references, this answer looks correct.
References:
http://technet.microsoft.com/en-us/library/ms187103.aspx
http://msdn.microsoft.com/en-us/library/ms191233.aspx
http://msdn.microsoft.com/en-us/library/ms178117.aspx
QUESTION NO:43
You administer a Microsoft SQL Server 2012 database. You need to ensure that the size of
the transaction log file does not exceed 2 GB. What should you do?
A. Execute sp_configure ‘max log size’, 2G.
B. use the ALTER DATABASE…SET LOGFILE command along with the maxsize
parameter.
C. In SQL Server Management Studio, right-click the instance and select Database Settings.
Set the maximum size of the file for the transaction log.
D. In SQL Server Management Studio, right-click the database, select Properties, and then
click Files. Open the Transaction log Autogrowth window and set the maximum size of the
file.
Answer: D
Reference:
Verified answer as correct.
QUESTION NO: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.
Answer: C
QUESTION NO: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 CONTOSOServiceAccount. 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.
Answer: B
Reference:
http://msdn.microsoft.com/en-us/library/ms175488.aspx
QUESTION NO: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.
Answer: A
Reference:
http://msdn.microsoft.com/en-us/library/ms189635.aspx
QUESTION NO:55
You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that
has the following definition:
You need to create a non-clustered index on the SalesOrderID column in the OrderDetail
table to include only rows that contain a value in the CarrierTrackingNumber column.
Which four Transact- SQL statements should you use? (To answer, move the appropriate
statements from the list of statements to the answer area and arrange them in the correct
order.)
Build List and Reorder:
Answer:
Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms188783.aspx
http://msdn.microsoft.com/en-us/library/ms189280.aspx
QUESTION NO: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’;
Answer: B
QUESTION NO: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.
Answer: D
QUESTION NO:10
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.
Answer: B
Reference:
http://msdn.microsoft.com/en-us/library/jj542414.aspx
QUESTION NO:44
You administer a Microsoft SQL Server 2012 server.
The MSSQLSERVER service uses a domain account named CONTOSOSQLService.
You plan to configure Instant File Initialization.
You need to ensure that Data File Autogrow operations use Instant File Initialization.
What should you do? Choose all that apply.
A. Restart the SQL Server Agent Service.
B. Disable snapshot isolation.
C. Restart the SQL Server Service.
D. Add the CONTOSOSQLService account to the Perform Volume Maintenance Tasks
local security policy.
E. Add the CONTOSOSQLService account to the Server Operators fixed server role.
F. Enable snapshot isolation.
Answer: C, D
Reference:
http://msdn.microsoft.com/en-us/library/ms175935.aspx
http://www.mssqltips.com/sqlservertip/2752/effect-of-instant-file-initialization-within-sqlserver/
How To Enable Instant File Initialization
1. Open Local Security Policy and go to Local Policies –> User Rights Assignment.
2. Double click Perform Volume Maintenance Tasks and add your SQL Server database
engine service account.
3. Restart the SQL Server service using SQL Server Configuration Manager and this setting
should now be enabled.
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 70-462 exam successfully with our Microsoft materials. CertBus Administering Microsoft SQL Server 2012 Databases exam PDF and VCE are the latest and most accurate. We have the best Microsoft in our team to make sure CertBus Administering Microsoft SQL Server 2012 Databases exam questions and answers are the most valid. CertBus exam Administering Microsoft SQL Server 2012 Databases exam dumps will help you to be the Microsoft specialist, clear your 70-462 exam and get the final success.
70-462 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mVGc4ZGNCeV9zUWM/view?usp=sharing
70-462 Microsoft exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/70-462.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.