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 (332 Q&As Dumps –> 365 Q&As Dumps –> 388 Q&As Dumps –> 412 Q&As Dumps)
BTW, DOWNLOAD part of PassLeader 70-764 dumps from Cloud Storage: https://drive.google.com/open?id=0B-ob6L_QjGLpN3N6eHJ6Z2EzZWc
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.
https://msdn.microsoft.com/en-us/library/ms188754.aspx
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.
https://technet.microsoft.com/en-us/library/cc280665(v=sql.105).aspx
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
Explanation:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing
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.
https://technet.microsoft.com/en-us/library/ms189879(v=sql.105).aspx
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.
https://www.mssqltips.com/sqlservertip/2766/sql-server-auto-update-and-auto-create-statistics-options/
NEW QUESTION 182
……
Get the newest PassLeader 70-764 VCE dumps here: https://www.passleader.com/70-764.html (332 Q&As Dumps –> 365 Q&As Dumps –> 388 Q&As Dumps –> 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