Mobile Menu

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

by admin, November 6, 2019

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

Question No.41

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 the Contoso instance.

How should you complete the Transact-SQL statement?

To answer, select the appropriate Transact-SQL segments in the answer area.

image

Correct Answer:

image

Question No.42

You use Microsoft SQL Server 2016 to write code for a transaction that contains several statements.

There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space.

You also need to prevent reading queries from blocking writing queries. Which isolation level should you use?

  1. SERIALIZABLE

  2. SNAPSHOT

  3. READ COMMITTED SNAPSHOT

  4. REPEATABLE READ

Correct Answer: C

Explanation:

For most applications, read committed isolation using row versioning is recommended over snapshot isolation for the following reasons:

It consumes less tempdb space than snapshot isolation. Etc.

References:

https://msdn.microsoft.com/en-us/library/ms188277.aspx

Question No.43

HOTSPOT

You manage a Microsoft SQL Server instance. You have a user named User1.

You need to grant the minimum permissions necessary to allow User1 to review audit logs. For each action, which option should you use?

To answer, select the appropriate options in the answer area.

image

Correct Answer:

image

Question No.44

You administer a Microsoft SQL Server 2016 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics:

image

image

image

A data file of 2 terabytes is located on a dedicated LUN (drive D). A transaction log of 10 GB is located on a dedicated LUN (drive E). Drive D has 1 terabyte of free disk space.

image

Drive E has 5 GB of free disk space.

The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours.

Five percent of the existing data is modified each day.

The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands.

Each data load adds 3 GB of data to the database.

These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours.

Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.

You implement log shipping of the financial database to another SQL Server 2016 instance. You decide to failover to this secondary database.

You need to ensure that all transactions will be replicated to the secondary database. Which backup option should you use?

  1. Differential

  2. Transaction Log

  3. FULL

  4. SIMPLE

  5. SKIP

  6. RESTART

  7. STANDBY

  8. CHECKSUM

  9. DBO_ONLY

  10. COPY_ONLY

  11. NORECOVERY

  12. NO_CHECKSUM

  13. CONTINUE_AFTER_ERROR

  14. BULK_LOGGED

Correct Answer: K

Explanation:

Roll back is controlled by the RESTORE statement through the [ RECOVERY | NORECOVERY ] options:

NORECOVERY specifies that roll back not occur. This allows roll forward to continue with the next statement in the sequence.

References:

https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql

Question No.45

You administer a Microsoft SQL Server 2016 database.

The database is currently configured to log ship to a secondary server.

You are preparing to cut over to the secondary server by stopping log-shipping and bringing the secondary database online.

You want to perform a tail-log backup. You need to leave the primary database in a restoring state.

Which option of the BACKUP LOG command should you use?

  1. NO_TRUNCATE

  2. NORECOVERY

  3. STANDBY

  4. FORMAT

Correct Answer: B

Question No.46

You administer a SQL Server 2016 database instance.

You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use?

  1. A domain user

  2. The BUILTIN\SYSTEM account

  3. A local user with Run as Service permissions

  4. The SQLBrowser account

Correct Answer: A

Explanation:

Account of the person who installs the cluster: The person who installs the cluster must use an account with the following characteristics:

The account must be a domain account. It does not have to be a domain administrator account. It can be a domain user account if it meets the other requirements in this list.

Etc. References:

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and- 2008/cc731002(v=ws.10)

Question No.47

You administer a Microsoft SQL Server 2016 server that has SQL Server Integration Services (SSIS) installed.

You plan to deploy new SSIS packages to the server.

The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables.

You need to configure the SQL Server environment to support these packages. What should you do?

  1. Create SSIS configuration files for the packages.

  2. Create an Integration Services catalog.

  3. Install Data Quality Services.

  4. Install Master Data services.

Correct Answer: B

Explanation:

Use can use Project Deployment Model for a project, containing packages and parameters, which is deployed to the SSISDB catalog on an instance of SQL Server.

References:

https://docs.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services- ssis-projects-and-packages

Question No.48

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 a named instance on a server that runs Microsoft SQL Server 2016 Enterprise edition.

Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: A

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

HOTSPOT

You manage a Microsoft SQL Server environment. You have a database named salesOrders that includes a table named Table1.

Table1 becomes corrupt. You repair the table.

You need to verify that all the data in Table1 complies with the schema. How should you complete the Transact-SQL code statement?

To answer, select the appropriate Transact-SQL code segments in the dialog box in the answer area.

image

Correct Answer:

image

Question No.50

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 msdb database. Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: A

Explanation:

Database Mail is guarded by the database role DatabaseMailUserRole in the msdb 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

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

Categories