Lead2pass give latest exam questions for 70-457 lab certification and because of that, all of our candidates pass 70-457 certification without any problem. The biggest feature is the regular update of these latest exam questions, which keeps our candidates’ knowledge up to date and ensures their success.

QUESTION 151
You administer a Microsoft SQL Server 2012 database.
You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements:

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.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: B

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

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

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

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

QUESTION 156
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 157
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 158
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
Explanation:
Http://msdn.microsoft.com/en-us/library/ms189635.aspx

QUESTION 159
Drag and Drop Question
You administer a Microsoft SQL Server 2012 database.
You need to convert the database to a contained database.
You also need to ensure that all users are converted to contained users.
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.)

Answer:

QUESTION 160
You administer a Microsoft SQL Server 2012 default instance.
The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server.
You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections.
What should you do? Choose all that apply.

A.    Enable inbound connections on TCP port 1434 in the Windows Firewall on the server.
B.    Execute the following Transact-SQL command:sp_configure ‘remote admin connections’,
C.    Execute the Reconfigure command.
D.    Execute the following Transact-SQL command:sp_configure ‘remote access’, 1
E.    Restart the SQL Server Agent Service.
F.    Enable inbound connections on TCP port 135 in the Windows Firewall on the server.

Answer: ABC
Explanation:
http://msdn.microsoft.com/en-us/library/ms191464.aspx
http://msdn.microsoft.com/en-us/library/ms190468.aspx

If you want to get more 70-457 exam preparation material,you can download the free demos in PDF files on Lead2pass.It would be great help for you exam.Wish you pass the exam successfully.

www.lead2pass.com/70-457.html