[PDF and VCE] CertBus Latest Microsoft 70-764 Exam Practice Materials Free Downloading

03/11/2019|

Categories :

CertBus 2019 Valid Microsoft 70-764 MCSA Exam VCE and PDF Dumps for Free Download!

☆ 70-764 MCSA Exam PDF and VCE Dumps : 380QAs Instant Download: https://www.certgod.com/70-764.html [100% 70-764 Exam Pass Guaranteed or Money Refund!!]
☆ Free view online pdf on CertBus free test 70-764 PDF: https://www.certgod.com/online-pdf/70-764.pdf

Following 70-764 380QAs are all new published by Microsoft Official Exam Center

As a leading IT exam study material provider, CertBus not only provides you the Mar 11,2019 Latest 70-764 QAs exam questions and answers but also the most comprehensive knowledge of the whole MCSA Latest 70-764 vce Administering a SQL Database Infrastructure certifications. We provide our users with the most accurate Latest 70-764 exam questions Administering a SQL Database Infrastructure study material about the MCSA Hotest 70-764 pdf dumps exam and the guarantee of pass. We assist you to get well prepared for MCSA Latest 70-764 free download certification which is regarded valuable the IT sector.

CertBus – 70-764 certification with money back assurance. CertBus – clear all your 70-764 certification exams with CertBus study guide. 100% pass rate and money back guarantee. CertBus – 100% real 70-764 certification exam questions and answers. easily pass with a high score. CertBus – help candidates on all 70-764 certification exams preparation. pass 70-764 certification exams, get 70-764 certifications easily.

We CertBus has our own expert team. They selected and published the latest 70-764 preparation materials from Microsoft Official Exam-Center: https://www.certgod.com/70-764.html

Question 1:

You have a database named DB1 that is configured to use the full recovery model. You have a full daily backup job that runs at 02:00. The job backs up data from DB1 to the file

B:DB1.bak.

You need to restore the DB1 database to the point in time of May 25, 2016 at 02:23 and ensure that the database is functional and starts to accept connections.

Which Transact-SQL statement should you run?

A. Option A

B. Option B

C. Option C

D. Option D

Correct Answer: B

Question 2:

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

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

Correct Answer: G

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.

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup- restore/backup-encryption

Question 3:

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-SQL 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-SQL statement should you run?

A. ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = ALL)

B. ALTER DATABASE DB1SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 50)

C. ALTER DATABASE DB1SET QUERY_STORE (CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 14));

D. ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = NONE)

Correct Answer: C

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));

References:https://docs.microsoft.com/en-us/sql/relational-databases/performance/best- practice-with-the-query-store

Question 4:

You have an SQL Server 2016 server named SQL1. You are designing a performance monitoring solution.

You need to monitor the following events on SQL1:

A deadlock graph Missing column statistics CPU performance statistics A batch of completed Transact-SQL statements

Which two tools should you use? Each correct answer presents a complete solution.

A. dynamic management views

B. Database Engine Tuning Advisor

C. SQL Server Profiler

D. Activity Monitor

E. Data Profile Viewer

Correct Answer: BC

Explanation: B: Database Engine Tuning Advisor examines how queries are processed in the databases you specify.

When you run a Profiler Trace and feed it to the Database Engine Tuning Advisor, it also looks for missing column statistics, and it can automatically create them for you.

C: Use SQL Server Profiler to identify the cause of a deadlock. A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within SQL Server. Using SQL Server Profiler, you can create a trace that records, replays, and displays deadlock events for analysis. Reference: Analyze Deadlocks with SQL Server Profiler

https://msdn.microsoft.com/en-us/library/ms188246.aspx Reference: Mastering SQL Server Profiler, page 245

Question 5:

You have a database named DB1.

You plan to create a stored procedure that will insert rows into three different tables. Each insert must use the same identifying value for each table, but the value must increase from one invocation of the stored procedure to the next.

Occasionally, the identifying value must be reset to its initial value.

You need to design a mechanism to hold the identifying values for the stored procedure to use.

What should you do?

More than one answer choice may achieve the goal. Select the BEST answer.

A. Create a sequence object that holds the next value in the sequence. Retrieve the next value by using the stored procedure. Reset the value by using an ALTER SEQUENCE statement as needed.

B. Create a sequence object that holds the next value in the sequence. Retrieve the next value by using the stored procedure. Increment the sequence object to the next value by using an ALTER SEQUENCE statement. Reset the value as needed by using a different ALTER SEQUENCE statement.

C. Create a fourth table that holds the next value in the sequence. At the end each transaction, update the value by using the stored procedure. Reset the value as needed by using an UPDATE statement.

D. Create an identity column in each of the three tables. Use the same seed and the same increment for each table. Insert new rows into the tables by using the stored procedure. Use the DBCC CHECKIDENT command to reset the columns as needed.

