Microsoft 70-462 Online Practice Questions and Exam Preparation

Microsoft 70-462 Online Questions & Answers

• Question 91:

  DRAG DROP

  You administer a Microsoft SQL Server 2012 database.

  The database is backed up according to the following schedule:

  Daily full backup at 23:00 hours.

  Differential backups on the hour, except at 23:00 hours.

  Log backups every 10 minutes from the hour, except on the hour. The

  database uses the Full recovery model.

  A developer accidentally drops a number of tables and stored procedures from the database between 22:40 hours and 23:10 hours. You perform a database restore at 23:30 hours to recover the dropped table.

  You need to restore the database by using the minimum amount of administrative effort.

  You also need to ensure minimal data loss.

  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:

  

  

• Question 92:

  Which of the following editions of SQL Server 2012 can you run on a computer that is running the Windows 7 Professional (x64) operating system? (Choose all that apply.)

  A. SQL Server 2012 (x64) Developer edition
  B. SQL Server 2012 (x64) Web edition
  C. SQL Server 2012 (x64) Enterprise edition
  D. SQL Server 2012 (x64) Standard edition
  A. SQL Server 2012 (x64) Developer edition
  D. SQL Server 2012 (x64) Standard edition

• Question 93:

  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
  J. DENY SELECT ON Object::Regions FROM Sales

  ---

  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 94:

  You administer a Microsoft SQL Server database.

  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?

  A. SELECT * FROM sys.stats WHERE object_id = 60
  B. EXEC sp_who 60
  C. SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60
  D. DBCC OPENTRAN
  B. EXEC sp_who 60

  ---

  References: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-who-transact-sql https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-sessions-transact-sql https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql

• Question 95:

  You are planning on deploying a server that will be dedicated for ETL (Extraction, Transformation, and Loading) processes.

  You want to ensure that SSIS (SQL Server Integration Services) packages will run on this dedicated ETL server and not on any other server on which they were started.

  Which of the following features must you install on the ETL server in addition to SSIS to accomplish this goal?

  A. Database Engine
  B. SQL Server Reporting Services
  C. SQL Server Analysis Services
  D. Client Tools SDK
  A. Database Engine

• Question 96:

  DRAG DROP

  You administer several Microsoft SQL Server 2012 servers.

  You want to run scheduled checks to confirm that the databases on the servers are not configured to AutoShrink.

  You need to create a policy to check the condition.

  What should you do? (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:

  

  

  ---

  The Evaluation Mode defines the combination of 1) when the policy will be evaluated and 2) what the system will do in case of policy violation. The following evaluation modes are supported:

  

  References: https://blogs.msdn.microsoft.com/sqlpbm/2009/04/13/policy-evaluation-modes/

• Question 97:

  You have recently removed a SQL 2012 Database Engine instance from a computer running the Windows Server 2008 R2 operating system. Prior to the removal of the instance, you had configured affinity so that the default instance used

  CPU 0 and 1 and the second instance used CPU 2 and 3.

  You want to ensure that the default instance can use all processors available to the host.

  Which of the following commands would you use to accomplish this goal?

  A. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = AUTO
  B. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3
  C. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,1
  D. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,4
  A. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = AUTO

• Question 98:

  You administer a Microsoft Azure SQL Database database named Orders.

  You need to create a copy of Orders named Orders_Reporting.

  Which Transact-SQL command should you use?

  

  A. B.
  C. CREATE DATABASE Orders_Reporting AS COPY OF Orders
  C. CREATE DATABASE Orders_Reporting AS COPY OF Orders

• Question 99:

  You administer a database that has User A, B and C.

  User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert data.

  User C must be able to provide windows logins to the database

  To which role or roles should you add to UserC? Select all that apply.

  A. db_accessadmin
  B. db_ddladmin
  C. db_datawriter
  D. db_datareader
  E. db_owner
  A. db_accessadmin

  ---

  User A = db_ddladmin User B= db_datawriter, db_datareader User C = db_accessadmin

• Question 100:

  You install a Microsoft SQL Server instance.

  The instance will store data extracted from two databases running on Microsoft Azure SQL Database.

  You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the data.

  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 DATA Tools and Distributed Replay Client
  B. Data Quality Client and SQL Server DATA Tools
  C. Master Data Services and SQL Server Data Tools
  D. Data Quality Client and Distributed Replay Client
  B. Data Quality Client and SQL Server DATA Tools

  ---

  Data Quality Client is a standalone application that enables you to perform knowledge management, data quality projects, and administration in one user interface. The application is designed for both data stewards and DQS administrators. It

  is a stand-alone executable file that performs knowledge discovery, domain management, matching policy creation, data cleansing, matching, profiling, monitoring, and server administration.

  SQL Server Data Tools is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services

  reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

  Incorrect Answers:

  A, D: The SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.

  C: Master Data Services enables you to manage a master set of your organization's data. You can organize the data into models, create rules for updating the data, and control who updates the data.

  References: https://technet.microsoft.com/en-us/library/ff877917(v=sql.110).aspx https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt