70-764 Questions And Answers

$58

Exam Name: Administering a SQL Database Infrastructure

Updated: 2018-11-18

Q & A: 359

Money Back Guaranteed
  Reviews
  Customers who bought this item also bought

70-764 Frequently Asked Questions

Q1: Can I use 70-764 exam Q&As in my phone?
Yes, PassQuestion provides MCSA 70-764 pdf Q&As which you can download to study on your computer or mobile device, we also provide 70-764 pdf free demo which from the full version to check its quality before purchasing.

Q2: What are the formats of your Microsoft 70-764 exam questions?
PassQuestion provides Microsoft 70-764 exam questions with pdf format and software format, pdf file will be sent in attachment and software file in a download link, you need to download the link in a week, it will be automatically invalid after a week.

Q3: How can I download my 70-764 test questions after purchasing?
We will send MCSA 70-764 test questions to your email once we receive your order, pls make sure your email address valid or leave an alternate email.

Q4: How long can I get my MCSA 70-764 questions and answers after purchasing?
We will send MCSA 70-764 questions and answers to your email in 10 minutes in our working time and no less than 12 hours in our off time.

Working Time:
GMT+8: Monday- Saturday 8:00 AM-18:00 PM
GMT: Monday- Saturday 0:00 AM-10:00 AM

Q5: Can I pass my test with your MCSA 70-764 practice questions only?
Sure! All of PassQuestion MCSA 70-764 practice questions come from real test. If you can practice well and get a good score in our practice Q&As, we ensure you can pass your Administering a SQL Database Infrastructure exam easily.

Q6: How can I know my 70-764 updated? 
You can check the number of questions, if it is changed,that means we have updated this exam ,you can contact us anytime to ask for an free update. our sales email : [email protected]

Q7: What is your refund process if I fail Microsoft  70-764 test?
If you fail your 70-764 test by studying our study material, just scan your score report and send to us in attchment,when we check, we will give you full refund.

Q8. What other payment menthod can I use except Paypal?
If your country don't support Paypal, we offer another Payment method Western Union,it is also safe and fast. Pls contact us for the details, we will send it to your email.

Question No : 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
Answer: B

Question No : 2

DRAG DROP
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 have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram.



You have an Always On Availability group named AG1.
The details for AG1 are shown in the following table.



Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is read_only and is half of the total database size.
Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I/O.
Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes.
You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain.
You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1.
All databases use the full recovery model. All backups are written to the network location \\SQLBackup\. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups.
The recovery point objective (RPO) for each instance is shown in the following table.



Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups use the keyword COMPRESSION.
You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1.
The wait statistics monitoring requirements for the instances are described in the following table.



You need to configure a new replica of AG1 on Instance6.
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL statements to the correct locations. Each Transact-SQL segment 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:



Question No : 3

HOTSPOT
You are configuring log shipping for a Microsoft SQL Server database named salesOrders.
You run the following Transact-SQL script:



You need to determine the changes that the script has on the environment.
How does the script affect the environment? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.



Answer:



Question No : 4

You have a database that stores information for a shipping company.
You create a table named Customers by running the following Transact-SQL statement. (Line numbers are included for reference only.)



You need to ensure that salespeople can view data only for the customers that are assigned to them.
Which Transact-SQL segment should you insert at line 07?
A. RETURNS varchar(20)WITH Schemabinding
B. RETURNS dbo.CustomersORDER BY @salesPerson
C. RETURNS tableORDER BY @salesPerson
D. RETURNS tableWITH Schemabinding
Answer: D

Question No : 5

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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases.
One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented.
You need to optimize query performance.
Solution: You run the DBCC CHECKDB command.
Does the solution meet the goal?
A. Yes
B. No
Answer: B

Question No : 6

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 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:
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: E

Question No : 7

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

Question No : 8

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

Question No : 9

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 sections, 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 tempdb database.
Does the solution meet the goal?
A. Yes
B. No
Answer: B

Question No : 10

HOTSPOT
You are planning the deployment of two new Always On Failover Cluster Instances (FCIs) of Microsoft SQL Server to a single Windows Server Cluster with three nodes.
The planned configuration for the cluster is shown in the Server Layout exhibit. (Click the Exhibit button.)



The SAN team has configured storage for the cluster and sent the configuration to you in the email shown in the SAN Team Email exhibit. (Click the Exhibit button.)



Each node of the cluster has identical local storage available as shown in the Local Storage exhibit. (Click the Exhibit button.)



All local storage is on SSD.
You need to plan specific configurations for the new cluster.
For each of the following statement, select Yes if the statement is true. Otherwise, select No.



Answer:


Question No : 11

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
Answer: BC

Question No : 12

HOTSPOT
You deploy a Microsoft SQL Server instance to support a global sales application. The instance includes the following tables: TableA and TableB.
TableA is a partitioned table that uses an incrementing integer number for partitioning. The table has millions of rows in each partition. Most changes to the data in TableA affect recently added data. The UPDATE STATISTICS for TableA takes longer to complete than the allotted maintenance window.
Thousands of operations are performed against TableB each minute. You observe a large number of Auto Update Statistics events for TableB.
You need to address the performance issues with each table.
In the table below, identify the action that will resolve the issues for each table.
NOTE: Make only one selection in each column.



Answer:



Question No : 13

HOTSPOT
You manage a Microsoft SQL Server environment. You have a database named salesOrders that includes a table named Table1.
Table1 becomes corrupt. You repair the table.
You need to verify that all the data in Table1 complies with the schema.
How should you complete the Transact-SQL code statement? To answer, select the appropriate Transact-SQL code segments in the dialog box in the answer area.



