ExamGecko
Login
Home / Microsoft / DP-300 / List of questions
Ask Question

Microsoft DP-300 Practice Test - Questions Answers, Page 32

List of questions

Question 311

Report
Export
Collapse

Task 2

You need to configure your user account as the Azure AD admin for the server named sql3700689S.

Become a Premium Member for full access
  Unlock Premium Member

Question 312

Report
Export
Collapse

Task 3

You need to ensure that all queries executed against dbl are captured in the Query Store.

Become a Premium Member for full access
  Unlock Premium Member

Question 313

Report
Export
Collapse

Task 4

You need to enable change data capture (CDC) for db1.

Become a Premium Member for full access
  Unlock Premium Member

Question 314

Report
Export
Collapse

Task 5

You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.

Become a Premium Member for full access
  Unlock Premium Member

Question 315

Report
Export
Collapse

Task 6

You need to ensure that any enhancements made to the Query Optimizer through patches are available to dbl and db2 on sql37006895.

Become a Premium Member for full access
  Unlock Premium Member

Question 316

Report
Export
Collapse

Task 7

You plan to create an automation runbook that will create database users in db1 from Azure AD identities. You need to configure sq1370O6895 to support the creation of new database users.

Become a Premium Member for full access
  Unlock Premium Member

Question 317

Report
Export
Collapse

Task 8

You plan to perform performance testing of db1.

You need prevent db1 from reverting to the last known good query plan.

Become a Premium Member for full access
  Unlock Premium Member

Question 318

Report
Export
Collapse

Task 9

You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average.

Become a Premium Member for full access
  Unlock Premium Member

Question 319

Report
Export
Collapse

Task 10

You need to protect all the databases on sql37006S95 from SQL injection attacks.

Become a Premium Member for full access
  Unlock Premium Member

Question 320

Report
Export
Collapse

Task 11

You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1 You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012.

Become a Premium Member for full access
  Unlock Premium Member
Total 342 questions
Go to page: of 35
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. You need to ensure that an automatic email notification is sent once the job completes. What should you include in the solution?
You have an Azure subscription. You create a logical SQL server that hosts four databases Each database will be used by a separate customer. You need to ensure that each customer can access only its own database. The solution must minimize administrative effort Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
Task 5 You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.
Task 10 You need to protect all the databases on sql37006S95 from SQL injection attacks.
DRAG DROP You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
HOTSPOT You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1. You need to protect the contents of Column1 at rest, in transit, and in use. How should you protect the contents of Column1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company's SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic. What are two results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation?
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2. You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements: The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections. Administrative effort must be minimized. What should you use to host the databases?
You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?