Microsoft DP-200 Exam Practice Test Instant Access

Question 1

You are creating a new notebook in Azure Databricks that will support R as the primary language but will also support Scola and SQL.

Which switch should you use to switch between languages?

A%<language>

BError! Hyperlink reference not valid.]

CError! Hyperlink reference not valid.

D@<Language>

Answer : A

You can override the primary language by specifying the language magic command %<language> at the

beginning of a cell. The supported magic commands are: %python, %r, %scala, and %sql.

References:

https://docs.databricks.com/user-guide/notebooks/notebook-use.html#mix-languages

Question 2

A company has a SaaS solutions that will uses Azure SQL Database with elastic pools. The solution will have a dedicated database for each customer organization Customer organizations have peak usage at different periods during the year.

Which two factors affect your costs when sizing the Azure SQL Database elastic pools? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Amaximum data size

Bnumber of databases

CeDTUs consumption

Dnumber of read operations

Enumber of transactions

Answer : A, C

A: With the vCore purchase model, in the General Purpose tier, you are charged for Premium blob storage that you provision for your database or elastic pool. Storage can be configured between 5 GB and 4 TB with 1 GB increments. Storage is priced at GB/month.

C: In the DTU purchase model, elastic pools are available in basic, standard and premium service tiers. Each tier is distinguished primarily by its overall performance, which is measured in elastic Database Transaction Units (eDTUs).

References:

https://azure.microsoft.com/en-in/pricing/details/sql-database/elastic/

Question 3

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains 9 column name Email.

You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead.

What should you do?

AFrom Microsoft SQL Server Management Studio, set an email mask on the Email column.

BFrom the Azure portal, set a mask on the Email column.

CFrom Microsoft SQL Server Management studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

DFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.

Answer : B

https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

Question 4

You need to set up Azure Data Factory pipelines to meet data movement requirements.

Which integration runtime should you use?

Aself-hosted integration runtime

BAzure-SSIS Integration Runtime

C.NET Common Language Runtime (CLR)

DAzure integration runtime

Answer : A

The following table describes the capabilities and network support for each of the integration runtime types:

Scenario: The solution must support migrating databases that support external and internal application to Azure SQL Database. The migrated databases will be supported by Azure Data Factory pipelines for the continued movement, migration and updating of data both in the cloud and from local core business systems and repositories.

References:

https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

Question 5

Use the following login credentials as needed:

Azure Username: xxxxx

Azure Password: xxxxx

The following information is for technical support purposes only:

Lab Instance: 10277521

You need to generate an email notification to admin@contoso.com if the available storage in an Azure Cosmos DB database named cosmos10277521 is less than 100,000,000 bytes.

To complete this task, sign in to the Azure portal.

AExplanation:
1. In the Azure portal, click All services, click Azure Cosmos DB, and then click the cosmos10277521 Azure Cosmos DB account.
2. In the resource menu, click Alert Rules to open the Alert rules page.

3. In the Alert rules page, click Add alert.

4. In the Add an alert rule page, specify:
Metric: Available storage
Condition: Less than
Threshold: 100,000,000 bytes

Answer : A

https://docs.microsoft.com/en-us/azure/cosmos-db/monitor-accounts

Question 6

A company has a real-lime data analysis solution that is hosted on Microsoft Azure the solution uses Azure Event Hub to ingest data and an Azure Stream Analytics cloud job to analyze the dat

a. The cloud job is configured to use 120 Streaming Units (SU).

You need to optimize performance for the Azure Stream Analytics job.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one port.

AImplement event ordering

BScale the SU count for the job up

CImplement Azure Stream Analytics user-defined functions (UDF)

DScale the SU count for the job down

EImplement query parallelization by partitioning the data output

FImplement query parallelization by partitioning the data input

Answer : B, F

Scale out the query by allowing the system to process each input partition separately.

F: A Stream Analytics job definition includes inputs, a query, and output. Inputs are where the job reads the data stream from.

References:

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-parallelization

Question 7

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB.

You plan to copy the data from the storage account to an Azure SQL data warehouse.

You need to prepare the files to ensure that the data copies quickly.

Solution: You copy the files to a table that has a columnstore index.

Does this meet the goal?

AYes

BNo

Answer : B

Instead modify the files to ensure that each row is less than 1 MB.

References:

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/guidance-for-loading-data

Microsoft DP-200 Implementing an Azure Data Solution Exam Practice Test