Easy to learn, you’ll pass the Microsoft Business Intelligence 70-462 exam! Free 70-462 dumps
Pass the Microsoft Business Intelligence 70-462 exam.
“Administering Microsoft SQL Server 2012 Databases”: https://www.leads4pass.com/70-462.html (Total Questions: 321 Q&As). I know you most want to get here for free 70-462 dumps. The latest free 70-462 exam practice questions and 70-462 pdf help you improve your skills and exam experience!
Table of Contents:
- Latest Microsoft Business Intelligence 70-462 pdf
- Test your Microsoft Business Intelligence 70-462 exam level
- Watch the Microsoft Business Intelligence 70-462 video tutorial online
- Related 70-462 Popular Exam resources
- Get Lead4Pass Coupons (12% OFF)
- What are the advantages of Lead4pass?
Latest Microsoft Business Intelligence 70-462 pdf
[PDF] Free Microsoft Business Intelligence 70-462 pdf dumps download from Google Drive: https://drive.google.com/open?id=1vnBLC3YqBrj28vr-Y3IdyGihXoG8QepG
Exam 70-462: Administering Microsoft SQL Server: https://www.microsoft.com/en-us/learning/exam-70-462.aspx
Skills measured
This exam measures your ability to accomplish the technical tasks listed below.
- 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%)
Who should take this exam?
This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.
Test your Microsoft Business Intelligence 70-462 exam level
QUESTION 1
You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities for your organization\\’s SQL
Server 2012 deployment. Which of the following tools would you use to accomplish this goal?
A. SQLIO
B. SQLIOSim
C. SQLIOStress
D. chkdsk
Correct Answer: B
QUESTION 2
You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the
following requirements: Takes an input variable Returns a table of values Cannot be referenced within a view
Which object should you use?
A. Scalar-valued function
B. Inline function
C. User-defined data type
D. Stored procedure
Correct Answer: D
QUESTION 3
You administer a SQL Server 2012 server that contains a database named SalesDb.
SalesDb contains a schema named Customers that has a table named Regions.
A user named UserA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table and the Sales role is granted the Select permission on the
Customers schema.
You need to ensure that the Sales role, including UserA, is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?
A. REVOKE SELECT OK Schema::Customers FROM UserA
B. REVOKE SELECT ON Object::Regions FROM UserA
C. EXEC sp_addrolemember \\’Sales\\’, \\’UserA\\’
D. DENY SELECT ON Schema::Customers FROM Sales
E. EXEC sp_droprolemember \\’Sales\\’, \\’UserA\\’
F. REVOKE SELECT ON Schema::Customers FROM Sales
G. DENY SELECT ON Object::Regions FROM UserA
H. REVOKE SELECT ON Object::Regions FROM Sales
I. DENY SELECT ON Schema::Customers FROM UserA
J. DENY SELECT ON Object::Regions FROM Sales
Correct Answer: J
References: http://msdn.microsoft.com/en-us/library/ms188369.aspx http://msdn.microsoft.com/en-us/library/ms187750.aspx http://msdn.microsoft.com/en-us/library/ff848791.asp
QUESTION 4
You have configured Resource Governor with three resource pools.
You have assigned the first resource pool a minimum CPU and memory value of 20%.
You have assigned the second resource pool a minimum CPU and memory value of 30%.
You want to assign maximum CPU and memory values to the third resource pool.
What is the maximum CPU and memory value you can assign to this resource pool?
A. 30%
B. 50%
C. 70%
D. 100%
Correct Answer: B
The maximum resource value assigned to the third pool is 65%; the sum of the minimum resource values assigned to
the other pools is 50%.
Note: MIN_CPU_PERCENT and MAX_CPU_PERCENT
These settings are the minimum and maximum guaranteed average CPU bandwidth for all requests in the resource pool
when there is CPU contention. You can use these settings to establish predictable CPU resource usage for multiple
workloads that is based on the needs of each workload. For example, assume the Sales and Marketing departments in
a company share the same database. The Sales department has a CPU-intensive workload with high-priority queries.
The Marketing department also has a CPU-intensive workload, but has lower-priority queries. By creating a separate
resource pool for each department, you can assign a minimum CPU percentage of 70 for the Sales resource pool and a
maximum CPU percentage of 30 for the Marketing resource pool. This ensures that the Sales workload receives the
CPU resources it requires and the Marketing workload is isolated from the CPU demands of the Sales workload. Note
that the maximum CPU percentage is an opportunistic maximum. If there is available CPU capacity, the workload uses
it up to 100 percent. The maximum value only applies when there is contention for CPU resources. In this example, if
the Sales workload is switched off, the Marketing workload can use 100 percent of the CPU if needed.
References: https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor-resource-pool
QUESTION 5
DRAG DROP
You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers
named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01.
You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.
You need to prepare the Contoso database for database mirroring.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions
to the answer area and arrange them in the correct order.)
Select and Place:
Correct Answer:
QUESTION 6
You administer a Microsoft SQL Server database server. One of the databases on the server supports a highly active
OLTP application.
Users report abnormally long wait times when they submit data into the application.
You need to identify which queries are taking longer than 1 second to run over an extended period of time.
What should you do?
A. use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of
more than 1,000.
B. Use sp_configure to set a value for blocked process threshold. Create an extended event session.
C. Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the
duration of each step.
D. Run the sp_who command from a query window.
E. Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.
Correct Answer: A
Use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more
than 1,000.
Incorrect:
Not B: The SQL Server lock monitor is responsible for implementing the logic to detect a blocking scenario if the
`blocked process threshold\\’ value is greater than 0. However, the lock monitor only wakes up every 5 seconds to
detect this
condition (it is also looking for other conditions such as deadlocks). Therefore, if you set a `blocked process threshold\\’
value to 1, it will not detect a process that has been blocking for 1 second. The minimum time it can detect a blocked
process is 5 seconds.
Not E: The Traceflag 1222 Shows Deadlocks, not the Duration of an query.
References: https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler
QUESTION 7
You install a Microsoft SQL Server 2012 instance.
The instance will store data extracted from two databases running on Windows Azure SQL Database.
You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the database.
You need to ensure that the data steward is given the correct client tools to perform these tasks.
Which set of tools should you install?
A. SQL Server Management Studio and Distributed Replay Client
B. Master Data Services and Data Quality Client
C. Data Quality Client and Distributed Replay Client
D. Data Quality Client and SQL Server Management Studio
Correct Answer: B
References: https://www.mssqltips.com/sqlservertutorial/3802/sql-server-master-data-services-architecture/
QUESTION 8
You have three tables that contain data for vendors, customers, and agents. You create a view that is used to look up
telephone numbers for these companies.
The view has the following definition: You need to ensure that users can update only the phone numbers by using this
view. What should you do?
A. Alter the view. Use the EXPAND VIEWS query hint along with each SELECT statement.
B. Drop the view. Re-create the view by using the SCHEMABINDING clause, and then create an index on the view.
C. Create an AFTER UPDATE trigger on the view.
D. Create an INSTEAD OF UPDATE trigger on the view.
Correct Answer: D
QUESTION 9
You administer two instances of Microsoft SQL Server. 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. Start the SQL Server Browser Service.
B. Configure the application as data-tiered.
C. Open port 1433 on the Windows firewall on the server.
D. Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.
Correct Answer: A
QUESTION 10
DRAG DROP
You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data.
You need to encrypt the database files at the page level. You also need to encrypt the transaction log files.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to
the answer area and arrange them in the correct order.)
Select and Place:
Correct Answer:
QUESTION 11
DRAG DROP
You have a consolidated SQL Server instance that contains databases for several applications.
You need to limit the maximum degree of parallelism for an application named App1.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to
the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Select and Place:
Correct Answer:
Step 1: Enable Resource Governor
The Resource Governor is turned off by default. You can enable the Resource Governor by using either SQL Server
Management Studio or Transact-SQL.
Step 2: Create a resource pool.
In the SQL Server Resource Governor, a resource pool represents a subset of the physical resources of an instance of
the Database Engine.
Step 3: Create a workload group
In the SQL Server Resource Governor, a workload group serves as a container for session requests that have similar
classification criteria. A workload allows for aggregate monitoring of the sessions, and defines policies for the sessions.
Each workload group is in a resource pool, which represents a subset of the physical resources of an instance of
the Database Engine. When a session is started, the Resource Governor classifier assigns the session to a specific
workload group, and the session must run using the policies assigned to the workload group and the resources defined
for the resource pool.
Step 4: Write a classifier function.
The SQL Server resource governor classification process assigns incoming sessions to a workload group based on the
characteristics of the session. You can tailor the classification logic by writing a user-defined function, called a classifier
function.
Incorrect Answers:
Not: Restart SQL Server
The setting takes effect immediately without restarting the server.
References: https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor
QUESTION 12
This question is part of a series of questions that use the same set of answers choices. An answer choice may be
correct for more than one question in the series.
You administer a Microsoft SQL Server database 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:
One of the hard disk drives that stores the transactional database fails at 23:32 hours. Attempts to create a tail log
backup are unsuccessful.
You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal.
What should you do?
A. Perform a page restore.
B. Perform a partial restore.
C. Perform a point-in-time restore.
D. Restore the latest full backup.
E. Restore the latest full backup. Then, restore the latest differential backup.
F. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
G. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before
the time of failure from the most recent differential backup.
H. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most
recent full backup.
Correct Answer: C
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-sql-server-database-to-a-point-in-time-full-recovery-model?view=sql-server-2017
QUESTION 13
DRAG DROP
You administer two Microsoft SQL Server database servers named ProdSrv1 and ProdSrv2. Each server has a
database named Orders.
You need to configure transactional replication from the OrderSummary table in the Orders database on ProdSrv1 to the
OrderSummary table in the Orders database on ProdSrv2.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to
the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Step 1: Configure ProdSrv1 as a Distributor.
Step 2: Configure ProdSrv1 as a Publisher.
Step 3: Configure a publication of the Order-Summary table on ProdSrv1.
Step 4: Create a subscription of the publication in the Orders database on ProdSrv1.
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/replication/configure-publishing-and-distribution
Watch the Microsoft Business Intelligence 70-462 video tutorial online
We offer more ways to make it easier for everyone to learn, and YouTube is the best tool in the video.
Follow channels: https://www.youtube.com/channel/UCXg-xz6fddo6wo1Or9eHdIQ/videos get more useful exam content.
Related 70-462 Popular Exam resources
| title | youtube | Exam 70-462: Administering Microsoft SQL Server | lead4pass | Lead4Pass Total Questions | |
|---|---|---|---|---|---|
| Microsoft 70-462 | lead4pass 70-462 dumps pdf | lead4pass 70-462 youtube | Exam 70-462: Administering Microsoft SQL Server | https://www.leads4pass.com/70-462.html | 321 Q&A |
| Microsoft Business Intelligence | https://www.leads4pass.com/70-461.html | 412 Q&A | |||
| https://www.leads4pass.com/70-463.html | 295 Q&A | ||||
| https://www.leads4pass.com/70-466.html | 186 Q&A | ||||
| https://www.leads4pass.com/70-467.html | 176 Q&A |
Get Lead4Pass Coupons(12% OFF)
What are the advantages of Lead4pass?
We have a number of Microsoft, Microsoft, IBM, Microsoft, and other exam experts. We update exam data throughout the year.
Top exam pass rate! We have a large user base. We are an industry leader! Choose Lead4Pass to pass the exam with ease!
Summarize:
Free Microsoft Business Intelligence 70-462 exam exercise questions and answers,
70-462 pdf and 70-462 video practice questions. These will help you improve your exam experience. I know you want to easily get 70-462 certification! It’s not hard! Experts recommend https://www.leads4pass.com/70-462.html help you easily get certified.