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

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

Question No.21

DRAG DROP

You are configuring a new Microsoft SQL Server Always On Availability Group. You plan to configure a shared network location at \\DATA-CI1\SQL.

You need to create an availability group listener named AGL1 on port 1433. In which order should you perform the actions?

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

image

Correct Answer:

image

Question No.22

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.

You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.

Solution: You add the DatabaseMailUserRole to Mail1 in the master database. Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: B

Explanation:

Database Mail is guarded by the database role DatabaseMailUserRole in the msdb database, not the master database, in order to prevent anyone from sending arbitrary emails. Database users or roles must be created in the msdb database and must also be a member of DatabaseMailUserRole in order to send emails with the exception of sysadmin who has all privileges.

Note:

Database Mail was first introduced as a new feature in SQL Server 2005 and replaces the SQL Mail feature found in previous versions.

References: http://www.idevelopment.info/data/SQLServer/DBA_tips/Database_Administration/DBA_20.shtml

Question No.23

You administer all the deployments of Microsoft SQL Server 2016 in your company.

You need to ensure that data changes are sent to a non-SQL Server database server in near real time.

You also need to ensure that data on the primary server is unaffected. Which configuration should you use?

  1. SQL Server that includes an application database configured to perform transactional replication

  2. Two servers configured in different data centers SQL Server Availability Group configured in AsynchronousCommit Availability Mode

  3. Two servers configured in different data centers SQL Server Availability Group configured in Synchronous-Commit Availability Mode One server configured as an Active Secondary

  4. SQL Server that includes an application database configured to perform snapshot replication

  5. Two servers configured in the same data center SQL Server Availability Group configured in AsynchronousCommit Availability Mode One server configured as an Active Secondary

  6. Two servers configured on the same subnet SQL Server Availability Group configured in Synchronous-Commit Availability Mode

  7. Two servers configured in a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance

  8. Two servers configured in the same data center A primary server configured to perform log- shipping every 10 minutes A backup server configured as a warm standby

Correct Answer: A

Explanation:

SQL Server supports the following heterogeneous scenarios for transactional and snapshot replication:

image

image

Publishing data from SQL Server to non- SQL Server Subscribers. Publishing data to and from Oracle has some restrictions.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/heterogeneous- database-replication

Question No.24

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You need to examine information about logins, CPU times, and Disk I/O on a particular database in Microsoft Azure.

What should you use?

  1. Activity Monitor

  2. Sp_who3

  3. SQL Server Management Studio (SSMS) Object Explorer

  4. SQL Server Data Collector

  5. SQL Server Data Tools (SSDT)

  6. SQL Server Configuration Manager

Correct Answer: A

Explanation:

Activity Monitor displays information about SQL Server processes and how these processes affect the current instance of SQL Server.

Activity Monitor is a tabbed document window with the following expandable and collapsible panes: Overview, Active User Tasks, Resource Waits, Data File I/O, and Recent Expensive Queries.

The Activity User Tasks Pane shows information for active user connections to the instance, including the following column:

  • Login: The SQL Server login name under which the session is currently executing.

    The Recent Expensive Queries Pane shows information about the most expensive queries that have been run on the instance over the last 30 seconds, including the following column:

  • CPU (ms/sec): The rate of CPU use by the query References:

https://technet.microsoft.com/en-us/library/cc879320(v=sql.105).aspx

Question No.25

You administer all the deployments of Microsoft SQL Server 2016 in your company. A database contains a large product catalog that is updated periodically.

You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?

  1. Two servers configured in the same data center A primary server configured to perform log- shipping every 10 minutes A backup server configured as a warm standby

  2. SQL Server that includes an application database configured to perform transactional replication

  3. Two servers configured in the same data center SQL Server Availability Group configured in AsynchronousCommit Availability Mode One server configured as an Active Secondary

  4. Two servers configured in a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance

  5. SQL Server that includes an application database configured to perform snapshot replication

  6. Two servers configured in different data centers SQL Server Availability Group configured in Synchronous-Commit Availability Mode One server configured as an Active Secondary

  7. Two servers configured on the same subnet SQL Server Availability Group configured in Synchronous-Commit Availability Mode

  8. Two servers configured in different data centers SQL Server Availability Group configured in AsynchronousCommit Availability Mode

Correct Answer: E

Explanation:

Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.

Using snapshot replication by itself is most appropriate when one or more of the following is true:

image

Data changes infrequently.

image

It is acceptable to have copies of data that are out of date with respect to the Publisher for a period of time.

image

Replicating small volumes of data.

A large volume of changes occurs over a short period of time. References:

https://docs.microsoft.com/en-us/sql/relational-databases/replication/snapshot-replication

Question No.26

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.

A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases.

One customer reports that their database is not responding as quickly as the service level agreements dictate.

You observe that the database is fragmented. You need to optimize query performance.

Solution: You run the DBCC CHECKDB command. Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: B

Explanation:

DBCC CHECKDB only checks the logical and physical integrity of all the objects in the specified database. It does not update any indexes, and does not improve query performance.

References:

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact- sql

Question No.27

A Microsoft SQL Server database named DB1 has two filegroups named FG1 and FG2. You implement a backup strategy that creates backups for the filegroups.

DB1 experiences a failure. You must restore FG1 and then FG2.

You need to ensure that the database remains in the RECOVERING state until the restoration of FG2 completes. After the restoration of FG2 completes, the database must be online.

What should you specify when you run the recovery command?

  1. the WITH NORECOVERY clause for FG1 and the WITH RECOVERY clause for FG2

  2. the WITH RECOVERY clause for FG1 and the WITH RECOVERY clause for FG2

  3. the WITH RECOVERY clause for both FG1 and FG2

  4. the WITH NORECOVERY clause for both FG1 and FG2

Correct Answer: A

Question No.28

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 monitoring for Tailspin Toys.

In the table below, identify the monitoring tool that you must use for each activity. NOTE: Make only one selection in each column.

image

Correct Answer:

image

Question No.29

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.

A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1.

You need to ensure that you can perform auditing at the database level for DB1.

Solution: You migrate DB1 to the default instance on a server that runs Microsoft SQL Server 2016 Standard edition.

Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: B

Explanation:

All editions of SQL Server support server level audits. All editions support database level audits beginning with SQL Server 2016 SP1. Prior to that, database level auditing was limited to Enterprise, Developer, and Evaluation editions.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-

database-engine

Question No.30

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts a customer database named DB1.

Customers connect to hosted database instances by using line-of-business applications. Developers connect by using SQL Server Management Studio (SSMS).

You need to grant the developers permission to alter views for DB1 while following the principle of least privilege.

Which permission should you grant?

  1. DDLAdmin

  2. db_datawriter

  3. dbcreator

  4. dbo

  5. View Database State

  6. View Server State

  7. View Definition

  8. sysadmin

Correct Answer: A

Explanation:

To execute ALTER VIEW, at a minimum, ALTER permission on OBJECT is required.

Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

References:

https://technet.microsoft.com/en-us/library/ms190667(v=sql.90).aspx

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>