Microsoft 70-462 Online Practice Questions and Exam Preparation

Microsoft 70-462 Online Questions & Answers

• Question 121:

  DRAG DROP

  You administer two Microsoft SQL Server database servers named ProdSrv1 and ProdSrv2. Each server has a database named Orders.

  You need to configure transactional replication from the OrderSummary table in the Orders database on ProdSrv1 to the OrderSummary table in the Orders database on ProdSrv2.

  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:

  

  

  ---

  Step 1: Configure ProdSrv1 as a Distributor.

  Step 2: Configure ProdSrv1 as a Publisher.

  Step 3: Configure a publication of the Order-Summary table on ProdSrv1.

  Step 4: Create a subscription of the publication in the Orders database on ProdSrv1.

  Reference: https://docs.microsoft.com/en-us/sql/relational-databases/replication/configure-publishing-and-distribution

• Question 122:

  Which of the following permissions must a user have in order to query all of the built-in Dynamic Management views?

  A. VIEW ALL
  B. SELECT ALL VEWS
  C. VIEW SERVER INFO
  D. VIEW SERVER STATE
  D. VIEW SERVER STATE

  ---

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

• Question 123:

  DRAG DROP

  You administer a Microsoft SQL Server 2012 server along with a Windows Azure SQL Database database.

  For both servers, you need to grant users the ability to create logins and create databases.

  You need to determine which permission to grant users in each instance.

  Which permission or permissions should you choose? (To answer, drag the appropriate permission or permissions to their corresponding instance type or types in the answer area.

  Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all.

  Additionally, you may need to drag the split bar between panes or scroll to view content.)

  Select and Place:

  

  

• Question 124:

  You are a database developer of a Microsoft SQL Server 2012 database. You are designing a table that will store Customer data from different sources. The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID. A sample of this data is as shown in the following table.

  

  You need to ensure that the table has no duplicate CustomerID within a SourceID. You also need to ensure that the data in the table is in the order of SourceID and then CustomerID. Which Transact- SQL statement should you use?

  

  A. OptionA
  B. OptionB
  C. OptionC
  D. OptionD
  D. OptionD

• Question 125:

  Which of the following DBCC commands shows optimizer statistics for objects such as tables?

  A. STATS
  B. SHOW_STATISTICS
  C. OBJECT_STATS
  D. OPTIMIZER
  B. SHOW_STATISTICS

  ---

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

• Question 126:

  You use a contained database named ContosoDb within a domain.

  You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.

  Which type of user should you create?

  A. SQL user without login
  B. User mapped to an asymmetric key
  C. Domain user
  D. login mapped to a virtual account
  C. Domain user

• Question 127:

  You administer a Microsoft SQL Server instance.

  The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. The database is configured to use the FULL

  recovery model.

  You plan to define a backup strategy for the database. You need to ensure that the following requirements are met:

  No more than 5 minutes worth of transactions are lost.

  Data can be recovered by using the minimum amount of administrative effort.

  What should you do? Each correct answer presents part of the solution.

  A. Create a LOG backup every 5 minutes.
  B. Configure the database to use the SIMPLE recovery model.
  C. Create a DIFFERENTIAL database backup every 4 hours.
  D. Create a DIFFERENTIAL database backup every 24 hours.
  E. Create a FULL database backup every 24 hours.
  A. Create a LOG backup every 5 minutes.
  E. Create a FULL database backup every 24 hours.

• Question 128:

  You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from SQL Server 2008 to SQL Server 2012.

  You want to evaluate to prepare for possible conflicts and issues that may arise during or after the migration.

  Which SQL Server tool should you use?

  A. Distributed Replay
  B. Migration Assistant
  C. Data Tools
  D. Upgrade Advisor
  D. Upgrade Advisor

• Question 129:

  Which of the following statements will create an index called "SalesDate" on the DATEOFSALE column on the SALES table residing in the WAREHOUSE database?

  A. CREATE INDEX SalesDate ON SALES (DATEOFSALE);
  B. MAKE INDEX SalesDate ON SALES (DATEOFSALE);
  C. CREATE INDEX ON SALES (DATEOFSALE);
  D. CREATE INDEX SalesDate ON SALES +DATEOFSALE;
  A. CREATE INDEX SalesDate ON SALES (DATEOFSALE);

  ---

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

• Question 130:

  You administer a Microsoft SQL Server 2012 database.

  Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error.

  You need to identify the root cause of the issue by retrieving the error message.

  What should you do?

  A. Update all stored procedure to use a TRY...CATCH block.
  B. Create a SQL Profiler session to capture all ErrorLog and EventLog events.
  C. Flag all stored procedures for recompilation by using sp_recompile.
  D. Execute sp_who.
  A. Update all stored procedure to use a TRY...CATCH block.