Lead2pass 70-764 Exam Questions Guarantee 70-764 Certification Exam 100% Success:

https://www.lead2pass.com/70-764.html

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

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

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

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

QUESTION 75
You administer a Microsoft SQL Server 2016 instance that contains a financial database hosted on a storage area network (SAN).
The financial database has the following characteristics:

– A data file of 2 terabytes is located on a dedicated LUN (drive D).
– A transaction log of 10 GB is located on a dedicated LUN (drive E).
– Drive D has 1 terabyte of free disk space.
– Drive E has 5 GB of free disk space.

The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours.
Five percent of the existing data is modified each day. The Finance department loads large CSV files into a number of tables each business day at
11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands.
Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours.
Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.
You implement log shipping of the financial database to another SQL Server 2016 instance.
You decide to failover to this secondary database.
You need to ensure that all transactions will be replicated to the secondary database.
Which backup option should you use?

A.    Differential
B.    Transaction Log
C.    FULL
D.    SIMPLE
E.    SKIP
F.    RESTART
G.    STANDBY
H.    CHECKSUM
I.    DBO_ONLY
J.    COPY_ONLY
K.    NORECOVERY
L.    NO_CHECKSUM
M.    CONTINUE_AFTER_ERROR
N.    BULK_LOGGED

Answer: K

QUESTION 76
You use Microsoft SQL Server 2016 to write code for a transaction that contains several statements.
There is high contention between readers and writers on several tables used by your transaction.
You need to minimize the use of the tempdb space.
You also need to prevent reading queries from blocking writing queries.
Which isolation level should you use?

A.    SERIALIZABLE
B.    SNAPSHOT
C.    READ COMMITTED SNAPSHOT
D.    REPEATABLE READ

Answer: B

QUESTION 77
You plan to migrate the db to azure.
You verify that all objects are valid for azure sql database.
You need to ensure that users and logins are migrated to azure..
What should you do?

A.    Use the Copy Database wizard
B.    Use the Database Transfer wizard
C.    Use the SQL Management Studio to deploy the db to azure
D.    Back up the databasae from the local server and restore it to azure

Answer: CD

QUESTION 78
You create a new user named UserA.
You need to ensure that UserA is able to create SQL Server Agent jobs and to execute SQL Server Agent jobs.
To which role should you add UserA?

A.    Securityadmin
B.    RSExecRole
C.    SQLAgentUserRole
D.    DatabaseMailUserRole

Answer: C

QUESTION 79
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 80
You administer a Microsoft SQL Server 2016 database that includes a table named dbo.Log.
This table contains millions of records about user activity in an application. Records in dbo.Log that are more than 90 days old are purged nightly.
When records are purged, table locks are causing contention withinserts.
You need to be able to modify dbo.Log without requiring any changes to the applications that utilize dbo.Log.
Which type of solution should you use?

A.    Extended events
B.    Columnstore index
C.    Partitioned tables
D.    Read committed snapshot

Answer: C

70-764 dumps full version (PDF&VCE): https://www.lead2pass.com/70-764.html

Large amount of free 70-764 exam questions on Google Drive: https://drive.google.com/open?id=0B3Syig5i8gpDUjBoM0pVQnlUTlU

You may also need:

70-761 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDU2RSQnhzX2pIZVE

70-762 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDMW9NcjJrQXlsMGs

70-765 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDejczeWp0aURaSnM

70-767 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDdTF0R0taLWgxSmc

70-768 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDZ2pRQkV6Vnc4dHc