Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-100

Microsoft DP-100 Exam
Designing and Implementing a Data Science Solution on Azure (Page 23 )

Updated On: 1-Feb-2026
Page 20 of 102
PDF with 422 Questions

You are profiling data by using Azure Machine Learning studio.
You need to detect columns with odd or missing values.
Which statistic should you analyze?

  1. Profile
  2. Std deviation
  3. Error count
  4. Type

Answer(s): C



HOTSPOT (Drag and Drop is not supported)

You plan to use a curated environment to run Azure Machine Learning training experiments in a workspace.
You need to display all curated environments and their respective packages in the workspace.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



HOTSPOT (Drag and Drop is not supported)

You use an Azure Machine Learning workspace. The default datastore contains comma-separated values (CSV) files.
The CSV files must be made available for use in experiments and data processing pipelines. The files must be loaded directly into pandas dataframes.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



HOTSPOT (Drag and Drop is not supported)
You create a new Azure Databricks workspace.
You configure a new cluster for long-running tasks with mixed loads on the compute cluster as shown in the image below.
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.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: No
Running user code in separate processes is not possible in Scala.
Box 2: No
Autoscaling is enabled. Minimum 2 workers, Maximum 8 workers.


Reference:

https://docs.databricks.com/clusters/configure.html



HOTSPOT (Drag and Drop is not supported)
You create an Azure Machine Learning workspace named workspace1. You assign a custom role to a user of workspace1.
The custom role has the following JSON definition:
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: No
The actions listed in NotActions are prohibited.
If the roles include Actions that have a wildcard (*), the effective permissions are computed by subtracting the NotActions from the allowed Actions.
Box 2: No
Deleting compute resources in the workspace is in the NotActions list.
Box 3: Yes
Writing metrics is not listed in NotActions.


Reference:

https://docs.microsoft.com/en-us/azure/role-based-access-control/overview#how-azure-rbac-determines-if-a-user-has-access-to-a-resource



Viewing page 23 of 102
Viewing questions 111 - 115 out of 422 questions



Post your Comments and Discuss Microsoft DP-100 exam prep with other Community members:

Join the DP-100 Discussion