Valid 70-764 Dumps shared by PassLeader for Helping Passing 70-764 Exam! PassLeader now offer the newest 70-764 VCE dumps and 70-764 PDF dumps, the PassLeader 70-764 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader 70-764 dumps with VCE and PDF here: https://www.passleader.com/70-764.html (412 Q&As Dumps)
BTW, DOWNLOAD part of PassLeader 70-764 dumps from Cloud Storage: https://drive.google.com/open?id=0B-ob6L_QjGLpN3N6eHJ6Z2EzZWc
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
Explanation:
C: The Log Shipping Report displays the status of any log shipping activity whose status is available from the server instance to which you are connected.
E: The history and status of the backup operation are stored at the primary server, and the history and status of the copy and restore operations are stored at the secondary server.
The log_shipping_monitor_error_detail table stores error details for log shipping jobs. You can query this table see the errors for an agent session. Optionally, you can sort the errors by the date and time at which each was logged. Each error is logged as a sequence of exceptions, and multiple errors (sequences) can per agent session.
https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/view-the-log-shipping-report-sql-server-management-studio?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/monitor-log-shipping-transact-sql
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
Explanation:
SQL Server Managed Backup to Microsoft Azure manages and automates SQL Server backups to Microsoft Azure Blob storage. You can choose to allow SQL Server to determine the backup schedule based on the transaction workload of your database. Or you can use advanced options to define a schedule.
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-managed-backup-to-microsoft-azure
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
Explanation:
A: The history and status of the backup operation are stored at the primary server, and the history and status of the copy and restore operations are stored at the secondary server, log_shipping_monitor_secondary stores one monitor record for each secondary database, including information about the last backup file and last restored file that is useful for monitoring.
B: The Log Shipping Report displays the status of any log shipping activity whose status is available from the server instance to which you are connected.
https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/view-the-log-shipping-report-sql-server-management-studio?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/monitor-log-shipping-transact-sql
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
Explanation:
The sys.dm_db_index_usage_stats returns counts of different types of index operations and the time each type of operation was last performed. The user_updates counter indicates the level of maintenance on the index caused by insert, update, or delete operations on the underlying table or view. You can use this view to determine which indexes are used only lightly by your applications. You can also use the view to determine which indexes are incurring maintenance overhead. You may want to consider dropping indexes that incur maintenance overhead, but are not used for queries, or are only infrequently used for queries.
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql
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
Explanation:
Asynchronous_commit mode is a disaster-recovery solution that works well when the availability replicas are distributed over considerable distances. If every secondary replica is running under asynchronous-commit mode, the primary replica does not wait for any of the secondary replicas to harden the log. Rather, immediately after writing the log record to the local log file, the primary replica sends the transaction confirmation to the client. The primary replica runs with minimum transaction latency in relation to a secondary replica that is configured for asynchronous_commit mode. If the current primary is configured for asynchronous commit availability mode, it will commit transactions asynchronously for all secondary replicas regardless of their individual availability mode settings.
Incorrect:
Not B: Synchronous_commit mode emphasizes high availability over performance, at the cost of increased transaction latency.
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups
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
Explanation:
Use the following steps to recover from an irreparable failure. The failure could be caused, for example, by the failure of a disk controller or the operating system. In this case, failure is caused by hardware failure in Node 1 of a two-node cluster.
……
https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/recover-from-failover-cluster-instance-failure
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
Explanation:
You should compress the transaction log backups.
https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/configure-log-shipping-sql-server?view=sql-server-2017
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
Explanation:
You should compress the transaction log backups.
https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/configure-log-shipping-sql-server?view=sql-server-2017
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
Explanation:
To add records you would the INSERT permission.
https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql
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:
Explanation:
Step 1: Create a Windows Server Failover Clustering (WSFC) cluster with AO-AG1 and AO-AG2 as nodes. Since AlwaysOn Availability Groups require a Windows Server Failover Cluster, we first need to add the Windows Failover Cluster Feature to all the machines running the SQL Server instances that we will configure as replicas.
Step 2: Configure a secondary replica. In the Specify Replicas page, under the Replicas tab, click the Add Replicas button and connect to the other SQL Server instances that you joined as nodes in your Windows Server Failover Cluster.
Step 3: Create an Always On Availability Group and select the availability databases. Once the Windows Server Failover Cluster has been created, we can now proceed with enabling the AlwaysOn Availability Groups feature in SQL Server 2012. This needs to be done on all of the SQL Server instances that you will configure as replicas in your Availability Group.
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:
Explanation:
Use the ALTER DATABASE statement to enable the query store. For example: ALTER DATABASE AdventureWorks2012 SET QUERY_STORE = ON. The SQL Server Query Store feature provides you with insight on query plan choice and performance. It simplifies performance troubleshooting by helping you quickly find performance differences caused by query plan changes. Query Store automatically captures a history of queries, plans, and runtime statistics, and retains these for your review.
https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store
NEW QUESTION 411
……
Get the newest PassLeader 70-764 VCE dumps here: https://www.passleader.com/70-764.html (412 Q&As Dumps)
And, DOWNLOAD the newest PassLeader 70-764 PDF dumps from Cloud Storage for free: https://drive.google.com/open?id=0B-ob6L_QjGLpN3N6eHJ6Z2EzZWc