New 70-764 Dumps with VCE and PDF (Mar/2019 Updated)

Favor Chaussée

Member
Member
Joined
Aug 8, 2016
Messages
40
Reaction score
9
Points
8
ATTENTION PLEASE!!! THE 70-764 EXAM UPDATED RECENTLY (Mar/2019) WITH MANY NEW QUESTIONS!!!

And, Pass Leader has updated its 70-764 dumps recently, all new questions available now!!!

412Q NEW Version!!!

You can get the newest Pass Leader 70-764 exam questions in the #14 of this thread!!!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ATTENTION PLEASE!!! THE 70-764 EXAM UPDATED RECENTLY (Oct/2018) WITH MANY NEW QUESTIONS!!!

And, Pass Leader has updated its 70-764 dumps recently, all new questions available now!!!

You can get the newest Pass Leader 70-764 exam questions in the
#15 of this topic!!!

--> #15 of this topic


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ATTENTION PLEASE!!! THE 70-764 EXAM UPDATED RECENTLY (June/2018) WITH MANY NEW QUESTIONS!!!

You can get the newest 70-764 questions in the #12 of this topics!!!

--> #12 of this topics


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ATTENTION PLEASE!!! THE 70-764 EXAM UPDATED RECENTLY (Mar/2018) WITH MANY NEW QUESTIONS!!!

You can get the newest 70-764 questions in the
#6 of this topics!!!

--> #6 of this topics


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The new June/2017 version 70-764 dumps now are available, here are part of 70-764 exam questions (FYI) [Get the VCE dumps and PDF dumps download link at the end of this post]:

NEW QUESTION 1
You manage a Microsoft SQL Server environment. You implement Transparent Data Encryption (TDE). A user will assist in managing TDE. You need to ensure that the user can view the TDE metadata while following the principle of lease privilege. Which permission should you grant?

A. DDLAdmin
B. db_datawriter
C. dbcreator
D. dbo
E. View Database State
F. View Server State
G. View Definition
H. sysadmin

Answer: G
Explanation:
Viewing the metadata involved with TDE requires the VIEW DEFINITION permission on the certificate.

NEW QUESTION 2
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?

A. DDLAdmin
B. db_datawriter
C. dbcreator
D. dbo
E. View Database State
F. View Server State
G. View Definition
H. 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.

NEW QUESTION 3
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 plan to delegate encryption operations to a user. You need to grant the user permission to implement cell-level encryption while following the principle of least privilege. Which permission should you grant?

A. DDLAdmin
B. db_datawriter
C. dbcreator
D. dbo
E. View Database State
F. View ServerState
G. View Definition
H. sysadmin

Answer: G
Explanation:
The following permissions are necessary to perform column-level encryption, or cell-level encryption:
  • CONTROL permission on the database.
  • CREATE CERTIFICATE permission on the database. Only Windows logins, SQL Server logins, and application roles can own certificates. Groups and roles cannot own certificates.
  • ALTER permission on the table.
  • Some permission on the key and must not have been denied VIEW DEFINITION permission.
NEW QUESTION 4
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts a customer database named DB1. Customers connect to hosted database instances by using line-of-business applications. Developers connect by using SQL Server Management Studio (SSMS). You need to grant the developers permission to alter views for DB1 while following the principle of least privilege. Which permission should you grant?

A. DDLAdmin
B. db_datawriter
C. dbcreator
D. dbo
E. View Database State
F. View Server State
G. View Definition
H. sysadmin

Answer: A
Explanation:
To execute ALTER VIEW, at a minimum, ALTER permission on OBJECT is required. Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

NEW QUESTION 5
You have an on-premises server that runs Microsoft SQL Server 2016 Standard Edition. You need to identify missing indexes. What should you use?

A. Activity Monitor
B. Sp_who3
C. SQL Server Management Studio (SSMS) Object Explorer
D. SQL Server Data Collector
E. SQL Server Data Tools (SSDT)
F. SQL Server Configuration Manager

Answer: D
Explanation:
Data Collector can gather performance information from multiple SQL Server instances and store it in a single repository. It has three built-in data collecting specifications (data collectors) designed to collect the most important performance metrics. The information collected by default is about disk usage, query statistics, and server activity. The Query Statistics data collection set collects information about query statistics, activity, execution plans and text on the SQL Server instance. Missing indexes can be found with the execution plans.

