Login / Register
Sharpen Your Knowledge with Microsoft (70-764) Certification Sample Questions
CertsTime has provided you with a sample question set to elevate your knowledge about the Microsoft Administering a SQL Database Infrastructure exam. With these updated sample questions, you can become quite familiar with the difficulty level and format of the real 70-764 certification test. Try our sample Microsoft Administering a SQL Database Infrastructure certification practice exam to get a feel for the real exam environment. Our sample practice exam gives you a sense of reality and an idea of the questions on the actual Microsoft MCSA: Microsoft Dynamics 365 for Operations certification exam.
Our sample questions are similar to the Real Microsoft 70-764 exam questions. The premium Microsoft Administering a SQL Database Infrastructure certification practice exam gives you a golden opportunity to evaluate and strengthen your preparation with real-time scenario-based questions. Plus, by practicing real-time scenario-based questions, you will run into a variety of challenges that will push you to enhance your knowledge and skills.
Microsoft 70-764 Sample Questions:
You have the following servers:
SQL1 hosts a database named DB1.
Users in the branch office must be able to access DB1 from SQL3.
You need to configure log shipping on DB1 from the main office to the branch office.
On which server should you configure the backup job?
You configure the Microsoft SQL Server Agent service to start automatically. You create a SQL Server Agent operator. You receive email notifications from other SQL Server Agent alerts that have been defined.
You have a SQL Server Agent that is set to notify you through email when error number 50010 occurs. You do not receive any email notifications related to this alert. You verify that the error occurred recently.
You need to determine why this alert is not sending you email notifications.
Why is the alert not sending email notifications?
You have multiple Microsoft SQL Server databases that are deployed in an Always On availability group. You configure the SQL Server Agent service to start automatically.
You need to automate backups for all user databases.
What should you create?
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 Mail1 can send mail by using Database Mail.
Solution: You add the sysadmin server role to Mail1.
Does the solution meet the goal?
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 administer a SQL Server instance at Contoso Ltd.
A new employee named Kim Ralls must be able to read data only from the dbo.order table in the salesDB database.
You create a SQL login named KimRalls. You then create a SQL user account named KimRalls in salesDB. The user account is associated with the SQL login.
You need to grant KimRalls the necessary permission or permissions. Your solution must follow the principle of least privilege.
Solution: You add KimRalls to the db_datareader database role in SalesDB.
Does the solution meet the goal?
Note: If there is any error in our Microsoft 70-764 certification exam sample questions, please update us via email at support@certstime.com.
