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

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

Question No.51

You install Microsoft SQL Server 2016 on a new server.

After setup is complete, you attempt to start the SQL Server service.

After being in a starting state for a few moments, the service goes back to a stopped state. You need to determine the cause of the failure. Which file should you use?

  1. %programfiles%\Microsoft SQLServer\MSSQL11.MSSQLSERVER|MSSQL\Log\Errorlog

  2. %programfiles%\Microsoft SQL Server\110\setupBootstrap\Log\Summary.txt

  3. %programfiles%\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.idf

  4. %programfiles%\Microsoft SQLServer\110\Shared\ErrorDmpr[XXXX] .mdmp

Correct Answer: A

Question No.52

You administer a Microsoft SQL Server 2016 database.

You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges.

You need to ensure that the job step can run using a different user account. What should you use?

  1. a schedule

  2. an alert

  3. an operator

  4. a proxy

Correct Answer: D

Question No.53

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?

  1. Use the Data Quality Client to configure the application.

  2. Start the SQL Server Browser Service.

  3. Use the Master Data Services Configuration Manager to configure the application.

  4. Start the SQL Server Integration Services Service.

Correct Answer: B

Explanation:

The SQL ServerBrowser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server Browser contributes to the following actions:

Browsing a list of available servers Connecting to the correct server instance Etc.

References:

https://docs.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-browser-service

Question No.54

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 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 implement a process for importing data into WingDB.

Which three actions should you perform 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.55

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 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 SQL 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 NONE or 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.56

You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages.

You create a user account in the msdb database for the AgentPortalUser login.

You use the Database Mail Configuration Wizard to create a Database Mail profile. Security has not been configured for the Database Mail profile.

You need to ensure that AgentPortalUser can send email messages. What should you do?

  1. In the Database Mail Configuration Wizard, configure the Database Mail profile as a private profile for the AgentPortalUser account.

  2. Disable the guest user in the msdb database.

  3. Use the sysmail_help_profileaccount_sp stored procedure to add accounts to the Database Mail profile.

  4. In the Database Mail Configuration Wizard, create an email account for each recipient#39;s email address in the Database Mail profile.

Correct Answer: A

Explanation:

You enable and configure Database Mail using the Database Mail Configuration Wizard. Profiles are either public or private. A private profile is accessible only to specific users or roles.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-database-mail

Question No.57

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.

image

Correct Answer:

image

Question No.58

You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.

Users need to be able to SELECT from all tables in the database and execute the stored procedure.

You need to grant only the necessary permissions. What should you do?

  1. Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users.

  2. Grant EXECUTE permission on p_AddInventory to all users. Add all users to the db_datawriter role.

  3. Add all users to the db_owner role.

  4. Grant EXECUTE permission on p_Add!nventory to all users. Add all users to the db_datareader role.

Correct Answer: D

Question No.59

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 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 have a database named DB1 that is 640 GB and is updated frequently.

You enabled log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the disks on the data server are almost full.

You need to reduce the amount of disk space used by the log shipping process. Solution: You enable compression for the transaction log backups:

Does this meet the goal?

  1. Yes

  2. No

Correct Answer: A

Explanation:

SQL Server 2017 supports backup compression. When creating a log shipping configuration, you can control the backup compression behavior of log backups by choosing one of the following options: Use the default server setting, Compress backup, or Do not compress backup

Note:

SQL Server 2008 Enterprise and later versions support backup compression.

References:

https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/configure-log-shipping-sql- server?view=sql-server-2017

Question No.60

You plan to install Microsoft SQL Server 2016 for a web hosting company.

The company plans to host multiple web sites, each supported by a SQL Server database.

You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.

Which edition should you choose?

  1. Express Edition with Tools

  2. Standard Edition

  3. Web Edition

  4. Express Edition with Advanced Services

Correct Answer: B

Explanation:

Backup compression is supported on SQL Server 2016 editions: Enterprise, Standard, and Developer.

References:

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016

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.