NEW QUESTION 6
You have a database named DB1 that stores more than 700 gigabyte (GB) of data and serves millions of requests per hour. Queries on DB1 are taking longer than normal to complete. You run the following Transact-SOL statement:
SELECT* FROM sys.database_query_store_options
You determine that the Query Store is in Read-Only mode. You need to maximize the time that the Query Store is in Read-Write mode. Which Transact-SOL statement should you run?

A. ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = ALL)
B. ALTER DATABASE DB1SET QUERY_STORE (MAX_STORAGE_SIZE_MB = SO)
C. ALTER DATABASE DB1SET QUERY_STORE (CLEANUP _POLICY = (STALE_QUERY_THRESHOLD_DAYS = 14));
D. ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = NONE)

Answer: C
Explanation:
Stale Query Threshold (Days): Time-based cleanup policy that controls the retention period of persisted runtime statistics and inactive queries. By default, Query Store is configured to keep the data for 30 days which may be unnecessarily long for your scenario. Avoid keeping historical data that you do not plan to use. This will reduce changes to read-only status. The size of Query Store data as well as the time to detect and mitigate the issue will be more predictable. Use Management Studio or the following script to configure time-based cleanup policy:
ALTER DATABASE [QueryStoreDB]
SET QUERY_STORE (CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 14));

NEW QUESTION 7
……

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

https://drive.google.com/open?id=0B-ob6L_QjGLpN3N6eHJ6Z2EzZWc

OR

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

http://www.microsoftbraindumps.com/?s=70-764

Good Luck!!!
 
Last edited:

Ali Naemi

Member
Member
Joined
Jun 24, 2017
Messages
14
Reaction score
1
Points
3
@Favor

Hi! Cool guy!!

Thanks for sharing the newest Microsoft 70-764 exam questions!

And, would you like to share that FULL VERSION forbiden 70-764 dumps in VCE or PDF?

I am going to take my 70-764 exam soon, and ONLY found that forbiden offer the newest 70-764 dumps.

Please PM me!

Thanks in advance!!!
 

Zikhona

Member
Member
Joined
Jul 4, 2017
Messages
1
Reaction score
0
Points
1
Hi Guys,

Ali did you get the newest Microsoft 70-764 exam questions?
 

Favor Chaussée

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

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

Exam A


NEW QUESTION 71
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?

A. Create SSIS configuration files for the packages.
B. Create an Integration Services catalog.
C. Install Data Quality Services.
D. Install Master Data services.

Answer: B

NEW QUESTION 72
You administer a Microsoft SQL Server 2016 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to send the email messages. What should you configure?

A. SQL Mail
B. An Extended Events session
C. Alerts and operators in SQL Server Agent
D. Policies under Policy-Based Management

Answer: C

NEW QUESTION 73
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?

A. Use the Data Quality Client to configure the application.
B. Start the SQL Server Browser Service.
C. Use the Master Data Services Configuration Manager to configure the application.
D. Start the SQL Server Integration Services Service.

Answer: B

NEW QUESTION 74
You administer a Microsoft SQL Server 2016 database. Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error. You need to identify the root cause of the issue by retrieving the error message. What should you do?

A. Create an Extended Events session by using the sqlserver.error_reported event.
B. Create a SQL Profiler session to capture all ErrorLog and EventLog events.
C. Flag all stored procedures for recompilation by using sp_recompile.
D. Execute sp_who.

Answer: A

NEW QUESTION 75
......

Exam B

Case Study 1: Litware, Inc. (Question 40 - Question 49)

Case Study 2: Contoso, Ltd. (Question 50 - Question 61)

Case Study 3: A. Datum (Question 62 - Question 75)

Case Study 4: Fairstone Manufacturing Inc. (Question 76 - Question 80)

Case Study 5: Leafield Solutions (Question 81 - Question 87)

Case Study 6: Fabrikam, Inc. (Question 140 - Question 151)

NEW QUESTION 152
Which feature should you enable and configure so session requests addressed to a specific instance can be allocated to different processor resources based on session request properties?

A. Resource Governor
B. Windows System Resource Manager
C. Processor affinity
D. I/O affinity

Answer: C

