70-764 Questions And Answers
$68
Exam Name: Administering a SQL Database Infrastructure
Updated: 2021-03-04
Q & A: 451
- Reviews
-
Minh BoveOct 14,202070-764 real questions are valid. Passed it. Thank you.
-
Sergio BottoniMay 22,2020Studied and practiced my 70-764 exam with PassQuestion 70-764 exam questions, wonderful, all these Q&As are helpful.
-
Santos HothanApr 02,2020I cleared my 70-764 exam yesterday, thanks, PassQuestion 70-764 exam questions are valid.
Customers who bought this item also bought
Why Choose PassQuestion Microsoft 70-764 Exam Questions
Passquestion team uses professional knowledge and experience to provide MCSA 70-764 Questions and Answers for people ready to participate in Administering a SQL Database Infrastructure exam. The accuracy rate of 70-764 exam questions provided by Passquestion are very high and they can 100% guarantee you pass the Microsoft 70-764 exam successfully in the first attempt. Everyone can get 70-764 pdf with free test engine to study. PassQuestion can promise you always have the latest version for your Microsoft 70-764 test preparation and get your MCSA certification easily.
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 in 60 days 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
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.
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.
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
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
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
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
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
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
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.
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
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.
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.
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.
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:
Sergio Bottoni
Studied and practiced my 70-764 exam with PassQuestion 70-764 exam questions, wonderful, all these Q&As are helpful.
Santos Hothan
I cleared my 70-764 exam yesterday, thanks, PassQuestion 70-764 exam questions are valid.
Elbert Buresh
Yesterday, I passed my 70-764 exam with a perfect score, thanks a lot. Next, I will go on taking 70-765 exam.
Horace Reindel
Valuable 70-764 exam questions. I took and passed my test smoothly. Thanks a lot.
Wilbert Papallo
Spend 10 days learning my 70-764 PassQuestion exam questions and answers, then passed successfully. So great, PassQuestion 70-764 exam questions are great.
Myles Trucco
PassQuestion provided a good high level guide with real exam questions and answers. I took my 70-764 exam and passed after read your high level exam questions.Thanks a lot.
Mathew Feerick
70-764 training exam materials are good helper for me. Thanks. 70-764 exam is hard for me I thought, now I dont think so.
Danial Westrum
70-764 exam question is very useful. I have passed 70-764 exam today with good scores.
Omer Castellon
Passed 70-764 today......... Thanks a lot guys! I only Study your questions and answers. Valid dump! Good luck to u all!
Luther Smithers
Passed 70-764 today......... Thanks a lot guys! I only Study your questions and answers. Valid dump! Good luck to u all!
Trevor Haslem
I recommend 70-764 dump with a 5 star feedback. 70-764 exam will help make help a lot.
Johnson Metts
Just passed my 70-764 exam. This is not my first time to use your product, I will recommend my friends to use your product.
Domenic Oudekerk
i'm very happy that i passed 70-764 exam successfully. Recommend.
Mikel Lemar
I have passed 70-764 exam with high score. They really helped me a lot.
Fred Fatora
Absolutely valid. Passed 70-764 today. You are the best. Thank you so much!!!!
Thurman Smugala
Real questions! Real dumps! Thank you! Glad to receive your 70-764 dumps.Thank you much for being such miraculous support.
Chase Calero
I have cleared 70-764 exam. Will recommend your site to my friends.
Johnathan Yuricic
I have passed 70-764 exam with the actual 70-764 questions and answers which collected by Passquestion.
Solomon Greenstein
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
Just passed 70-764 exam. Microsoft MCSA 70-764 questions are from your dumps material. Thank you.
Lauren Barze
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
I just pass my Microsoft MCSA 70-764 exam yesterday and passed 70-764 with 90%. Thanks for your site service.
Sammy Zanardi
All good!
I really appreciate that you update Microsoft MCSA 70-764 exam.
Buddy Letofsky
Passed today. Few new questions. Microsoft 70-764 exam questions are still valid in UK. Thanks for your site service.
Darrell Rokosz
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
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
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
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
Microsoft MCSA 70-764 Administering a SQL Database Infrastructure real questions are helpful. Good question material are valid. Thank you.
Charles Frakes
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
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
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
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
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
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
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
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
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
This is Miguel, thanks very much, I have passed 70-764 exam.
Jenifer
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
Purchased this guide two days ago. Good shopping experience. Thanks, I am learning all Q&As and will take this exam soon.
Clora
Wonderful, have passed my 70-764 exam smoothly, with your 70-764 exam questions and answers. Thanks a lot, you are professional.
Minh Bove