Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Mar VMware Official New Released VCPN610
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/VCPN610.html
Administering Microsoft SQL Server 2012 Databases
Question No: 121 – (Topic 2)
You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Microsoft SQL Server 2012. All databases are hosted on a SAN (Storage Area Network).
You need to design a database solution for a new application.
You are tasked with designing a high-availability database solution.
The solution must include a single copy of the database to save disk space and the database must remain online in the event of a SQL Server failure. What should you include in your solution?
-
You should include two servers configured as a failover cluster.
-
You should include two servers and database mirroring.
-
You should include two servers and log shipping.
-
You should include two servers configure as a SQL Server Availability Group
Answer: A
Question No: 122 – (Topic 2)
You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders.
Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is heavily
fragmenteD.
You need to improve the performance of the IX_OrderDate index. The index should remain online during the operation.
Which Transact-SQL command should you use?
-
ALTER INDEX IX_OrderDateON CustomerOrderDISABLE
-
ALTER INDEX IX_OrderDateON CustomerOrderENABLE
-
ALTER INDEX IX_OrderDateON CustomerOrderREORGANIZE
-
ALTER INDEX IX OrderDateON CustomerOrderREBUILD
Answer: C
Question No: 123 – (Topic 2)
You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?
-
SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60
-
DBCC INPUTBUFFER (60)
-
EXEC sp_helpdb 60
-
SELECT * FROM sys.dm_exec_request WHERE session_id = 60
Answer: D
Question No: 124 – (Topic 2)
You administer a Microsoft SQL Server 2012 environment. One of the SQL Server 2012
instances contains a database named Sales.
You plan to migrate Sales to Windows Azure SQL Database. To do so, you need to implement a contained database.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
-
Set database containment to AZURE.
-
Enable server property contained database authentication.
-
Disable server property cross db ownership chaining.
-
Set database containment to PARTIAL.
-
Disable server property contained database authentication.
-
Set database containment to FULL.
Answer: B,D
Question No: 125 – (Topic 2)
You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?
-
EXEC sp_who 60
-
SELECT * FROM sys.dm_exec_sessions WHERE sessionid = 60
-
EXEC sp_helpdb 60
-
DBCC INPUTBUFFER (60)
Answer: A Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms174313.aspx http://msdn.microsoft.com/en-us/library/ms176013.aspx http://msdn.microsoft.com/en-us/library/ms178568.aspx http://msdn.microsoft.com/en-us/library/ms187730.aspx
Question No: 126 – (Topic 2)
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?
-
SQLIO
-
SQLIOSim
-
SQLIOStress
-
chkdsk
Answer: B
Question No: 127 DRAG DROP – (Topic 2)
You administer a database named SalesDb that has users named UserA, UserB, and UserC.
You need to ensure that the following requirements are met:
-
UserA must be able to provide Windows login access to the database.
-
UserB must be able to select, update, delete and insert data to the database tables.
-
UserC must be able to create new tables and stores procedures
You need to achieve this goal by granting only the minimum permissions required.
To which fixed database role or roles should you add the users?
Answer:
Question No: 128 – (Topic 2)
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. 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 any of the tables in the Customers schema.
Which Transact-SQL statement should you use?
-
REVOKE SELECT ON Schema::Customers FROM UserA
-
DENY SELECT ON Object::Regions FROM UserA
-
EXEC sp_addrolemember #39;Sales#39;, #39;UserA#39;
-
DENY SELECT ON Object::Regions FROM Sales
-
REVOKE SELECT ON Object::Regions FROM UserA
-
DENY SELECT ON Schema::Customers FROM Sales
-
DENY SELECT ON Schema::Customers FROM UserA
-
EXEC sp_droprolemember #39;Sales#39;, #39;UserA#39;
-
REVOKE SELECT ON Object::Regions FROM Sales
-
REVOKE SELECT ON Schema::Customers FROM Sales
Answer: F Explanation: 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.aspx http://msdn.microsoft.com/en-us/library/ms187728.aspx
Question No: 129 – (Topic 2)
You want to reproduce the same SQL Server 2012 installation configuration across five servers.
Which of the following files will you generate by using SQL Server Setup to accomplish this goal?
-
Configuration.xml
-
Setup.ini
-
Setup.xml
-
ConfigurationFile.ini
Answer: D
Question No: 130 – (Topic 2)
Which of the following is NOT a database role that you can assign users in SQL Server 2012?
-
db_ddladmin
-
db_owner
-
db_datawriter
-
db_databaseadmin
Answer: D
Explanation: References:
https://msdn.microsoft.com/en-us/library/ms189121(v=sql.110).aspx
100% Dumps4cert Free Download!
–Download Free Demo:VCPN610 Demo PDF
100% Dumps4cert Free Guaranteed!
–VCPN610 Dumps
Dumps4cert | ExamCollection | Testking | |
---|---|---|---|
Lowest Price Guarantee | Yes | No | No |
Up-to-Dated | Yes | No | No |
Real Questions | Yes | No | No |
Explanation | Yes | No | No |
PDF VCE | Yes | No | No |
Free VCE Simulator | Yes | No | No |
Instant Download | Yes | No | No |
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF