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

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

List of questions

Question 191

Report
Export
Collapse

You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features.

You plan to migrate to Azure SQL.

Which service should you use?

Azure SQL Database
Azure SQL Database
SQL Server on an Azure Virtual Machine
SQL Server on an Azure Virtual Machine
Azure SQL Managed Instance
Azure SQL Managed Instance
Azure Database for MySQL
Azure Database for MySQL
Suggested answer: B

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview

asked 02/10/2024
Muneer Deers
43 questions

Question 192

Report
Export
Collapse

You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime. What should you do?

Configure Transaction Log Shipping.
Configure Transaction Log Shipping.
Implement Always On availability groups.
Implement Always On availability groups.
Configure transactional replication.
Configure transactional replication.
Import a BACPAC.
Import a BACPAC.
Suggested answer: C

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server#method-1-migration-with-downtime-during-the-migration

asked 02/10/2024
Jose M Rivera Vega
38 questions

Question 193

Report
Export
Collapse

You have an Azure SQL database named DB1.

You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled.

During a database audit, you discover that none of the fields contain more than 150 characters.

You need to ensure that you can apply page compression to Table1.

What should you do?

Configure the columns as sparse.
Configure the columns as sparse.
Change the column type to NVARCHAR(MAX).
Change the column type to NVARCHAR(MAX).
Change the column type to VARCHAR(MAX).
Change the column type to VARCHAR(MAX).
Change the column type to VARCHAR(200).
Change the column type to VARCHAR(200).
Suggested answer: D

Explanation:

Reference: https://www.sqlshack.com/sql-varchar-data-type-deep-dive/

https://36chambers.wordpress.com/2020/06/18/nvarchar-everywhere-a-thought-experiment/

asked 02/10/2024
Valerio Lorenzani
38 questions

Question 194

Report
Export
Collapse

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.

You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:

Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1. Restrict network connectivity to SqlSrv1. What should you create on VNet1?

a VPN gateway
a VPN gateway
a service endpoint
a service endpoint
a private endpoint
a private endpoint
an ExpressRoute gateway
an ExpressRoute gateway
Suggested answer: B

Explanation:

A private endpoint is a network interface that uses a private IP address from your virtual network. This network interface connects you privately and securely to a service powered by Azure Private Link. By enabling a private endpoint, you're bringing the service into your virtual network.

The service could be an Azure service such as:

Azure Storage

Azure Cosmos DB

Azure SQL Database

Your own service using a Private Link Service.

Reference:

https://docs.microsoft.com/en-us/azure/private-link/private-endpoint-overview

asked 02/10/2024
Saysha Vargas
29 questions

Question 195

Report
Export
Collapse

You have an Azure SQL database named db1 on a server named server1.

The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention. You need to resolve the performance issues.

What should you do?

Implement memory-optimized tables.
Implement memory-optimized tables.
Run the DBCC FLUSHPROCINDB command.
Run the DBCC FLUSHPROCINDB command.
Replace the sequential index keys with nonsequential keys.
Replace the sequential index keys with nonsequential keys.
Run the DBCC DBREINDEX command.
Run the DBCC DBREINDEX command.
Suggested answer: A

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdb-contention

asked 02/10/2024
Michael Whitehouse
43 questions

Question 196

Report
Export
Collapse

You have an instance of SQL Server on Azure Virtual Machines that has a database named DB1.

You plan to implement Azure SQL Data Sync for DB1.

Which isolation level should you configure?

SERIALIZABLE
SERIALIZABLE
SNAPSHOT
SNAPSHOT
READ UNCOMMITTED
READ UNCOMMITTED
READ COMMITTED
READ COMMITTED
Suggested answer: B

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database

asked 02/10/2024
Yunus Emre Akay
33 questions

Question 197

Report
Export
Collapse

You have an Azure SQL managed instance.

You need to enable SQL Agent Job email notifications.

What should you do?

Use the Agent XPs option.
Use the Agent XPs option.
Enable the SQL Server Agent.
Enable the SQL Server Agent.
Run the sp_configure command.
Run the sp_configure command.
Run the sp_set_agent_properties command.
Run the sp_set_agent_properties command.
Suggested answer: C

Explanation:

Reference: https://techcommunity.microsoft.com/t5/azure-sql-blog/sending-emails-in-azure-sql-managed-instance/ba-p/386235

asked 02/10/2024
aaron black
34 questions

Question 198

Report
Export
Collapse

You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases.

You need to update the column and index statistics for the databases.

What should you use?

an Azure Automation runbook
an Azure Automation runbook
a SQL Agent job
a SQL Agent job
Azure SQL Analytics
Azure SQL Analytics
automatic tuning in Azure SQL Database
automatic tuning in Azure SQL Database
Suggested answer: A

Explanation:

Reference: https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/

asked 02/10/2024
Andrew ROUSE
45 questions

Question 199

Report
Export
Collapse

You have a new Azure subscription.

You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.

You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings. Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

From the properties of DB1, configure geo-replication.
From the properties of DB1, configure geo-replication.
From the properties of Server1, add a failover group.
From the properties of Server1, add a failover group.
Create a new Azure SQL Database server named Server2.
Create a new Azure SQL Database server named Server2.
From the properties of Server1, configure retention for DB1.
From the properties of Server1, configure retention for DB1.
Create a new Azure SQL Database instance named DB2.
Create a new Azure SQL Database instance named DB2.
Suggested answer: B, C

Explanation:


asked 02/10/2024
Balanavaneethan Nitharsan
29 questions

Question 200

Report
Export
Collapse

HOTSPOT

You have an Azure subscription.

You plan to deploy an Azure SQL database by using an Azure Resource Manager template.

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


Microsoft DP-300 image Question 200 89986 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 200 89986 10022024015907000

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart

asked 02/10/2024
Musoke Kamuzze
30 questions
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?