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

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

Add to Whishlist

List of questions

Question 231

Report Export Collapse

HOTSPOT

You have a SQL Server on Azure Virtual Machines instance that hosts a database named Db1.

You need to configure the autogrow and autoshrink settings for DB1.

Which statements should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 232

Report Export Collapse

HOTSPOT

You have an Azure SQL logical server.

You run the following script.

Microsoft DP-300 image Question 43 90018 10022024015907000000


Become a Premium Member for full access
  Unlock Premium Member

Question 233

Report Export Collapse

HOTSPOT

You have an Azure subscription that is linked to an Azure AD tenant named contoso.com. The subscription contains an Azure SQL database named SQL 1 and an Azure web named app1. App1 has the managed identity feature enabled. You need to create a new database user for app1.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 234

Report Export Collapse

HOTSPOT

You need to use an Azure Resource Manager ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O performance for the SQL Server database and log files How should you complete the template? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 235

Report Export Collapse

You manage 100 Azure SQL managed instances located across 10 Azure regions.

You need to receive voice message notifications when a maintenance event affects any of the 10 regions. The solution must minimize administrative effort. What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 236

Report Export Collapse

DRAG DROP

You have an Azure subscription that contains an Azure SQL managed instance, a database named db1, and an Azure web app named Appl. Appl uses db1. You need to enable Resource Governor for a App1. The solution must meet the following requirements:

App1 must be able to consume all available CPU resources.

App1 must have at least half of the available CPU resources always available.

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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.


Become a Premium Member for full access
  Unlock Premium Member

Question 237

Report Export Collapse

HOTSPOT

You have an Azure SQL database named that contains a table named Table1.

You run a query to bad data into Table1.

The performance Of Table1 during the load operation are shown in exhibit.

Microsoft DP-300 image Question 48 90023 10022024015907000000


Become a Premium Member for full access
  Unlock Premium Member

Question 238

Report Export Collapse

DRAG DROP

You have a database named db1.

The log for db1 contains the following entry.

Microsoft DP-300 image Question 49 90024 10022024015907000000

You need to ensure That db1 can process transactions.


Become a Premium Member for full access
  Unlock Premium Member

Question 239

Report Export Collapse

You have an Azure subscription that contains the resources shown in the following table.

Microsoft DP-300 image Question 50 90025 10022024015907000000

App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by Appl as soon as possible, without considering immediate costs What you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 240

Report Export Collapse

HOTSPOT

You have a Microsoft SQL Server 2017 server that hosts five databases.

You Plan to migrate the databases to Azure.

You need to recommend a solution that meets the following requirements:

Automatically scales compute based on the workload demand

Provides per-second billing

What should you include in the recommendation? To answer, select the appropriate options in the answer area.


Become a Premium Member for full access
  Unlock Premium Member
Total 342 questions
Go to page: of 35
Search

Related questions