ExamGecko
Login
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
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?