Latest Microsoft Business Intelligence 70-462 dumps, 70-462 PDF | Free Exam Practice Test
Share real and effective Microsoft Business Intelligence 70-462 exam dumps for free. 13 Online 70-462 Exam Practice test questions and answers, online 70-462 pdf download and YouTube video learning, easy to learn! Get the full 70-462 Dumps: https://www.leads4pass.com/70-462.html (Total Questions: 298 Q&A) to make it easy to pass the exam!
[PDF] Free Microsoft Business Intelligence 70-462 pdf dumps download from Google Drive: https://drive.google.com/open?id=1vnBLC3YqBrj28vr-Y3IdyGihXoG8QepG
[PDF] Free Full Microsoft pdf dumps download from Google Drive: https://drive.google.com/open?id=1AwBFPqkvdpJBfxdZ3nGjtkHQZYdBsRVz
Exam 70-462: Administering Microsoft SQL Server 2012/2014 Databases: https://www.microsoft.com/en-us/learning/exam-70-462.aspx
Skills measured
- Install and configure (20–25%)
- Maintain instances and databases (15–20%)
- Optimize and troubleshoot (15–20%)
- Manage data (20–25%)
- Implement security (15–20%)
- Implement high availability (5–10%)
Microsoft Certification Exam List | Microsoft Learning: https://www.microsoft.com/en-us/learning/exam-list.aspx
Pass the Microsoft Exam checklist: https://www.leads4pass.com/microsoft.html
Latest effective Microsoft Business Intelligence 70-462 Exam Practice Tests
QUESTION 1
You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data
changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the
primary
server is unaffected.
Which configuration should you use?
A.
SQL Server that includes an application database configured to perform transactional replication
B.
Two servers configured in different data centers
SQL Server Availability Group configured in Asynchronous-Commit Availability Mode
C.
Two servers configured in different data centers
SQL Server Availability Group configured in Synchronous-Commit Availability Mode
One server configured as an Active Secondary
D.
SQL Server that includes an application database configured to perform snapshot replication
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 on the same subnet
SQL Server Availability Group configured in Synchronous-Commit Availability Mode
G.
Two servers configured in a Windows Failover Cluster in the same data center
SQL Server configured as a clustered instance
H.
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
Correct Answer: A
Reference:
http://msdn.microsoft.com/en -us/library/ms151149.aspx
QUESTION 2
What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?
A. 512 MB
B. 1 GB
C. 2 GB
D. 4 GB
Correct Answer: B
QUESTION 3
You are a database administrator for a Microsoft SQL Server 2012 environment. You want to deploy a new application
that will scale out the workload to at least five different SQL Server instances. You need to ensure that for each copy of
the
database, users are able to read and write data that will then be synchronized between all of the database instances.
Which feature should you use?
A. Database Mirroring
B. Peer-to-Peer Replication
C. Log Shipping
D. AvailabilityGroups
Correct Answer: B
QUESTION 4
Which feature should you enable and configure so session requests addressed to a specific instance can be allocated
different processor resources based on session request properties?
A. Resource Governor
B. Windows System Resource Manager
C. Processor affinity
D. I/O affinity
Correct Answer: C
QUESTION 5
You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The
transactional database is updated through a web application and is operational throughout the day. The reporting
database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:
The differential backup of the reporting database fails. Then, the reporting database fails at 14:00 hours. You need to
ensure that the reporting database is restored. You also need to ensure that data loss is minimal. What should you do?
A. Restorethelatestfullbackup, andrestorethelatestdifferentialbackup.Then, restorethelatestlogbackup.
B. Perform a point-in-time restore.
C. Restore the latest full backup.
D. Restorethe latestfullbackup, andrestore thelatestdifferential backup.Then, restoreeachlog backuptaken before the
time of failure from the most recent differential backup.
E. Restore the latest full backup. Then, restore the latest differential backup.
F. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most
recentfull backup.
G. Perform a page restore.
H. Perform a partial restore.
Correct Answer: C
QUESTION 6
Before moving an SQL Server 2012 database file to a new location, which of the following must first be accomplished?
A. The database must be set to OFFLINE.
B. The SQL Server Service must be stopped.
C. The database must be deleted.
D. The database must have the shrink” operation run.
Correct Answer: A
https://msdn.microsoft.com/en -us/library/ms345483%28v=sql.110%29.aspx
QUESTION 7
Which of the following is a disaster recovery solution offered in SQL Server 2012 and involves maintaining a standby
copy of a primary database?
A. AlwaysOn
B. Log Shipping
C. Clustering
D. DataGuard
Correct Answer: A
QUESTION 8
Which of the following is a valid upgrade path for SQL Server 2012?
A. SQL Server 2000 -> SQL Server 2012
B. SQL Server 2000 -> SQL Server 2005 -> SQL Server 2012
C. SQL Server 7 -> SQL Server 2012
D. Oracle 11g -> SQL Server 2012
Correct Answer: B
https://technet.microsoft.com/en-us/library/ms143393%28v=sql.110%29.aspx https://technet.microsoft.com/en-
us/library/ms143393%28v=sql.90%29.aspx
QUESTION 9
You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database
begins to run slowly.
You discover that a large amount of memory is consumed by single-use dynamic queries. You need to reduce
procedure cache usage from these statements without creating any additional indexes.
What should you do?
A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. AddaFORCESEEKhinttothequery.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. IncludeaSETSTATISTICSPROFILE ONstatementbeforeyou runthequery.
K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.
Correct Answer: G
Reference: http://msdn.microsoft.com/en -us/library/cc645587.aspx
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
When replication is configured, a set of agent profiles is installed on the Distributor. An agent profile contains a set of
parameters that are used each time an agent runs: each agent logs in to the Distributor during its startup process and
queries for the parameters in its profile. For merge subscriptions that use Web synchronization, profiles are downloaded
and stored at the Subscriber. If the profile is changed, the profile at the Subscriber is updated the next time the Merge
Agent runs. For more information about Web synchronization, see Web Synchronization for Merge Replication.