Answer:



Question No : 14

HOTSPOT
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instanced. The environments host several customer databases.
You host a local database and a Stretch database that has a table named Members for one specific customer.
You need to provide the customer with information about the space used in the databases.
In the table below, identify the query that provides the required information for each database.
NOTE: Make only one selection in each column.



Answer:



Domenic Oudekerk

28 Sep, 2018

i'm very happy that i passed 70-764 exam successfully. Recommend.
Mikel Lemar

18 Sep, 2018

I have passed 70-764 exam with high score. They really helped me a lot.
Fred Fatora

11 Sep, 2018

Absolutely valid. Passed 70-764 today. You are the best. Thank you so much!!!!
Thurman Smugala

05 Sep, 2018

Real questions! Real dumps! Thank you! Glad to receive your 70-764 dumps.Thank you much for being such miraculous support.
Chase Calero

01 Sep, 2018

I have cleared 70-764 exam. Will recommend your site to my friends.
Johnathan Yuricic

30 Aug, 2018

I have passed 70-764 exam with the actual 70-764 questions and answers which collected by Passquestion.
Solomon Greenstein

25 Aug, 2018

I will let another examinees like me know the site and get a high score in the coming Administering a SQL Database Infrastructure 70-764 test.
Elbert Rocca

22 Aug, 2018

Just passed 70-764 exam. Microsoft MCSA 70-764 questions are from your dumps material. Thank you.
Lauren Barze

18 Aug, 2018

I can easily find out my own mistakes as well as can correct your answers very easily with the help of Microsoft MCSA 70-764 exam. Thanks I passed it easily.
Sterling Lapage

15 Aug, 2018

I just pass my Microsoft MCSA 70-764 exam yesterday and passed 70-764 with 90%. Thanks for your site service.
Sammy Zanardi

11 Aug, 2018

All good! I really appreciate that you update Microsoft MCSA 70-764 exam.
Buddy Letofsky

08 Aug, 2018

Passed today. Few new questions. Microsoft 70-764 exam questions are still valid in UK. Thanks for your site service.
Darrell Rokosz

04 Aug, 2018

Passed 70-764 yesterday. I recommend that 70-764 dump be used for practice, although very few questions from here emerge in the exam. Thanks a lot.
Geraldo Lerper

01 Aug, 2018

Valid, pass Microsoft MCSA 70-764 exam today. Only few answer are wrong that I have to search them and correct before I taking my Microsoft MCSA 70-764 exam test. Thanks!
Lawrence Dahlem

28 Jul, 2018

Hi, guys. I have good news to tell you that I just passed Microsoft MCSA 70-764 exam with high score by using your passquestion for the first time, thank you very much.
Dan Brandl

25 Jul, 2018

They update of Microsoft MCSA 70-764 dump quite often. I was informed there is the latest update for my exam within a week after purchase. Really a great help!
Waylon Eschenbacher

21 Jul, 2018

Microsoft MCSA 70-764 Administering a SQL Database Infrastructure real questions are helpful. Good question material are valid. Thank you.
Charles Frakes

18 Jul, 2018

Microsoft MCSA 70-764 study guide is the newest. I have learned all the questions well and could answer them correctly. Thank you.
Heriberto Cerruto

14 Jul, 2018

Passed today with very high score. I prepare only with your valid 70-764 exam questions. Good study material for passing my 70-764 exam test. Thanks a lot.
Chong Eafford

11 Jul, 2018

Just passed my 70-764 Administering a SQL Database Infrastructure exam. 4 new questions in my 70-764 exam. You need to be careful. Do not just learn the answers by heart.
Darrick Jatho

07 Jul, 2018

I wanted to thank PassQuestion for all their help which I only spent a little time for my Microsoft MCSA 70-764 exam. Glad to let your team know that I passed easily. Perfect site.
Bob Blotter

04 Jul, 2018

I have to tell that I managed to pass70-764 exam test on the very first attempt. I have stuied your real questions well. Thanks a lot.
Josue Wittekind

30 Jun, 2018

I passed 70-764 Administering a SQL Database Infrastructure exam two months ago with your actual questions. I heard that 70-764 exam is available, when will you get the exam? I'm very happy to tell you that i have passed the 70-764 exam today! Thanks for your online service and the actual exam materials.
Buchler

27 Jun, 2018

MCSA 70-764 examination took yesterday. I have completed all the questions you sent me and found that there are many are the same as yours. I am confident to take 70-764 exam test. Thanks for your site.

Lutgen

23 Jun, 2018

70-764 Administering a SQL Database Infrastructure exam dumps questions are perfect for my 70-764 exam test.  I passed it two days ago. Thanks a lot. 

Grover

16 Jun, 2018

70-764 Administering a SQL Database Infrastructure exam questions are updated recently. I have used your newest version to prepare for my 70-764 exam test. High scores I got yesterday. Thanks for your site update in time. Best service.   

Miguel

12 Jun, 2018

This is Miguel, thanks very much, I have passed 70-764 exam.

Jenifer

17 May, 2018

I am current reading all Q&As of your 70-764 exam. I have found some of them are real. Now, I have full confidence on your guide.

Hanh

16 May, 2018

Purchased this guide two days ago. Good shopping experience. Thanks, I am learning all Q&As and will take this exam soon.

Clora

15 May, 2018

Wonderful, have passed my 70-764 exam smoothly, with your 70-764 exam questions and answers. Thanks a lot, you are professional.

Add Comments

Your Rating