70-764 Dumps & Test Certification 70-764 Cost - Christmas Offer
                     Microsoft
70-764
https://www.realexamcollection.com/mAicdromsoifnt/7is0t-7e6r4i-ndgum ap sS.hQtmLl
Practice Test Microsoft - 70-764
Topic 1, Exam Pool A
Question #:1 - (Exam Topic 1)
You are the administrator of a Microsoft SQL Server 2016 server. Some applications consume significant
resources.
You need to manage the server workload by restricting resource-intensive applications.
You need to dynamically limit resource consumption.
What should you do?
A.  Set up Service Broker to ensure that applications are not allowed to consume more than the specified
amount of resources.
B.  Configure Resource Pools, Workload Groups, and Classifier Function, and then enable the Resource
Governor.
C.  Configure Extended Events to monitor and restrict resource limits allowed by each application type.
D.  Create a new Plan Guide with a Scope Type of sql and define the resource limits for each application.
Answer: B
Question #:2 - (Exam Topic 1)
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 the stated 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 need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by
using Database Mail.
Solution: You add the DatabaseMailUserRole to Mail1 in the master database.
Does the solution meet the goal?
A.  Yes
B.  No
Answer: B
2 of 23
Practice Test Microsoft - 70-764
Explanation
Database Mail is guarded by the database role DatabaseMailUserRole in the msdb database, not the master
database, in order to prevent anyone from sending arbitrary emails. Database users or roles must be created in
the msdb database and must also be a member of DatabaseMailUserRole in order to send emails with the
exception of sysadmin who has all privileges.
Note: Database Mail was first introduced as a new feature in SQL Server 2005 and replaces the SQL Mail
feature found in previous versions.
References:
http://www.idevelopment.info/data/SQLServer/DBA_tips/Database_Administration/DBA_20.shtml
Question #:3 - (Exam Topic 1)
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.
3 of 23
Practice Test Microsoft - 70-764
You need to configure auditing for the Adventure Works environment.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the
answer area.
NOTE: Each correct selection is worth one point.
4 of 23
Practice Test Microsoft - 70-764
Answer:
5 of 23
Practice Test Microsoft - 70-764
Explanation
6 of 23
Practice Test Microsoft - 70-764
Box 1: CREATE SERVER AUDIT
Create the server audit.
You must implement auditing to record access to data that is considered sensitive by the company.
Create database audit
Box 2: ALTER SERVER AUDIT
Enable the server audit.
7 of 23
Practice Test Microsoft - 70-764
Box 3: CREATE DATABASE AUDIT
Create the database audit specification.
Box 4: FOR SERVER AUDIIT
You must implement auditing for all objects in the ADVSchema.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-database-audit-specification
8 of 23
Practice Test Microsoft - 70-764
Topic 3, Exam Pool C
Question #:4 - (Exam Topic 3)
You have a SQL Server 2012 database named DB1.
You have a backup device named Device1.
You discover that the log file for the database is full.
You need to ensure that DB1 can complete transactions.
The solution must not affect the chain of log sequence numbers (LSNs).
Which code segment should you execute?
A.  BACKUP LCG DB1 TO Device1 WITH COPY_ONLY
B.  BACKUP LOG DB1 TO Device1
C.  BACKUP LOG DB1 TO Device1 WITH NCRECCVERY
D.  BACKUP LOG D31 TO Device1 WITH TRUNCATE ONLY
Answer: B
Explanation
References:
http://msdn.microsoft.com/en-us/library/ms186865.aspx
http://msdn.microsoft.com/en-us/library/ms179478.aspx
http://msdn.microsoft.com/en-us/library/ms190925.aspx
Question #:5 - (Exam Topic 3)
You are designing two stored procedures named Procedure1 and Procedure2. You identify the following
requirements:
Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored
procedure.
Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
9 of 23
Practice Test Microsoft - 70-764
Which technologies should you identify? To answer, drag the appropriate technology to the correct stored
procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)
Answer:
Explanation
Procedure 1 - A table-valued parameter (TVP);
Procedure 2 - Common language runtime (CLR)
References:
http://msdn.microsoft.com/en-us/library/ms131102.aspx
http://msdn.microsoft.com/en-us/library/bb522446.aspx
http://msdn.microsoft.com/en-us/library/bb510489.aspx
Question #:6 - (Exam Topic 3)
Overview
General Overview
ADatum Corporation has offices in Miami and Montreal.
The network contains a single Active Directory forest named adatum.com. The offices connect to each other
by using a WAN link that has 5-ms latency. A. Datum standardizes its database platform by using SQL Server
2014 Enterprise edition.
Databases
https://www.realexamcollection.com/microsoft/70-764-dumps.html
10 of 23