Microsoft 70-462 Online Practice Questions and Exam Preparation

Microsoft 70-462 Online Questions & Answers

• Question 71:

  You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Windows Server 2008 R2 and Microsoft SQL Server 2012. The company uses several custom applications that store data in databases on

  the Microsoft SQL Server 2012 servers.

  A full backup of all databases is taken every night at midnight.

  A differential backup of all databases is taken on the hour every hour starting at 3am until the last backup at 11pm.

  A log backup is taken every 15 minutes for databases configured with the Full Recovery Model.

  One application named ABCApp1 stores data in a database named ABCApp1DB.

  ABCApp1DB is configured with the Simple Recovery Model. ABCApp1DB fails at 3:25am.

  You discover that the last differential backup of ABCApp1DB failed.

  You need to restore ABCApp1DB from backup as quickly as possible and minimize data loss.

  Which of the following steps should you perform to restore ABCApp1DB? (Choose one or more answers).

  A. Restore the latest full backup.
  B. Restore the latest differential backup
  C. Restore the latest log backup
  D. Restore each differential backup taken since the last full backup.
  E. Restore each log backup since the last full backup.
  A. Restore the latest full backup.

• Question 72:

  Which of the following is NOT a hardware requirement for SQL Server 2012?

  A. 6GB of hard drive space
  B. 1GB of memory
  C. 1GHZ CPU speed
  D. a graphics card with 2GB video memory
  D. a graphics card with 2GB video memory

  ---

  References: https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.110%29.aspx

• Question 73:

  Which of the following is the default instance name in an SQL Server 2012 installation?

  A. SQLSERVER12
  B. MSSQLSERVER
  C. MSSQL
  D. 2012SQL
  B. MSSQLSERVER

  ---

  References: https://msdn.microsoft.com/en-us/library/ms143547(v=sql.110).aspx

• Question 74:

  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 the users?

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

• Question 75:

  DRAG DROP

  You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data.

  You need to encrypt the database files at the page level. You also need to encrypt the transaction log files.

  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.)

  Select and Place:

  

  

• Question 76:

  What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?

  A. 512 MB
  B. 1 GB
  C. 2 GB
  D. 4 GB
  D. 4 GB

  ---

  The minimum required is 1 GB, but the minimum recommend is 4 GB.

  Note: Recommended:

  Express Editions: 1 GB

  All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.

  References: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx

• Question 77:

  DRAG DROP

  You administer two Microsoft SQL Server 2012 servers named ServerA and ServerB. You use a database named AdventureWorks.

  You need to prepare the AdventureWorks database for database mirroring. ServerB will act as the mirror in a mirroring partnership along with ServerA.

  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:

  

  

  ---

  Reference: http://msdn.microsoft.com/en-us/library/ms189852.aspx http://msdn.microsoft.com/en-us/library/ms190941.aspx

• Question 78:

  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?

  A. SQLIO
  B. SQLIOSim
  C. SQLIOStress
  D. chkdsk
  B. SQLIOSim

• Question 79:

  DRAG DROP

  You administer a Microsoft SQL Server 2012 server that has multiple databases.

  You need to ensure that users are unable to create stored procedures that begin with sp_.

  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:

  

  

  ---

  Step 1: Create a Condition named StoredProcNamingConvention by using the Stored Procedure facet that has a single expression. Set the Field to @Name, Operator to NOT LIKE, and Value to 'sp[_]%'.

  Step 2: Create a Policy named StoredProcNamingPolicy Set the Check condition to StoredProcNamingConvention and Evaluation Mode to On Change: Prevent

  Step 3: Enable StoredProcNamingPolicy

  Policies are created and managed by using Management Studio. The process includes the following steps:

  1.

  Select a Policy-Based Management facet that contains the properties to be configured.

  2.

  Define a condition that specifies the state of a management facet.

  3.

  Define a policy that contains the condition, additional conditions that filter the target sets, and the evaluation mode.

  4.

  Check whether an instance of SQL Server is in compliance with the policy.

  Evaluation modes

  There are four evaluation modes, three of which can be automated:

  On demand. This mode evaluates the policy when directly specified by the user.

  On change: prevent. This automated mode uses DDL triggers to prevent policy violations.

  Important:

  If the nested triggers server configuration option is disabled, On change: prevent will not work correctly. Policy-Based Management relies on DDL triggers to detect and roll back DDL operations that do not comply with policies that use this

  evaluation mode. Removing the Policy-Based Management DDL triggers or disabling nest triggers, will cause this evaluation mode to fail or perform unexpectedly.

  On change: log only. This automated mode uses event notification to evaluate a policy when a relevant change is made.

  On schedule. This automated mode uses a SQL Server Agent job to periodically evaluate a policy.

  Reference: http://msdn.microsoft.com/en-us/library/bb510667.aspx

• Question 80:

  You administer a Microsoft Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails.

  You add two Windows groups as logins for the server:

  CORP\Employees - All company employees

  CORP\HRAdmins - HR administrators only

  HR Administrators are also company employees.

  You need to grant users access according to the following requirements:

  CORP\Employees should have SELECT access to the Employees table.

  Only users in CORP\HRAdmins should have SELECT access to the SalaryDetails table.

  Logins are based only on Windows security groups.

  What should you do?

  A. Create a database role called Employees. Add CORP\Employees to the db_datareader role. Add all company employees except HR administrators to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role.
  B. Create a database role called HRAdmins. Add all company employees except HR administrators to the db_datareader role, Add all HR administrators to the HRAdmins role. Grant SELECT access to the SalaryDetails table to the HRAdmins role. Deny SELECT access to the SalaryDetails table to the db_datareader role.
  C. Create two database roles: Employees and HRAdmins. Add all company employees to the Employees role. Add HR administrators to the HRAdmins role. Grant SELECT access to all tables except SalaryDetails to the Employees role. Grant SELECT access to the SalaryDetails table to the HRAdmins role. Deny SELECT access to the SalaryDetails table to the Employees role.
  D. Create a database role called Employees. Add all HR administrators to the db_datareader role. Add all company employees to the Employees role. Grant SELECT access to all tables except the SalaryDetails table to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role.
  D. Create a database role called Employees. Add all HR administrators to the db_datareader role. Add all company employees to the Employees role. Grant SELECT access to all tables except the SalaryDetails table to the Employees role. Deny SELECT access to the SalaryDetails table to the Employees role.