[Free] 2018(Aug) Dumps4cert Microsoft 70-764 Dumps with VCE and PDF Download 21-30

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Aug Microsoft Official New Released 70-764
100% Free Download! 100% Pass Guaranteed!

Administering a SQL Database Infrastructure

Question No: 21

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 are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.

You have a user database named HRDB that contains sensitive human resources data. The HRDB backup files must be encrypted.

You need to grant the correct permission to the service account that backs up the HRDB database.

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

Answer: G Explanation:

Restoring the encrypted backup: SQL Server restore does not require any encryption parameters to be specified during restores. It does require that the certificate or the asymmetric key used to encrypt the backup file be available on the instance that you are restoring to. The user account performing the restore must have VIEW DEFINITION permissions on the certificate or key.

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup- restore/backup-encryption

Question No: 22

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 are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.

One instance hosts a user database named HRDB. The database contains sensitive human resources data.

You need to grant an auditor permission to view the SQL Server audit logs 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

Answer: F Explanation:

Unless otherwise specified, viewing catalog views requires a principal to have one of the following:

References: https://technet.microsoft.com/en-us/library/cc280386(v=sql.110).aspx

Question No: 23

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 sections, 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

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_Administrati on/DBA_20.shtml

Question No: 24 HOTSPOT

You are planning the deployment of two new Always On Failover Cluster Instances (FCIs) of Microsoft SQL Server to a single Windows Server Cluster with three nodes. The planned configuration for the cluster is shown in the Server Layout exhibit. (Click the Exhibit button.)

Dumps4Cert 2018 PDF and VCE

The SAN team has configured storage for the cluster and sent the configuration to you in the email shown in the SAN Team Email exhibit. (Click the Exhibit button.)

Dumps4Cert 2018 PDF and VCE

Each node of the cluster has identical local storage available as shown in the Local Storage exhibit. (Click the Exhibit button.)

Dumps4Cert 2018 PDF and VCE

All local storage is on SSD.

You need to plan specific configurations for the new cluster.

For each of the following statement, select Yes if the statement is true. Otherwise, select No.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 25 DRAG DROP

You have a test server that contains a database named DB1. Backups of the database are written to a single backup device. The backup device has a full, differential, and transaction log backup.

You discover that the database is damaged. You restore the database to the point at which the differential backup was taken.

You need to rebuild the database with data stored in the latest transaction logs.

How should you complete the Transact-SQL statement? To answer. drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment 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.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Explanation:

Dumps4Cert 2018 PDF and VCE

Box 1: RESTORE

Box 2: RECOVERY

The RESTORE … WITH RECOVERY option puts the database into a useable state, so users can access a restored database.

References:https://www.mssqltips.com/sqlservertutorial/112/recovering-a-database-that-is- in-the-restoring-state/

Question No: 26 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:

Dumps4Cert 2018 PDF and VCE

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.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 27 HOTSPOT

You manage a Microsoft-SQL Server database named sales Orders.

You need to verify the integrity of the database and attempt to repair any errors that are found. Repair must not cause any data to be lost in the database.

How should you complete the DBCC command? To answer, select the appropriate options in the answer area.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Explanation:

Dumps4Cert 2018 PDF and VCE

Box 1: CHECKDB

DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database.

Partial syntax: DBCC CHECKDB

[ ( database_name | database_id | 0 [ , NOINDEX

| , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]

….

Box 2: REPAIR_REBUILD

DBCC CHECKDB …REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST |REPAIR_REBUILD

specifies that DBCC CHECKDB repair the found errors.

REPAIR_REBUILD performs repairs that have no possibility of data loss. This can include quick repairs, such as repairing missing rows in non-clustered indexes, and more time- consuming repairs, such as rebuilding an index.

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

Question No: 28 DRAG DROP

You have a database. The existing backups for the database and their corresponding files are listed in the following table.

Dumps4Cert 2018 PDF and VCE

You purchase a new server. You must restore the database to the new server. You need to restore the data to the most recent time possible.

Which three files should you restore in sequence? To answer, move the appropriate files from the list of files to the answer area and arrange them in the correct order.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Explanation:

Dumps4Cert 2018 PDF and VCE

Step 1: Full..

Start with the full backup.

Step 2: Diff_20160503_1700.bak

Followed by the most recent differential backup.

Step 3: Log_20160503_1900.bak

And finally the most recent log backup (the only log backup done after the most recent differential backup).

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup- restore/differential-backups-sql-server

Question No: 29

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

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: 30

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

Answer: A

100% Dumps4cert Free Download!
70-764 PDF
100% Dumps4cert Pass Guaranteed!
70-764 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

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