2016/10 Latest Microsoft 70-462: Administering Microsoft SQL Server 2012/2014 Databases Exam Questions Updated Today!
Free Instant Download 70-462 Exam Dumps (PDF & VCE) 243Q&As from Braindump2go.com Today!

100% Real Exam Questions! 100% Exam Pass Guaranteed!

1.|2016/10 New 70-462 Exam Dumps (PDF & VCE) 243Q&As Download:

http://www.braindump2go.com/70-462.html

2.|2016/10 New 70-462 Exam Questions & Answers:
https://drive.google.com/folderview?id=0B9YP8B9sF_gNaXlZT0hSNGFwWTQ&usp=sharing

QUESTION 56
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?

A.    REVOKE SELECT ON Schema::Customers FROM UserA
B.    DENY SELECT ON Object::Regions FROM UserA
C.    EXEC sp_addrolemember ‘Sales’, ‘UserA’
D.    DENY SELECT ON Object::Regions FROM Sales
E.    REVOKE SELECT ON Object::Regions FROM UserA
F.    DENY SELECT ON Schema::Customers FROM Sales
G.    DENY SELECT ON Schema::Customers FROM UserA
H.    EXEC sp_droproleraember ‘Sales’, ‘UserA’
I.    REVOKE SELECT ON Object::Regions FROM Sales
J.    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

QUESTION 57
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 UserA is disallowed to select from any of the tables in the Customers schema.
Which Transact-SQL statement should you use?

A.    DENY SELECT ON Object::Regions FROM UserA
B.    DENY SELECT ON Object::Regions FROM Sales
C.    REVOKE SELECT ON Schema::Customers FROM Sales
D.    REVOKE SELECT ON Schema::Customers FROM UserA
E.    REVOKE SELECT ON Object::Regions FROM Sales
F.    REVOKE SELECT ON Object::Regions FROM UserA
G.    DENY SELECT ON Schema::Customers FROM Sales
H.    DENY SELECT ON Schema::Customers FROM UserA
I.    EXEC sp_addrolemember ‘Sales’, ‘UserA’
J.    EXEC sp droprolemember ‘Sales’, ‘UserA’

Answer: H
Explanation:
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

QUESTION 58
You administer a SQL 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 remove the Select permission for UserA on the Regions table.
You also need to ensure that UserA can still access all the tables in the Customers schema, including the Regions table, through the Sales role permissions.
Which Transact-SQL statement should you use?

A.    DENY SELECT ON Object::Regions FROM UserA
B.    DENY SELECT ON Schema::Customers FROM UserA
C.    EXEC sp_addrolemember ‘Sales’, ‘UserA’
D.    REVOKE SELECT ON Object:: Regions FROM UserA
E.    REVOKE SELECT ON Object::Regions FROM Sales
F.    EXEC sp_droproiemember ‘Sales’, ‘DserA’
G.    REVOKE SELECT ON Schema::Customers FROM UserA
H.    DENY SELECT ON Object::Regions FROM Sales
I.    DENY SELECT ON Schema:: Customers FROM Sales
J.    REVOKE SELECT ON Schema:: Customers FROM Sales

Answer: D
Explanation:
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

QUESTION 59
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

Answer: J
Explanation:
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

QUESTION 60
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 61
You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B.
A single instance of SQL Server is installed on the cluster.
An additional node named Node C has been added to the existing cluster.
You need to ensure that the SQL Server instance can use all nodes of the cluster.
What should you do?

A.    Create a ConfigurationFile.ini file from Node B, and then run the AddNode
command-line tool on Node A.
B.    Use Node A to install SQL Server on Node C.
C.    Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
D.    Use Cluster Administrator to add a new Resource Group to Node B.

Answer: C

QUESTION 62
You administer a Microsoft SQL Server 2012 database.
The database contains a customer table created by using the following definition:
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.

Answer: B


!!!RECOMMEND!!!

1.|2016/10 New 70-462 Exam Dumps (PDF & VCE) 243Q&As Download:

http://www.braindump2go.com/70-462.html

2.|2016/10 New 70-462 Exam Questions & Answers:
https://drive.google.com/folderview?id=0B9YP8B9sF_gNaXlZT0hSNGFwWTQ&usp=sharing