NEW QUESTION 154
You are using dynamic management views to monitor an SQL Server server named SQL1. A database administrator named Dba1 must monitor the health of SQL1. You need to ensure that Dba1 can access dynamic management views for SQL1. The solution must use the principle of least privilege. Which permissions should you assign to Dba1?

A. VIEW ANY DEFINITION
B. VIEW SERVER STATE
C. VIEW DEFINITION
D. CONTROL SERVER

Answer: B
Explanation:
To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission.

NEW QUESTION 163
You have a data warehouse that stored sales data. One fact table has 100 million rows. You must reduce storage needs for the data warehouse. You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.
Solution: You generate a new certificate on new instance.
Does the solution meet the goal?

A. Yes
B. No

Answer: B
Explanation:
Certificates are of no use in this scenario.

NEW QUESTION 170
You have a server named Server1 that has Microsoft SQL Server installed. Server1 has SQL Server Adult configured to send audit even records to a file. You need to ensure that a database user named User1 can review the audit data.
Solution: You assign the db_datareader role to User1.
Does this meet the goal?

A. Yes
B. No

Answer: B
Explanation:
Each feature and command for SQL Server Audit has individual permission requirements. To create, alter, or drop a Server Audit or Server Audit Specification, server principals require the ALTER ANY SERVER AUDIT or the CONTROL SERVER permission. To create, alter, or drop a Database Audit Specification, database principals require the ALTER ANY DATABASE AUDIT permission or the ALTER or CONTROL permission on the database. In addition, principals must have permission to connect to the database, or ALTER ANY SERVER AUDIT or CONTROL SERVER permissions. Unless otherwise specified, viewing catalog views requires a principal to have one of the following:
  • Membership in the sysadmin fixed server role.
  • The CONTROL SERVER permission.
  • The VIEW SERVER STATE permission.
  • The ALTER ANY AUDIT permission.
  • The VIEW AUDIT STATE permission (gives only the principal access to the sys.server_audits catalog view).
A principal must have the VIEW SERVER STATE or ALTER ANY AUDIT permission to use the Dynamic Management Views.

NEW QUESTION 172
You have a Microsoft Azure SQL database that has Blob Auditing configured. You need to review the audit logs.
Solution: You download the log files by using Microsoft Azure Storage Explorer, and then you open the files by using Microsoft SQL Server Management Studio (SSMS).
Does this meet the goal?

A. Yes
B. No

Answer: A

NEW QUESTION 180
You manage a Microsoft SQL Server environment. You plan to configure Database Mail. You need to ensure that all users can access a private Database Mail profile. What should you do?

A. On the tempdb database, add the DatabaseMailUserRole to user id 0.
B. On the msdb database, add the DatabaseMailUserRole to the public user.
C. On the master database, add the DatabaseMailUserRole to the public user.
D. On the profile, grant access to the public user.

Answer: B
Explanation:
For each private profile, Database Mail maintains a list of users that are permitted to send e-mail using that profile. Public profiles are available to users or roles in the msdb database who are also members of the DatabaseMailUserRole. By default, a profile is private, and no users are granted access to the profile. To make the profile public, grant access to the user 'public' or the user id 0.
Note:
Profiles are either public or private. A private profile is accessible only to specific users or roles. A public profile allows any user or role with access to the mail host database to send e-mail using that profile.

NEW QUESTION 181
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases. A customer that uses an on-premises instance reports that queries take a long time to complete. You need to reconfigure table statistics so that the query optimizer can use the optimal query execution plans available. Which Transact-SQL segment should you use?

A. sp_autostats
B. AUTO_UPDATE_STATISTICS_ASYNC
C. SET AUTO_UPDATE_STATISTICS ON
D. CREATE STATISTICS

Answer: C
Explanation:
You can turn on automatic statistics update by running this SQL statement:
SET AUTO_UPDATE_STATISTICS ON
Incorrect:
Not A: sp_autostats without options just displays the settings.
Not B: The AUTO_UPDATE_STATISTICS_ASYNC option affects how automatic statistics updates are applied to your SQL Server database. When this option is enabled, the Query Optimizer will not wait for the update of statistics, but will run the query first and update the outdated statistics afterwards. When this option is disabled, the Query Optimizer will update the outdated statistics before compiling the query therefore possibly getting a better plan based on the most current statistics. This is referred to as synchronous statistics updates.

