[Free] 2019(Nov) EnsurePass Microsoft 70-764 Dumps with VCE and PDF 81-90

Get Full Version of the Exam
http://www.EnsurePass.com/70-764.html

Question No.81

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:

image

The differential backup of the reporting database fails. Then, the reporting database fails at 14:00 hours.

You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal.

What should you do?

  1. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.

  2. Perform a point-in-time restore.

  3. Restore the latest full backup.

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

  5. Restore the latest full backup. Then, restore the latest differential backup.

  6. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.

  7. Perform a page restore.

  8. Perform a partial restore.

Correct Answer: C

Explanation:

The differential backup of the reporting database has failed, so it can#39;t be used.

Question No.82

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.

image

You need to configure auditing for the Adventure Works environment.

How should you complete the Transact-SQL statement?

To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

image

Correct Answer:

image

Question No.83

You administer a Microsoft SQL Server 2016 database instance. You plan to migrate the database to Windows Azure SQL Database.

You verify that all objects contained in the database are compatible with Windows Azure SQL Database.

You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database.

What should you do?

  1. Use the Copy Database wizard.

  2. Back up the database from the local server and restore it to Windows Azure SQL Database.

  3. Use the Database Transfer wizard.

  4. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database.

Correct Answer: D

Question No.84

You are a database administrator for a Microsoft SQL Server 2016 environment.

You want to deploy a new application that will scale out the workload to at least five different SQL Server instances.

You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances.

Which feature should you use?

  1. Database Mirroring

  2. B.Peer-to-Peer Replication

  3. Log Shipping

  4. Availability Groups

Correct Answer: B

Question No.85

You administer a Microsoft SQL Server 2016 database that includes a table named dbo.Log. This table contains millions of records about user activity in an application.

Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention withinserts.

You need to be able to modify dbo.Log without requiring any changes to the applications that utilize dbo.Log.

Which type of solution should you use?

  1. Extended events

  2. Columnstore index

  3. Partitioned tables

  4. Read committed snapshot

Correct Answer: C

Question No.86

You are the administrator of a Microsoft SQL Server 2016 server. Some applications consume significant resources.

You need to manage the server workload by restricting resource-intensive applications. You need to dynamically limit resource consumption.

What should you do?

  1. Set up Service Broker to ensure that applications are not allowed to consume more than the specified amount of resources.

  2. Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource Governor.

  3. C.Configure Extended Events to monitor and restrict resource limits allowed by each application type.

  4. Create a new Plan Guide with a Scope Type of sql and define the resource limits for each application.

Correct Answer: B

Question No.87

DRAG DROP

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 have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram.

image

You have an Always On Availability group named AG1. The details for AG1 are shown in the following table.

image

Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is four terabytes (TB) in size. The database has multiple data files and

filegroups. One of the filegroups is read_only and is half of the total database size. Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I/O.

Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes.

You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain.

You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1.

All databases use the full recovery model. All backups are written to the network location

\\SQLBackup\. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups. The recovery point objective (RPO) for each instance is shown in the following table.

image

Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups use the keyword COMPRESSION.

You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1.

Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make no changes to the data. The queries must be load balanced over variable read-only replicas.

Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the database. Queries from the operations system will perform both DDL and DML operations.

The wait statistics monitoring requirements for the instances are described in the following table.

image

You need to propose a new process for the StagedExternal database. Which five actions should you recommended be performed in sequence?

To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

image

Correct Answer:

image

Question No.88

DRAG DROP

You administer a Microsoft SQL Server database named Contoso. You create a stored procedure named Sales.ReviewInvoice by running the following Transact-SQL statement:

image

You need to create a Windows-authenticated login named ContosoSearch and ensure that ContosoSearch can run the Sales.ReviewInvoices stored procedure.

Which three Transact-SQL segments should you use to develop the solution?

To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.

image

Correct Answer:

image

Question No.89

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

Your company has several Microsoft SOI Server instances. Each instance hosts many databases. You observe I/O corruption on some of the instances.

You need to perform the following actions:

image

image

Identify databases where the PAGE VERIFY option is not set. Configure full page protection for the identified databases.

Solution: You run the following Transact-SQL statement:

image

For each database that you identify, you run the following Transact-SQL statement:

image

Does the solution meet the goal?

  1. Yes

  2. NO

Correct Answer: B

Explanation:

We should check for CHECKSUM not TORN_PAGE_DETECTION

References:

https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/set-the- page-verify-database-option-to-checksum?view=sql-server-2017

Question No.90

HOTSPOT

You manage a Microsoft SQL Server environment. A server fails and writes the following event to the application event log:

MSG_AUDIT_FORCED_SHUTDOWN

You configure the SQL Server startup parameters as shown in the following graphic:

image

Use the drop-down menus to select the answer choice that answers each question. NOTE: Each correct selection is worth one point.

image

Correct Answer:

image

Get Full Version of the Exam
70-764 Dumps
70-764 VCE and PDF

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.