Microsoft 70-764 Online Practice Questions and Exam Preparation

Microsoft 70-764 Online Questions & Answers

• Question 331:

  DRAG DROP

  You plan to deploy SQL Server 2014.

  You identify the following security requirements for the deployment:

  Users must be prevented from intercepting and reading the T-SQL statements sent from the clients to the database engine.

  All database files and log files must be encrypted if the files are moved to another disk on another server.

  You need to identify which feature meets each security requirement. The solution must minimize processor overhead.

  Which features should you identify? To answer, drag the appropriate feature to the correct requirement in the answer area.

  Select and Place:

  

  

  ---

  -

  Secure Sockets Layer (SSL) encryption enables transmitting encrypted data across the network between an instance of SQL Server and a client application.

  -

  Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files.

• Question 332:

  You administer a Microsoft SQL Server 2016 server.

  When transaction logs grow, SQL Server must send an email message to the database administrators.

  You need to configure SQL Server to send the email messages.

  What should you configure?

  A. SQL Mail
  B. An Extended Events session
  C. Alerts and operators in SQL Server Agent
  D. Policies under Policy-Based Management
  C. Alerts and operators in SQL Server Agent

• Question 333:

  HOTSPOT

  Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

  You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table.

  

  You need to configure auditing for WDWDB.

  In the table below, identify the event type that you must audit for each activity.

  Hot Area:

  

  

• Question 334:

  DRAG DROP

  You have an SQL Server 2014 server. You plan to create four stored procedures that will use transactions. The stored procedures will be configured as shown in the following table.

  

  You need to recommend an isolation level for each stored procedure. The solution must support the concurrency strategy of each stored procedure and must minimize locks.

  What should you recommend?

  To answer, drag the appropriate isolation levels to the correct stored procedures. Each isolation level may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

  Select and Place:

  

  

  ---

  References: SET TRANSACTION ISOLATION LEVEL (Transact-SQL) https://msdn.microsoft.com/en-us/library/ms173763.aspx

• Question 335:

  You administer a Microsoft SQL Server 2016 server that hosts a transactional database and a reporting database.

  The transactional database is updated through a web application and is operational throughout the day.

  The reporting database is only updated from the transactional database.

  The recovery model and backup schedule are configured as shown in the following table:

  

  At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database. You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal.

  What should you do?

  A. Perform a partial restore.
  B. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
  C. Perform a point-in-time restore.
  D. Restore the latest full backup.
  E. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
  F. Perform a page restore.
  G. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
  H. Restore the latest full backup. Then, restore the latest differential backup.
  F. Perform a page restore.

• Question 336:

  You administer two instances of Microsoft SQL Server 2016.

  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. Use the Data Quality Client to configure the application.
  B. Start the SQL Server Browser Service.
  C. Use the Master Data Services Configuration Manager to configure the application.
  D. Start the SQL Server Integration Services Service.
  B. Start the SQL Server Browser Service.

• Question 337:

  You have a server named Server1 that has 16 processors.

  You plan to deploy multiple instances of SQL Server 2014 to Server1.

  You need to recommend a method to allocate processors to each instance.

  What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

  A. Processor affinity
  B. Windows System Resource Manager (WSRM)
  C. Max Degree of Parallelism
  D. Resource Governor
  A. Processor affinity

• Question 338:

  You have a database hosted on SQL Server 2012 R2.

  The database contains 5 million rows.

  You need to recommend a repeatable method to migrate the database to SQL Azure.

  Which method should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

  A. Create a SQL Server Integration Services (SSIS) package, and then run the package.
  B. Back up the database, and then restore the database.
  C. Extract a data-tier application, and then import the application.
  D. Generate scripts to create all of the all database objects and all of the data, and then execute the scripts by using SQL Azure.
  A. Create a SQL Server Integration Services (SSIS) package, and then run the package.

• Question 339:

  You work as a Database Administrator (DBA) at ABC.com.

  All databases are hosted on Windows Server 2012 servers running SQL Server 2012.

  The Sales department uses a database named SalesDB.

  SalesDB contains a large table named Orders that lists every order ever received by the company. You want to improve the performance of SalesDB.

  You want to configure the database to provide the fastest possible access to the most recent orders.

  Historical orders can be stored using a slower storage solution.

  How can you achieve this goal?

  A. By configuring database mirroring.
  B. By configuring a failover cluster.
  C. By partitioning the Orders table.
  D. By partitioning a partitioned view of the Orders table.
  C. By partitioning the Orders table.

• Question 340:

  You are building a stored procedure for a SQL Azure database. The procedure will add multiple rows to a table. You need to design the stored procedure to meet the following requirements:

  If any of the new rows violates a table constraint, then no further additions must be attempted and all changes made by the stored procedure must be discarded.

  If any errors occur, a row must be added to an audit table, and the original error must be returned to the caller of the stored procedure.

  What should you include in the design?

  A. An implicit transaction that has XACT_ABORT enabled
  B. An explicit transaction that has XACT_ABORT disabled
  C. An implicit transaction that has error handling enabled
  D. An explicit transaction that has error handling enabled
  D. An explicit transaction that has error handling enabled