100% Passing Guarantee - Brilliant DP-500 Exam Questions PDF [Apr-2024]
DP-500 Dumps 2024 - NewMicrosoft DP-500 Exam Questions
NEW QUESTION # 77
You use Azure Synapse Analytics and Apache Spark notebooks to You need to use PySpark to gain access to
the visual libraries. Which Python libraries should you use?
- A. Matplotlib only
- B. Matplotlib and TensorFlow
- C. Matplotlib and Seaborn
- D. Seaborn and TensorFlow
- E. Seaborn only
- F. TensorFlow only
Answer: F
NEW QUESTION # 78
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and
Commission. A sample of the data in the Sales table is shown in the following table.
A sample of the data in the Commission table is shown in the following table.
You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 79
You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You need to present
the data distribution statistics from a DataFrame in a tabular view. Which method should you invoke on the
DataFrame?
- A. freqltems
- B. summary
- C. explain
- D. rollup
Answer: B
NEW QUESTION # 80
You need to create Power BI reports that will display data based on the customers' subscription level.
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.
Answer:
Explanation:
1 - Create row-level security (RLS) roles
2 - Create a DAX expression
3 - Add members to row-level security (RLS) roles
NEW QUESTION # 81
You need to populate the CustomersWithProductScore table.
How should you complete the stored procedure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: FLOAT
Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.
FLOT is used in the last statement of the code: WITH (score FLOAT) as p; From syntax: MODEL The MODEL parameter is used to specify the model used for scoring or prediction. The model is specified as a variable or a literal or a scalar expression.
Box 2: dbo.CustomerWithProductScore
Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.
Only table CustomerWithProductScore has the required filed score.
From the syntax:
DATA
The DATA parameter is used to specify the data used for scoring or prediction. Data is specified in the form of a table source in the query. Table source can be a table, table alias, CTE alias, view, or table-valued function.
Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/predict-transact-sql
NEW QUESTION # 82
You are implementing a reporting solution that has the following requirements:
* Reports for external customers must support 500 concurrent requests. The data for these reports is approximately 7 GB and is stored in Azure Synapse Analytics.
* Reports for the security team use data that must have local security rules applied at the database level to restrict access. The data being reviewed is 2 GB.
Which storage mode provides the best response time for each group of users?
- A. DirectQuery for the external customers and import for the security team.
- B. DirectQuery for the external customers and DirectQuery for the security team.
- C. Import for the external customers and DirectQuery for the security team.
- D. Import for the external customers and import for the security team.
Answer: A
Explanation:
Explanation
With DirectQuery, queries are sent back to your Azure Synapse Analytics in real time as you explore the data.
Real-time queries, combined with the scale of Synapse Analytics enables users to create dynamic reports in minutes against terabytes of data.
Need import for the security team for local security rules.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-data-warehouse-with-direct-connect
Topic 1, Contoso, Ltd
Overview
Contoso, Ltd. is a company that sells enriched financial data to a variety of external customers.
Contoso has a main office in Los Angeles and two branch offices in New York and Seattle.
Data Infrastructure
Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines.
The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access alt the data.
Contoso has one Power Bl workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer.
The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool.
Users frequently query the Synapse Analytics workspace by using Transact-SQL.
User Problems
Contoso identifies the following user issues:
* Some users indicate that the visuals in Power Bl reports are slow to render when making filter selections.
* Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded.
* Users indicate that the data in Power Bl reports is stale. You discover that the refresh process of the Power Bl model occasionally times out Planned Changes Contoso plans to implement the following changes:
* Into the existing Power Bl dataset, integrate an external data source that is accessible by using the REST API.
* Build a new dataset in the FinData workspace by using data from the Synapse Analytics dedicated SQL pool.
* Provide all the customers with their own Power Bl workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace.
* Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data.
* Deploy prebuilt datasets to Power Bl to simplify the query experience of the customers.
* Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool.
NEW QUESTION # 83
You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort.
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.
Answer:
Explanation:
Explanation
Step 1: From powerbi.com, create a new report..
The company wants custom Power BI usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.
Step 2: Add a report measure
Measures are used in some of the most common data analyses. Simple summarizations such as sums, averages, minimum, maximum and counts can be set through the Fields well. The calculated results of measures are always changing in response to your interaction with your reports, allowing for fast and dynamic ad-hoc data exploration.
Step 3: Add visuals to the report
Step 4: Publish the report to the Sales Analytics workspace
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-measures
NEW QUESTION # 84
You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.
You need to create a chart that will show the total trip distance according to the number of passengers as shown in the following exhibit.
How should you configure the chart? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 85
You have the following Python code in an Apache Spark notebook.
Which type of chart will the code produce?
- A. a pie chart
- B. a stacked bar chart
- C. an area chart
- D. a bar chart
Answer: D
NEW QUESTION # 86
You need to ensure that the new process for deploying reports and datasets to the User Experience workspace meets the technical requirements.
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.
Answer:
Explanation:
1 - Create a Power BI deployment pipeline.
2 - Creatre deployment rules for the development and test stages.
3 - Assign the workspaces to the correct stages.
NEW QUESTION # 87
You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics.
You need to present the data distribution statistics from a DataFrame in a tabular view.
Which method should you invoke on the DataFrame?
- A. explain
- B. cov
- C. describe
- D. rollup
Answer: C
Explanation:
The aggregating statistic can be calculated for multiple columns at the same time with the describe function.
Example:
titanic[["Age", "Fare"]].describe()
Out[6]:
Age Fare
count 714.000000 891.000000
mean 29.699118 32.204208
std 14.526497 49.693429
min 0.420000 0.000000
25% 20.125000 7.910400
50% 28.000000 14.454200
75% 38.000000 31.000000
max 80.000000 512.329200
NEW QUESTION # 88
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 section, you will NOT be able to return to it. As a result, these questions
will not appear in the review screen.
You have the Power Bl data model shown in the exhibit. (Click the Exhibit tab.)
Users indicate that when they build reports from the data model, the reports take a long time to load.
You need to recommend a solution to reduce the load times of the reports.
Solution: You recommend moving all the measures to a calculation group.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 89
You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the
following requirements:
* Security admins must identify when users export reports from Power Bl within five days of a new sensitivity
label being applied to the artifacts in Power Bl.
* Power Bl admins must identify updates or changes to the Power Bl capacity.
* The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 90
You open a Power Bl Desktop report that contains an imported data model and a single report page.
You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces the results shown in the following exhibit
What can you identify from the results?
- A. Unoptimized DAX queries cause the page to load slowly.
- B. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.
- C. The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
- D. The Actual/Forecast Billable Hrs YTD visual displays the most data.
Answer: B
Explanation:
Explanation
Most time is spent in the category Other - time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing.
Note: Each visual's log information includes the time spent (duration) to complete the following categories of tasks:
DAX query - if a DAX query was required, this is the time between the visual sending the query, and for Analysis Services to return the results.
Visual display - time required for the visual to draw on the screen, including time required to retrieve any web images or geocoding.
Other - time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer
NEW QUESTION # 91
You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen2 account.
You need to query all the files in the 'csv/taxi/' folder and all its subfolders. All the files are in CSV format and have a header row.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: BULK 'csv/taxi*.CSV',
*.CSV to get all the CSV files.
Box 2: FIRSTROW=2
As there is a header we should read from the second line.
Note: 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.
Incorrect:
Not FIRSTROW=1. FIRSTROW=1 is used when there is no header.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset
NEW QUESTION # 92
You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to modify the source control solution to use an Azure DevOps Git repository. What should you do first?
- A. Create a new pull request.
- B. Change the workspace to live mode.
- C. Change the active branch.
- D. Disconnect from the GitHub repository.
Answer: D
Explanation:
Explanation
By default, Synapse Studio authors directly against the Synapse service. If you have a need for collaboration using Git for source control, Synapse Studio allows you to associate your workspace with a Git repository, Azure DevOps, or GitHub.
Prerequisites
Users must have the Azure Contributor (Azure RBAC) or higher role on the Synapse workspace to configure, edit settings and disconnect a Git repository with Synapse.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control
NEW QUESTION # 93
You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements.
What should you do?
- A. Grant the sales managers the Build permission for the existing Power Bl datasets.
- B. Grant the sales managers admin access to the existing Power Bl workspace.
- C. Create a PBIT file and distribute the file to the sales managers.
- D. Create a deployment pipeline and grant the sales managers access to the pipeline.
Answer: C
Explanation:
Allow sales managers to perform ad hoc sales reporting with minimal effort Power BI report templates contain the following information from the report from which they were generated:
Report pages, visuals, and other visual elements
The data model definition, including the schema, relationships, measures, and other model definition items All query definitions, such as queries, Query Parameters, and other query elements What is not included in templates is the report's data.
Report templates use the file extension .PBIT (compare to Power BI Desktop reports, which use the .PBIX extension).
Note: With Power BI Desktop, you can create compelling reports that share insights across your entire organization. With Power BI Desktop templates, you can streamline your work by creating a report template, based on an existing template, which you or other users in your organization can use as a starting point for a new report's layout, data model, and queries. Templates in Power BI Desktop help you jump-start and standardize report creation.
NEW QUESTION # 94
You have the Power BI workspaces shown in the following exhibit.
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal-workspaces
NEW QUESTION # 95
You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset.
During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB." You need to ensure that you can refresh the dataset.
What should you do?
- A. Change License mode to Premium per user.
- B. Connect Workspace1 to an Azure Data Lake Storage Gen2 account
- C. Turn on Large dataset storage format.
- D. Change the location of the Premium capacity.
Answer: D
Explanation:
Assigning workspaces to capacities
Workspaces can be assigned to a Premium capacity in the Power BI Admin portal or, for a workspace, in the Workspace pane.
Note: Capacity limits
Workspace storage limits, whether for My Workspace or an app workspace, depend on whether the workspace is in shared or Premium capacity.
* Shared capacity limits
For workspaces in shared capacity:
There is a per-workspace storage limit of 10 GB.
Premium Per User (PPU) tenants have a 100 TB storage limit.
When using a Pro license, the total usage can't exceed the tenant storage limit of 10 GB multiplied by the number of Pro licenses in the tenant.
* Premium capacity limits
For workspaces in Premium capacity:
There is a limit of 100 TB per Premium capacity.
There is no per-user storage limit.
Workspace storage usage is shown as 0 (as shown in this screenshot) if the workspace is assigned to a Premium capacity.
Incorrect:
Not C: If your organization is using the original version of Power BI Premium, you're required to migrate to the modern Premium Gen2 platform. Microsoft began migrating all Premium capacities to Gen2.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-your-data-storage-in-power-bi
NEW QUESTION # 96
You deploy a tabular model to the Power Bl service. The model is developed and maintained by using Microsoft Visual Studio. Power Bl connects to the model by using the Connect live option.
You need to recommend a source control solution for the model and the report files.
What should you include in the recommendation for each type of file? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
NEW QUESTION # 97
You have an Azure Synapse Analytics serverless SQL pool.
You need to catalog the serverless SQL pool by using Azure Purview.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Create a managed identity in Azure Active Directory (Azure AD).
- B. Register a data source.
- C. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.
- D. Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.
- E. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.
Answer: A,D,E
Explanation:
Authentication for enumerating serverless SQL database resources
There are three places you'll need to set authentication to allow Microsoft Purview to enumerate your serverless SQL database resources:
The Azure Synapse workspace
The associated storage
The Azure Synapse serverless databases
The steps below will set permissions for all three.
Azure Synapse workspace
In the Azure portal, go to the Azure Synapse workspace resource.
On the left pane, selectAccess Control (IAM).
Select the Add button.
Set the Reader role and enter your Microsoft Purview account name, which represents its managed service identity (MSI).
Select Save to finish assigning the role
Azure Synapse Analytics serverless SQL pool catalog Purview Azure Purview managed service identity Storage account In the Azure portal, go to the Resource group or Subscription that the storage account associated with the Azure Synapse workspace is in.
On the left pane, selectAccess Control (IAM).
Select the Add button.
Set the Storage blob data reader role and enter your Microsoft Purview account name (which represents its MSI) in the Select box.
Select Save to finish assigning the role.
Azure Synapse serverless database
Go to your Azure Synapse workspace and open the Synapse Studio.
Select the Data tab on the left menu.
Select the ellipsis (...) next to one of your databases, and then start a new SQL script.
Add the Microsoft Purview account MSI (represented by the account name) on the serverless SQL databases. You do so by running the following command in your SQL script:
SQL
CREATE LOGIN [PurviewAccountName] FROM EXTERNAL PROVIDER;
Apply permissions to scan the contents of the workspace
You can set up authentication for an Azure Synapse source in either of two ways. Select your scenario below for steps to apply permissions.
Use a managed identity
Use a service principal
NEW QUESTION # 98
You have a file named File1.txt that has the following characteristics:
* A header row
* Tab delimited values
* UNIX-style line endings
You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.
Which query should you execute?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: A
Explanation:
Explanation
Use FIELDTERMINATOR ='\t' for tab.
Use ROWTERMINATOR ='\0x0A ' for UNIX-style line endings
Use FIRSTROW= 2 for a header row
Note: Using Row Terminators
The row terminator can be the same character as the terminator for the last field. Generally, however, a distinct row terminator is useful. For example, to produce tabular output, terminate the last field in each row with the newline character (\n) and all other fields with the tab character (\t).
If you want to output a line feed character only (LF) as the row terminator - as is typical on Unix and Linux computers - use hexadecimal notation to specify the LF row terminator. For example:
bcp -r '0x0A'
FIRSTROW
FIRSTROW =first_row Specifies the number of the first row to load. The default is 1. This 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/sql/relational-databases/import-export/specify-field-and-row-terminators-sql-se
https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql
NEW QUESTION # 99
......
The Microsoft DP-500 exam measures the candidate's ability to design and implement enterprise-scale data solutions that include data storage, processing, and analytics. Candidates must also demonstrate their proficiency in designing and implementing data security, compliance, and privacy solutions using Azure services. DP-500 exam covers topics such as data ingestion, data transformation, data visualization, and data modeling.
The Microsoft DP-500 exam tests the candidate's knowledge of data storage options, data processing solutions, and data analytics tools. It also evaluates their ability to design, implement, and optimize big data solutions using Microsoft Azure technologies such as Data Lake Storage, Azure Databricks, and Azure Synapse Analytics. Additionally, the exam also measures the candidate's ability to use Power BI to build, deploy, and maintain business intelligence solutions.
Free DP-500 braindumps download: https://www.validvce.com/DP-500-exam-collection.html
DP-500 Dumps for Pass Guaranteed - Pass DP-500 Exam: https://drive.google.com/open?id=1nTOfqBS2U_Caw2Ck7RAWshm35Q0gKu7h