Correct Answer: A

an application can obtain the next sequence number without inserting the row by calling the NEXT VALUE FOR function.

ALTER SEQUENCE

Includes argument:

RESTART [ WITH ]

The next value that will be returned by the sequence object. If provided, the RESTART WITH value must be an integer that is less than or equal to the maximum and greater than or equal to the minimum value of the sequence object. If the

WITH value is omitted, the sequence numbering restarts based on the original CREATE SEQUENCE options.

CREATE SEQUENCE

Creates a sequence object and specifies its properties. A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of

numeric values is generated in an ascending or descending order at a defined interval and can be configured to restart (cycle) when exhausted.

Sequence Numbers

Latest 70-764 Dumps 70-764 Practice Test 70-764 Study Guide

Question 6:

You have two SQL Server 2016 instances named SQLDev and SQLProd.

You plan to create a new database on SQLProd that will use SQL Server Authentication.

You need to ensure that when the new database is copied from SQLProd to SQLDev, users can connect to the database on SQLDev even if they do not have a login on the SQLDev instance.

What should you use?

More than one answer choice may achieve the goal. Select the BEST answer.

A. Triggers

B. Contained database

C. SQL Server Analysis Services (SSAS) scripts

D. Extended Events

E. SQL Server Integration Services (SSIS) scripts

Correct Answer: B

A fully contained database includes all the settings and metadata required to define the database and has no configuration dependencies on the instance of the SQL Server Database Engine where the database is installed. Reference: Contained Databases

Question 7:

Information and details provided in a question apply only to that question.

You observe that several indexes are fragmented.

You need to rebuild the indexes.

What should you use?

A. Activity Monitor

B. Sp_who3

C. Object Explorer in the SQL Server Management Studio (SSMS)

D. SQL Server Data Collector

E. SQL Server Data Tools (SSDT)

F. SQL Server Configuration Manager

Correct Answer: C

How to: Rebuild an Index (SQL Server Management Studio) To rebuild an index References: https://technet.microsoft.com/en-us/library/ms187874(v=sql.105).aspx

Question 8:

You have a SQL Server 2016 environment that contains 20 servers.

The corporate security policy states that all SQL Server 2016 instances must meet specific security standards.

You need to recommend a management strategy for the SQL Server 2016 servers.

What should you include in the recommendation?

More than one answer choice may achieve the goal. Select the BEST answer.

A. Multi server jobs

B. Policy-Based Management

C. Common criteria compliance

D. Maintenance plans

Correct Answer: B

Policy-Based Management is a system for managing one or more instances of SQL Server. When SQL Server policy administrators use Policy-Based Management, they use SQL Server Management Studio to create policies to manage

entities on the server, such as the instance of SQL Server, databases, or other SQL Server objects.

Reference:

Policy-Based Management How-to Topics

Question 9:

You have two databases named DB1 and DB2 that are located on the same server.

You plan to create a stored procedure named SProc1 in DB1.

SProc1 will query a table named Table2 in DB2.

You need to recommend a solution to ensure that SProc1 can access Table2 without granting users direct access to Table2.

What should you include in the recommendation?

More than one answer choice may achieve the goal. Select the BEST answer.

A. Contained databases

B. Application roles

C. Cross-database ownership chaining

D. Digital certificates

Correct Answer: B

An application role is a database principal that enables an application to run with its own, user-like permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application. Unlike database roles, application roles contain no members and are inactive by default.

Reference: Application Roles

Question 10:

Information and details provided in a question apply only to that question.

You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.

Clients connect to databases by using line-of-business applications. Developers connect by using SQL Server Management Studio (SSMS).

You need to provide permissions to a service account that will be used to provision a new database for a client.

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

Correct Answer: C

Members of the dbcreator fixed server role can create, alter, drop, and restore any database. References:https://docs.microsoft.com/en-us/sql/relational- databases/security/authentication-access/server-level-roles

CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 70-764 exam successfully with our Microsoft materials. CertBus Administering a SQL Database Infrastructure exam PDF and VCE are the latest and most accurate. We have the best Microsoft in our team to make sure CertBus Administering a SQL Database Infrastructure exam questions and answers are the most valid. CertBus exam Administering a SQL Database Infrastructure exam dumps will help you to be the Microsoft specialist, clear your 70-764 exam and get the final success.

70-764 Microsoft exam dumps (100% Pass Guaranteed) from CertBus: https://www.certgod.com/70-764.html [100% Exam Pass Guaranteed]

Why select/choose CertBus?

Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.



Brand	Certbus	Testking	Pass4sure	Actualtests	Others
Price	$45.99	$124.99	$125.99	$189	$69.99-99.99
Up-to-Date Dumps
Free 365 Days Update
Real Questions
Printable PDF
Test Engine
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back
Secure Payment
Privacy Protection