Favor Chaussée

Member
Member
Joined
Aug 8, 2016
Messages
40
Reaction score
9
Points
8
The new 70-764 dumps (Mar/2019 Updated) now are available, here are part of 70-764 exam questions (FYI):

[Get the download link at the end of this post]


NEW QUESTION 400
You maintain Microsoft SQL Server instances named SVR1 and SVR2 that are hosted on two different servers. You configure log shipping between the two instances as follows:
  • DB1 on SVR1 is configured as the primary database.
  • DB1 on SVR2 is configured as the secondary database for DB1 on SVR1.
  • No monitoring server is configured.
You need to monitor error log messages about the copy job. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A. On SVR1, run the following Transact-SQL statement:
SELECT * FROM msdb.dbo.log_shipping_monitor_error_detail
B. Use the job Activity Monitor in SQL Server Management Studio by connecting to SVR1.
C. View the Log Shipping Report in SQL Server Management Studio by connecting to SVR1.
D. Use the Job Activity Monitor in SQL Server Management Studio by connecting to SVR2.
E. On SVR2, run the following Transact-SQL statement:
SELECT * FROM msdb.dbo.log_shipping_monitor_error_detail

Answer: CE

NEW QUESTION 401
A company is deploying a Microsoft SQL Server environment in Microsoft Azure. Backups need to be performed and managed automatically. You need to configure the SQL Server backup. Which option should you use?

A. backup compression
B. backup encryption
C. file snapshot backup
D. mirrored backup media sets
E. SQL Server backup to URL
F. SQL Server Managed Backup to Azure
G. tail-log backup
H. back up and truncate the transaction log

Answer: F

NEW QUESTION 402
You configure log shipping on two servers named SQL1 and SQL2 is in Standby mode. You configure backup and restore to occur every hour. A user generates a report from SQL2 and discovers that the report data is out-of-date. You verify that the report data is a day old and discover that the primary backup files are available only on SQL1. You need to identify what prevents the primary backup files from being available on SQL2. Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)

A. From SQL2, execute the SP_log_shipping_monitor_secondary system stored procedure.
B. From Microsoft SQL Server Management Studio on SQL1, run the Transaction Log Shipping Status report.
C. From Microsoft SQL Server Management Studio on SQL2, run the Transaction Log Shipping Status report.
D. From SQL1, review the SQL Server Agent job history log.
E. From SQL1, execute the SP_log_shipping_monitor_secondary system stored procedure.

Answer: AB

NEW QUESTION 403
You have a database named Saleshistory that records sales transactions for your organization. You create indexes in the database. The database has grown over time and now contains hundreds of indexes. You need to identify the indexes that are not being used. Which dynamic management object should you use?

A. sys.dm_os_sys_info
B. sys.dm_db_index_usage_stats
C. sys.dm_db_index_operational_stats
D. sys.dm_db_stats_properties

Answer: B

NEW QUESTION 404
You have the following Microsoft SQL Server instances:

You have a database named DB1 that is hosted on SQL1. Users in the branch office must be able to access DB1 from SQL3. You need to configure an AlwaysOn Availability Group and limit latency on the secondary server. Which settings should you configure?

A. FAILOVER_MODE = AUTOMATIC
B. AVAILABILITY MODE = SYNCHRONOUS_COMMIT
C. FAILOVER_MODE = MANUAL
D. AVAILABILITY MODE = ASYNCHRONOUS_COMMIT

Answer: D

NEW QUESTION 405
You are a database administrator for Contoso, Ltd. You configure a Microsoft SQL Server failover cluster with four nodes by using Windows Server 2012 R2 Datacenter Edition and SQL Server 2016 Enterprise edition. A server in the datacenter needs to be replaced. The server is part of the SQL Server Failover Instance (FCI). You need to remove the FCI node for the server that will be replaced. What should you do?

A. Evict the node from Failover Cluster Manager.
B. Run the Remove-ClusterResource Windows PowerShell cmdlet.
C. Run the Remove-Cluster Windows PowerShell cmdlet.
D. Remove the shared storage from Failover Cluster Manager.

Answer: A

NEW QUESTION 406
You have a database named DB1 that is 640 GB and is updated frequently. You enable log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the hard disks on the database server are almost full. You need to reduce the amount of disk space used by the log shipping process.
Solution: You configure log shipping to backup and restore by using a single shared folder.
Does this meet the goal?

A. Yes
B. No

Answer: B

NEW QUESTION 407
You have a database named DB1 that is 640 GB and is updated frequently. You enable log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the hard disks on the database server are almost full. You need to reduce the amount of disk space used by the log shipping process.
Solution: You reduce the frequency of the transaction log backups to once per hour.
Does this meet the goal?

A. Yes
B. No

Answer: B

NEW QUESTION 408
You are a database administrator for an organization. You must allow the members of the human resources department to add new employee records to the HR.Employees table. All members of the human resources department are assigned the HumanResources database only. You need to ensure that members of the human resources department can add records to the table. Which Transact-SQL statement should you run?

A. GRANT INSERT ON HR.Employees to HumanResources
B. GRANT UPDATE ON HR.Employees to HumanResources
C. GRANT REFERENCES ON SCHEMA :: HR to HumanResources
D. GRANT ALTER ON HR.Employees to HumanResources

Answer: A

NEW QUESTION 409
Drag and Drop
You administer two servers AO-AG1 and AO-AG2. Microsoft SQL Server 2016 Enterprise Edition is running on both servers. You need to configure a new Microsoft SQL Server Always On Availability Group. Which three actions should you perform? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)


Answer:


NEW QUESTION 410
Hotspot
You manage a Microsoft SQL Server environment with a database named DB1. You notice that queries take longer to complete than they did a year ago. You increase the file size for the database named tempdb, but it does not resolve the problem. You need to capture runtime statistics for all queries. How should you complete the Transact-SQL statement? (To answer, configure the appropriate Transact-SQL segments in the answer area.)


Answer:


NEW QUESTION 411
......

Download more NEW Pass Leader 70-764 PDF dumps from Google Drive here:


OR

Read the newest Pass Leader 70-764 exam questions from this Blog:


Good Luck!!!
 
Top