NEW QUESTION 182
......

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

https://drive.google.com/open?id=0B-ob6L_QjGLpN3N6eHJ6Z2EzZWc

OR

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

http://www.microsoftbraindumps.com/?s=70-764

Good Luck!!!
 
Last edited:

AbbasHussain

Member
Member
Joined
Mar 7, 2018
Messages
13
Reaction score
0
Points
1
Great!

Thanks for sharing.

Please upload that premium forbiden 70-764 dumps with PDF and VCE files.

Thanks a lot.
 

ReneMoeller

Member
Member
Joined
Mar 6, 2018
Messages
11
Reaction score
0
Points
1
Please upload the full version forbiden 70-764 dumps!!!

My 70-764 exam ~~~ next month.

Thanks all!
 

Favor Chaussée

Member
Member
Joined
Aug 8, 2016
Messages
40
Reaction score
9
Points
8
The new 70-764 dumps (June/2018 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 301
You have a data warehouse that stores sales data. One fact table has 100 million rows. You must reduce storage needs for the data warehouse. You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.
Solution: You remove any clustered indexes and load the table for processing.
Does the solution meet the goal?

A. Yes
B. No

Answer: B
Explanation:
Clustered columnstore tables offer both the highest level of data compression as well as the best overall query performance. Clustered columnstore tables will generally outperform clustered index or heap tables and are usually the best choice for large tables. For these reasons, clustered columnstore is the best place to start when you are unsure of how to index your table.

NEW QUESTION 304
You are migrating a set of databases from an existing Microsoft SQL Server instance to a new instance. You need to complete the migration while minimizing administrative effort and downtime. Which should you implement?

A. log shipping
B. an Always On Availability Group with all replicas in synchronous-commit mode
C. a file share witness
D. a SQL Server failover cluster instance (FCI)
E. a Windows Cluster with a shared-nothing architecture
F. an Always On Availability Group with secondary replicas in asynchronous-commit mode

Answer: A
Explanation:
SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually.

NEW QUESTION 308
You manage a Microsoft SQL Server environment. You plan to encrypt data when you create backups. You need to configure the encryption options for backups. What should you configure?

A. a certificate
B. an MD5 hash
C. an SHA-256 hash
D. an AES 256-bit key

Answer: D
Explanation:
To encrypt a backup we need to configure an encryption algorithm (supported encryption algorithms are: AES 128, AES 192, AES 256, and Triple DES) and an encryptor (a certificate or asymmetric key).

NEW QUESTION 309
A company has an on-premises Microsoft SQL Server environment. SQL Server backups should be stored as Microsoft Azure blob pages. The connection process from the SQL Server instances to Azure should be encrypted. You need to store backups as Azure blob pages. 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. The retention settings determine how long the backups are stored in Azure Blob storage.

NEW QUESTION 314
You have an application that queries a database. Users report that the application is slower than expected. You discover that several server process identifiers (SPIDs) have PAGELATCH_UP and PAGELATCH_EX waits. The resource descriptions of the SPIDs contains 2:1:1. You need to resolve the issue. What should you do?

A. Allocate additional processor cores to the server.
B. Add files to the file group of the application database.
C. Reduce the fill factor of all clustered indexes.
D. Add data files to tempdb.

Answer: D
Explanation:
PAGELATCH contention in tempdb is typically on allocation bitmaps and occurs with workloads with many concurrent connections creating and dropping small temporary tables (which are stored in tempdb). Assuming that the temporary tables are needed for performance, the trick is to have multiple data files for tempdb so that the allocations are done round-robin among the files, the contention is split over multiple PFS pages, and so the overall contention goes down.

NEW QUESTION 315
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases. A customer that uses an on-premises instance reports that queries take a long time to complete. You need to reconfigure table statistics so that the query optimizer can use the optimal query execution plans available. Which Transact-SQL segment should you use?

A. sys.index_columns
B. UPDATE STATISTICS
C. CREATE STATISTICS
D. SET AUTO_CREATE_STATISTICS ON

Answer: D

NEW QUESTION 316
Hotspot
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environments host several customer databases. You configure an Always On Availability Group for a customer. You must create log reports for the customer that detail when the log is flushed to disk on the primary and secondary replica. You need to develop a report containing the requested information. In the table below, identify the log type that you should use for each replica. (NOTE: Make only one selection in each column. Each correct selection is worth one point.)

Answer:
Explanation:
-- Flush on primary: Log flush
Log flush. Log data is generated and flushed to disk on the primary replica in preparation for replication to the secondary replica. It then enters the send queue.
-- Flush on secondary: Log hardened
The log is flushed on the secondary replica, and then a notification is sent to the primary replica to acknowledge completion of the transaction.
Incorrect:
-- Not Log capture
Log capture. Logs for each database are captured on the primary replica, compressed, and sent to the corresponding queue on the secondary replica. This process runs continuously as long as database replicas are connecting. If this process is not able to scan and enqueue the messages quickly enough, the log send queue continues to grow.
-- Not Log receive/Log cache
Log receive/Log cache. Each secondary replica gets messages from the primary replica and then caches the messages.

NEW QUESTION 317
Drag and Drop
You are designing a high availability (HA) environment for a company that has three office locations. Details of the services deployed at each office are shown in the table below:
You need to maximize availability, minimize data loss, and minimize downtime in the event of a failure. Which solution should you implement for each location? (To answer, drag the appropriate solutions to the correct locations. Each solution 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.)

Answer:
Explanation:
The Always On availability groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.

NEW QUESTION 318
......

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

https://drive.google.com/open?id=0B-ob6L_QjGLpN3N6eHJ6Z2EzZWc

OR

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

http://www.microsoftbraindumps.com/?s=70-764

Good Luck!!!
 
Last edited:

Favor Chaussée

Member
Member
Joined
Aug 8, 2016
Messages
40
Reaction score
9
Points
8
The new 70-764 dumps (Oct/2018 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 369
You are examining information about users, sessions, and processes in an on-premises Microsoft SQL Server 2016 Standard Edition server. You need to identify waits for resources and return only the following information:
  • A list of all databases on the SQL Server instance, along with information about the database files, their paths, and names.
  • A list of the queries recently executed that use most of memory, disk, and network resources.
What should you use?

A. Activity Monitor
B. sp_who3 stored procedure
C. Object Explorer in SQL Server Management Studio (SSMS)
D. SQL Server Data Collector
E. SQL Server Data Tools (SSDT)

Answer: C

NEW QUESTION 370
You plan to implement a fault tolerance solution for a Microsoft SQL Server database. The solution must provide failover storage on the local network. You need to ensure that the solution can route traffic to failover storage by using SMB 3.0. Which storage option should you use?

A. Cluster Shared Volumes
B. Microsoft Azure Blob storage
C. Always On availability group
D. Stretch Database

Answer: B

NEW QUESTION 371
You maintain a database named DB1 that has a nonpartitioned table. You create an index in the table. Automatic statistics updates are disabled. Users report that some Microsoft SQL Server Reporting Service (SSRS) queries take a long time to run. You determine that the issue is caused by stale statistics for Index1. You need to update the statistics for the index. What should you do?

A. Set the value of the Database Read-Only property to True.
B. Run the system stored procedure sp_updatestats.
C. Set the value of the Auto Create Incremental Statistics property to True.
D. Run the UPDATE STATISTICS command with the COLUMNS option.

Answer: D

NEW QUESTION 372
You have a table that has grown in the past six months. A user reports that queries against the table take a long time to complete. You need to update the statistics for the table in the least amount of time without disabling automatic statistics updates. Which Transact-SQL statement should you run?

A. UPDATE STATISTICS WITH RESAMPLE
B. UPDATE STATISTICS WITH FULLSCAN
C. UPDATE STATISTICS WITH SAMPLE 10 PERCENT
D. UPDATE STATISTICS WITH NORECOMPUTE

Answer: C

NEW QUESTION 373
You have five servers that run Microsoft SQL Server, Each server hosts multiple databases. You plan to implement fault tolerance. You need lo implement a fault tolerance solution that meets the following requirements:
  • Each database must use a separate fault tolerance configuration.
  • The solution must support three or more copies of each database.
  • Failover of database must be automatic.
What should you do use?

A. Always On availability groups
B. database mirroring
C. transactional replication
D. log shipping

Answer: B

NEW QUESTION 374
You have a Microsoft SQL Server instance that has database named DBI. The database is used purposes,. You plan to capture all queries for a specific table and save the data as a text file. You need to ensure that queries are captured and that a failure to capture a query will shut the SQL Server instance. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A. Enable SQL Server Audit.
B. Use Extended Events.
C. Use a logon trigger.
D. Create a SQL Server profile trace disable c2 audit tracing.
E. Enable SQL Server Query Store.

Answer: DE

NEW QUESTION 375
Your company has several Microsoft SQL Saver instance. Each instance hosts many database. You observe I/O corruption on some of the instance. You need to perform the following actions:
  • Identify databases where the PAGE verity option is not set.
  • Configure full page protection for the identified databases.
Solution: You run the following Transact-SQL statement:
SELECT NAME, page_verify_option_desc
FROM master.sys.databases
WHERE page_verify_option_desc != ‘CHECKSUM’
GO

For each database that you identify, you run the following Transact SQL statement:
ALTER DATABASE <database_name>
SET PAGE_VERIFT CHECKSUM

Does the solution meet the goal?

A. Yes
B. No

Answer: A

NEW QUESTION 376
Your company has several Microsoft SOI Server instances. Each instance hosts many databases. You observe I/O corruption on some of the instances. You need to perform the following actions:
  • 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:
SELECT NAME, page_verify_option_desc
FROM master.sys.databases
WHERE page_verify_option_desc != ‘TORN_PAGE_DETECTION’
GO

For each database that you identify, you run the following Transact-SQL statement:
ALTER DATABASE <database_name>
SET PAGE_VERIFT TORN_PAGE_DETECTION

Does the solution meet the goal?

A. Yes
B. No

Answer: B

NEW QUESTION 377
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:
  • 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:
SELECT NAME, page_verify_option_desc
FROM master.sys.databases
WHERE page_verify_option_desc = ‘NONE’
GO

For each database that you identify, you run the following Transact-SQL statement:
ALTER DATABASE <database_name>
SET PAGE_VERIFT TORN_PAGE_DETECTION

Does the solution meet the goal?

A. Yes
B. No

Answer: B

NEW QUESTION 378
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 configure log shipping to backup and restore by using shared folder.
Does this meet the goal?

A. Yes
B. No

Answer: B

NEW QUESTION 379
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?

A. Yes
B. No

Answer: A

NEW QUESTION 380
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 increase the frequency of the transaction log backups to every 10 minutes.
Does this meet the goal?

A. Yes
B. No

Answer: B

NEW QUESTION 381
......

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

https://drive.google.com/open?id=0B-ob6L_QjGLpN3N6eHJ6Z2EzZWc

OR

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

http://www.microsoftbraindumps.com/?s=70-764

Good Luck!!!
 
Last edited:

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!!!
 

joneschery

Member
Member
Joined
Mar 19, 2019
Messages
4
Reaction score
0
Points
1
many website that provide Microsoft 70-764 Exam practice materials, but i will recommend you exams4success. 100% Success Opt Now - Pass Microsoft 70-764 exam questions in first attempt with 100% success guarantee. Get 100% Real Microsoft 70-764 Exam Questions, Accurate & Verified Answers As Seen in the Real 70-764 Microsoft Administering a SQL Database Infrastructure exam. Our PDF Microsoft 70-764 exam dumps have been designed and verified by the Microsoft experts after an indepth analysis of vendor recommended preparation syllabus. Now Download a free demo of our Microsoft 70-764 exam product and test its various quality features and usability before purchase. We trust in our Microsoft 70-764 exam product, that’s why we offer you 100% refund policy, in case of failure. Visit Now And Get 25% Discount (Coupon Code: E4S25%) - https://www.exams4success.com/Microsoft/70-764-pdf-exam-dumps
 

EllaLucy

Member
Member
Joined
Mar 19, 2019
Messages
6
Reaction score
0
Points
1
I downloaded 70-764 Dumps for my preparation which proved to be very useful and fruitful for me. I think the experts on Realexamdumps.com have done really a great work and deserve appreciation and respect for all their services. The questions and answers were really to-the-point and relevant which gave me knowledge about every aspect of the subject. There was hardly any question in the final which made me think a while before I answer. I give full out of full stars to 70-764 Dumps PDF if I have to rate it.
1178
 

Latest posts

Top