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

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

List of questions

Question 181

Report
Export
Collapse

DRAG DROP

You are creating a managed data warehouse solution on Microsoft Azure.

You must use PolyBase to retrieve data from Azure Blob storage that resides in parquet format and load the data into a large table called FactSalesOrderDetails.

You need to configure Azure Synapse Analytics to receive the data.

Which four 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.


Microsoft DP-300 image Question 181 89817 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 181 89817 10022024015907000

Explanation:

To query the data in your Hadoop data source, you must define an external table to use in Transact-SQL queries. The following steps describe how to configure the external table.

Step 1: Create a master key on database.

1. Create a master key on the database. The master key is required to encrypt the credential secret.

(Create a database scoped credential for Azure blob storage.)

Step 2: Create an external data source for Azure Blob storage.

2. Create an external data source with CREATE EXTERNAL DATA SOURCE..

Step 3: Create an external file format to map the parquet files.

3. Create an external file format with CREATE EXTERNAL FILE FORMAT.

Step 4. Create an external table FactSalesOrderDetails

4. Create an external table pointing to data stored in Azure storage with CREATE EXTERNAL TABLE.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-azure-blob-storage

asked 02/10/2024
John Atkinson
38 questions

Question 182

Report
Export
Collapse

HOTSPOT

You configure version control for an Azure Data Factory instance as shown in the following exhibit.

Microsoft DP-300 image Question 26 89818 10022024015907000000

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.


Microsoft DP-300 image Question 182 89818 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 182 89818 10022024015907000

Explanation:

Box 1: adf_publish

By default, data factory generates the Resource Manager templates of the published factory and saves them into a branch called adf_publish. To configure a custom publish branch, add a publish_config.json file to the root folder in the collaboration branch. When publishing, ADF reads this file, looks for the field publishBranch, and saves all Resource Manager templates to the specified location. If the branch doesn't exist, data factory will automatically create it. And example of what this file looks like is below:

{

"publishBranch": "factory/adf_publish"

}

Box 2: /dwh_barchlet/ adf_publish/contososales

RepositoryName: Your Azure Repos code repository name. Azure Repos projects contain Git repositories to manage your source code as your project grows. You can create a new repository or use an existing repository that's already in your project.

Reference:

https://docs.microsoft.com/en-us/azure/data-factory/source-control

asked 02/10/2024
Louis Perriot
42 questions

Question 183

Report
Export
Collapse

HOTSPOT

You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.

You execute the Transact-SQL query shown in the following exhibit.

Microsoft DP-300 image Question 27 89819 10022024015907000000

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.


Microsoft DP-300 image Question 183 89819 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 183 89819 10022024015907000

Explanation:

Box 1: CSV files that have file named beginning with "tripdata_2020"

Box 2: a header

FIRSTROW = 'first_row'

Specifies the number of the first row to load. The default is 1 and indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based.

Reference:

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset

asked 02/10/2024
Tim baxter
41 questions

Question 184

Report
Export
Collapse

HOTSPOT

You are provisioning an Azure SQL database in the Azure portal as shown in the following exhibit.

Microsoft DP-300 image Question 28 89820 10022024015907000000

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.


Microsoft DP-300 image Question 184 89820 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 184 89820 10022024015907000

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

asked 02/10/2024
Jevgenij Žarikov
39 questions

Question 185

Report
Export
Collapse

You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements:

The web app must be hosted on an Azure virtual network.

The Azure SQL database must be assigned a private IP address.

The Azure SQL database must allow connections only from the virtual network.

You need to recommend a solution that meets the requirements.

What should you include in the recommendation?

Azure Private Link
Azure Private Link
a network security group (NSG)
a network security group (NSG)
a database-level firewall
a database-level firewall
a server-level firewall
a server-level firewall
Suggested answer: A
asked 02/10/2024
Jennifer Leon
41 questions

Question 186

Report
Export
Collapse

You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year.

During peak usage, the database will require the following:

24 cores

500 GB of storage

124 GB of memory

More than 50,000 IOPS

During periods of off-peak usage, the service tier of Azure SQL Database will be set to Standard.

Which service tier should you use during peak usage?

Business Critical
Business Critical
Premium
Premium
Hyperscale
Hyperscale
Suggested answer: A

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases#business-critical---provisioned-compute---gen4

asked 02/10/2024
Dylan Ogle
45 questions

Question 187

Report
Export
Collapse

HOTSPOT

You have an Azure subscription.

You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template.

How should you complete the ARM template? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft DP-300 image Question 187 89823 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 187 89823 10022024015907000

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?tabs=azure-powershell

asked 02/10/2024
JAMIE JARAMILLO LOOR
37 questions

Question 188

Report
Export
Collapse

HOTSPOT

You have the following Azure Resource Manager template.

Microsoft DP-300 image Question 32 89824 10022024015907000000

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.


Microsoft DP-300 image Question 188 89824 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 188 89824 10022024015907000

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models

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

asked 02/10/2024
Andifon Etim
38 questions

Question 189

Report
Export
Collapse

HOTSPOT

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.

You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service.

You need to create a backup of DB1 that is accessible to the Azure Database Migration Service.

What should you run for the backup and where should you store the backup? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft DP-300 image Question 189 89825 10022024015907000
Correct answer: Microsoft DP-300 image answer Question 189 89825 10022024015907000

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online

asked 02/10/2024
Fathy Refay
42 questions

Question 190

Report
Export
Collapse

You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.

You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.

You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.

You need to configure VNET1 to support the migration.

What should you do?

Configure service endpoints.
Configure service endpoints.
Configure virtual network peering.
Configure virtual network peering.
Deploy an Azure firewall.
Deploy an Azure firewall.
Configure network security groups (NSGs).
Configure network security groups (NSGs).
Suggested answer: A

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance

asked 02/10/2024
Bill Skadden
31 questions
Total 342 questions
Go to page: of 35
Search

Related questions