This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Fri Apr 26 12:03:51 2024 / +0000 GMT ___________________________________________________ Title: [2015 100% PASS] Try Braindump2go Latest Microsoft 70-462 Dumps Questions And 100% Pass Exam Microsoft At The First Try (51-60) --------------------------------------------------- Braindump2go New Published Microsoft 70-462 Dumps PDF Contanins the latest questions from Microsoft Exam Center! 100% Certification got guaranteed!Vendor: MicrosoftExam Code: 70-462Exam Name: Administering Microsoft SQL Server 2012 Databases Exam QUESTION 51Drag and Drop QuestionYou administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database. When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS package. 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.) Answer: QUESTION 52You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply. A.    Disable FILESTREAM on the Database.B.    Enable FILESTREAM on the Server Instance.C.    Configure the Database for Partial Containment.D.    Create a non-empty FILESTREAM file group.E.    Enable Contained Databases on the Server Instance.F.    Set the FILESTREAM directory name on the Database. Answer: BDFExplanation: http://msdn.microsoft.com/en-us/library/gg509097.aspx QUESTION 53You administer two instances of Microsoft SQL Server 2012. 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.    Configure the application as data-tiered.B.    Open port 1433 on the Windows firewall on the server.C.    Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.D.    Start the SQL Server Browser Service. Answer: D QUESTION 54You administer a Microsoft SQL Server 2012 database. You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements:- CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MyPassword1!'- CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = 'TDE Certificate';- BACKUP CERTIFICATE TDE_Certificate TO FILE = ''d:TDE_Certificate.cer'- WITH PRIVATE KEY (FILE = 'D:TDE_Certificate.key', ENCRYPTION BY PASSWORD = 'MyPassword1!');- CREATE DATABASE ENCRYPTION KEY- WITH ALGORITHM = AES_256- ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate;- ALTER DATABASE Orders SET ENCRYPTION ON;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 AB.    Option BC.    Option CD.    Option D Answer: B QUESTION 55You 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% Answer: B QUESTION 56You 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 UserAB.    DENY SELECT ON Object::Regions FROM UserAC.    EXEC sp_addrolemember 'Sales', 'UserA'D.    DENY SELECT ON Object::Regions FROM SalesE.    REVOKE SELECT ON Object::Regions FROM UserAF.    DENY SELECT ON Schema::Customers FROM SalesG.    DENY SELECT ON Schema::Customers FROM UserAH.    EXEC sp_droproleraember 'Sales', 'UserA'I.    REVOKE SELECT ON Object::Regions FROM SalesJ.    REVOKE SELECT ON Schema::Customers FROM Sales Answer: FExplanation: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 57You 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 UserAB.    DENY SELECT ON Object::Regions FROM SalesC.    REVOKE SELECT ON Schema::Customers FROM SalesD.    REVOKE SELECT ON Schema::Customers FROM UserAE.    REVOKE SELECT ON Object::Regions FROM SalesF.    REVOKE SELECT ON Object::Regions FROM UserAG.    DENY SELECT ON Schema::Customers FROM SalesH.    DENY SELECT ON Schema::Customers FROM UserAI.    EXEC sp_addrolemember 'Sales', 'UserA'J.    EXEC sp droprolemember 'Sales', 'UserA' Answer: HExplanation: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 58You 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 UserAB.    DENY SELECT ON Schema::Customers FROM UserAC.    EXEC sp_addrolemember 'Sales', 'UserA'D.    REVOKE SELECT ON Object:: Regions FROM UserAE.    REVOKE SELECT ON Object::Regions FROM SalesF.    EXEC sp_droproiemember 'Sales', 'DserA'G.    REVOKE SELECT ON Schema::Customers FROM UserAH.    DENY SELECT ON Object::Regions FROM SalesI.    DENY SELECT ON Schema:: Customers FROM SalesJ.    REVOKE SELECT ON Schema:: Customers FROM Sales Answer: DExplanation: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 59You 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 UserAB.    REVOKE SELECT ON Object::Regions FROM UserAC.    EXEC sp_addrolemember 'Sales', 'UserA'D.    DENY SELECT ON Schema::Customers FROM SalesE.    EXEC sp_droprolemember 'Sales', 'UserA'F.    REVOKE SELECT ON Schema::Customers FROM SalesG.    DENY SELECT ON Object::Regions FROM UserAH.    REVOKE SELECT ON Object::Regions FROM SalesI.    DENY SELECT ON Schema::Customers FROM UserAJ.    DENY SELECT ON Object::Regions FROM Sales Answer: JExplanation: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 60You 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 Braindump2go Latest 70-462 Exam Dumps Released! 100% Real Questions - Dumps Qulification is the secret of Success! Prepare yourself to Face the 70-462 Exam with Real Exam Questions from Microsoft Official Exam Center, walk into the Testing Centre with confidence. http://www.braindump2go.com/70-462.html --------------------------------------------------- Images: http://www.itexamquiz.com/braindump2go/bdimages/330453033d4b_850C/1102.png http://www.itexamquiz.com/braindump2go/bdimages/330453033d4b_850C/wps1A06.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/330453033d4b_850C/wps3258.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/330453033d4b_850C/wps510F.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/330453033d4b_850C/152.png --------------------------------------------------- --------------------------------------------------- Post date: 2015-02-06 01:29:49 Post date GMT: 2015-02-06 01:29:49 Post modified date: 2015-02-06 01:29:49 Post modified date GMT: 2015-02-06 01:29:49 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com