[Apr 07, 2023] 100% Latest Most updated DP-500 Questions and Answers
Try with 100% Real Exam Questions and Answers
What is the salary of Microsoft DP-500 Certified Professional
The average salary in different countries for Microsoft DP-500 Certified Professional
US: 106,000 USD
UK: 60,000 Pounds
IND: 10,00,000 INR
Best Solution for the preparation of Microsoft DP-500 Exam
We provide the best solution for the preparation of Microsoft DP-500 Exam. We provide the best answer to all questions that are asked in Microsoft DP-500 Exam. Our website offers a free demo version of the DP-500 exam, you can check it before buying. If you want to pass the DP-500 exam, please contact us or directly register on our website.
Microsoft DP-500 exam is one of the most challenging exams in IT industry. If you are looking for a professional certification in Information Technology then you should consider taking Microsoft DP-500 exam. For passing this exam, you have to prepare well by studying from the latest Microsoft DP-500 exam dumps PDF guide available online.
Deliver certification questions with answers and explanations to help students obtain their certification by using our Online Web Simulator and Mobile App. It is very important for every professional to get certified because this will give you a competitive edge over others in your field. Those who have earned certifications know how important it is to be certified with their skills and knowledge about their field of study. Our website will provide you with the most up-to-date information regarding Microsoft certification exams; we also offer products that will help you prepare for your exams easily without having to spend thousands of dollars on expensive training courses and other materials provided by other websites which are not reliable at all.
NEW QUESTION 33
You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multiple joins. You
need to reduce the load time of the dataflow.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each
correct selection is worth one point.
- A. Place the ingestion operations and transformation operations in a single dataflow.
- B. Execute foldable operations before non-foldable operations.
- C. Place the ingestion operations and transformation operations in separate dataflows.
- D. Execute non-foldable operations before foldable operations.
- E. Reduce the memory assigned to the dataflows.
Answer: A,B
NEW QUESTION 34
You are optimizing a Power Bl data model by using DAX Studio.
You need to capture the query events generated by a Power Bl Desktop report.
What should you use?
- A. a Query Plan trace
- B. a Server Timings trace
- C. an All Queries trace
- D. the DMV list
Answer: B
NEW QUESTION 35
You are running a diagnostic against a query as shown in the following exhibit.
What can you identify from the diagnostics query?
- A. All the query steps are folding.
- B. Elevated permissions are being used to query records.
- C. Some query steps are folding.
- D. The query is timing out.
Answer: A
Explanation:
Understanding folding with Query Diagnostics
One of the most common reasons to use Query Diagnostics is to have a better understanding of what operations were 'pushed down' by Power Query to be performed by the back-end data source, which is also known as 'folding'. If we want to see what folded, we can look at what is the 'most specific' query, or queries, that get sent to the back-end data source. We can look at this for both ODATA and SQL.
NEW QUESTION 36
You have a 2-GB Power Bl dataset.
You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.
Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
- A. Enable XMLA read-write.
- B. Turn on Large dataset storage format.
- C. Connect the target workspace to an Azure Data Lake Storage Gen2 account.
- D. Enable service principal authentication for read-only admin APIs.
Answer: A,B
Explanation:
Optimize datasets for write operations by enabling large models
When using the XMLA endpoint for dataset management with write operations, it's recommended you enable the dataset for large models. This reduces the overhead of write operations, which can make them considerably faster. For datasets over 1 GB in size (after compression), the difference can be significant.
Tabular Editor supports Azure Analysis Services and Power BI Premium Datasets through XMLA read/write.
Note: Tabular Editor - An open-source tool for creating, maintaining, and managing tabular models using an intuitive, lightweight editor. A hierarchical view shows all objects in your tabular model. Objects are organized by display folders with support for multi-select property editing and DAX syntax highlighting. XMLA read-only is required for query operations. Read-write is required for metadata operations.
Reference:
https://tabulareditor.github.io/
NEW QUESTION 37
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 38
You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data.
You plan to create a security role named User Security for the dataset. You need to filter the dataset based on
the current users. What should you include in the DAX expression?
- A. [User] = USERPRINCIPALNAME()
- B. [UserPermissions] - USERPRINCIPALNAME()
- C. [User] = USERNAMEQ()
- D. [UserPermissions] - USERNAME()
- E. [User] = USEROBJECTID()
Answer: C
NEW QUESTION 39
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 area. NOTE:
Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 40
You have a Power Bl dataset that contains the following measures:
* Budget
* Actuals
* Forecast
You create a report that contains 10 visuals.
You need provide users with the ability to use a slicer to switch between the measures in two visuals only.
You create a dedicated measure named cg Measure switch.
How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate
values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 41
You have a Power BI workspace named Workspace1 that contains five dataflows.
You need to configure Workspace1 to store the dataflows in an Azure Data Lake Storage Gen2 account.
What should you do first?
- A. Change the Data source settings in the dataflow queries.
- B. Disable load for all dataflow queries.
- C. Delete the dataflow queries.
- D. From the Power Bl Admin portal, enable tenant-level storage.
Answer: D
Explanation:
Configuring Azure connections is an optional setting with additional properties that can optionally be set:
* Tenant Level storage, which lets you set a default, and/or
* Workspace-level storage, which lets you specify the connection per workspace You can optionally configure tenant-level storage if you want to use a centralized data lake only, or want this to be the default option.
NEW QUESTION 42
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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.
You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend defining a data source and view for the Parquet files. You recommend updating the query to use the view.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
Explanation:
Solution: You recommend using OPENROWSET WITH to explicitly specify the maximum length for businessName and surveyName.
The size of the varchar(8000) columns are too big. Better reduce their size.
A SELECT...FROM OPENROWSET(BULK...) statement queries the data in a file directly, without importing the data into a table. SELECT...FROM OPENROWSET(BULK...) statements can also list bulk-column aliases by using a format file to specify column names, and also data types.
NEW QUESTION 43
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly
telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry
was captured.
You have the following query in Power Query Editor.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point
Answer:
Explanation:
NEW QUESTION 44
You have a Power Bl data model.
You need to refresh the data from the source every 15 minutes.
What should you do first?
- A. Enable the XMLA endpoint.
- B. Change the storage mode of the dataset.
- C. Define an incremental refresh policy.
- D. Configure a scheduled refresh.
Answer: A
Explanation:
You cannot schedule a refresh on 15-minute increments. Only 30, unless using XMLA endpoint.
NEW QUESTION 45
You are using DAX Studio to query an XMLA endpoint.
You need to identify the duplicate values in a column named Email in a table named Subscription.
How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each
value may be used once, more than once. may need to drag the split bar between panes or scroll to view
content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 46
You are configuring an aggregation table as shown in the following exhibit.
The detail table is named FactSales and the aggregation table is named FactSales(Agg).
You need to aggregate SalesAmount for each store.
Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate options in the answer area, NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 47
You have new security and governance protocols for Power Bl reports and datasets. The new protocols must
meet the following requirements.
* New reports can be embedded only in locations that require authentication.
* Live connections are permitted only for workspaces that use Premium capacity datasets.
Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer
presents part of the solution. NOTE: Each correct selection is worth one point.
- A. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
- B. From the Premium per user settings, set XMLA Endpoint to Off.
- C. From Capacity settings, set XMLA Endpoint to Read Write.
- D. From Tenant settings, set Publish to web to Disable.
- E. From Embed Codes, delete all the codes.
Answer: A
NEW QUESTION 48
You have the following Python code in an Apache Spark notebook.
Which type of chart will the code produce?
- A. a pie chart
- B. an area chart
- C. a stacked bar chart
- D. a bar chart
Answer: B
Explanation:
The matplotlib.pyplot.fill_between function fills the area between two horizontal curves.
The curves are defined by the points (x, y1) and (x, y2). This creates one or multiple polygons describing the filled area.
NEW QUESTION 49
You have a Power Bl dataset. The dataset contains data that is updated frequently.
You need to improve the performance of the dataset by using incremental refreshes.
Which four actions should you perform in sequence to enable the incremental refreshes? To answer, move the
appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
NEW QUESTION 50
You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. The
dataset uses Import storage mode and contains the following data sources:
* A CSV file in an Azure Storage account
* An Azure Database for PostgreSQL database
You plan to use deployment pipelines to promote the content from development to test to production. There
will be different data source locations for each stage. What should you include in the deployment pipeline to
ensure that the appropriate data source locations are used during each stage?
- A. parameter rules
- B. selective deployment
- C. auto-binding across pipelines
- D. data source rules
Answer: B
NEW QUESTION 51
Your company is migrating its current, custom-built reporting solution to Power BI.
The Power BI tenant must support the following scenarios:
40 reports that will be embedded in external websites. The websites control their own security. The reports will be consumed by 50 users monthly.
Forty-five users that require access to the workspaces and apps in the Power BI Admin portal. Ten of the users must publish and consume datasets that are larger than 1 GB.
Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional 15 users will consume the reports.
You need to recommend a licensing solution for the company. The solution must minimize costs.
Which two Power BI license options should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. 70 Premium per user
- B. 35 Pro
- C. 35 Premium per user
- D. one Embedded
- E. 70 Pro
- F. one Premium
Answer: C,F
Explanation:
B:
Free - 40 reports that will be embedded in external websites. The websites control their own security.
Free - The reports will be consumed by 50 users monthly.
Free + 1 Premium for the Worspace -Forty-five users that require access to the workspaces and apps in the Power BI Admin portal.
F: Ten of the users must publish and consume datasets that are larger than 1 GB.
Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional 15 users will consume the reports.
Power BI Premium per user features and capabilities
* Pixel perfect paginated reports are available for operational reporting capabilities based on SSRS technology. Users can create highly formatted reports in various formats such as PDF and PPT, which are embeddable in applications and are designed to be printed or shared.
Note: There are three kinds of Power BI per-user licenses: Free, Pro, and Premium Per User.
Power BI (free): Access to content in My Workspace
Power BI (free) + Workspace is Premium: Consume content shared with them Power BI Pro: Publish content to other workspaces, share dashboards, subscribe to dashboards and reports, share with users who have a Pro license Power BI Pro + Workspace is Premium: Distribute content to users who have free licenses Power BI Premium Per User: Publish content to other workspaces, share dashboards, subscribe to dashboards and reports, share with users who have a Premium Per User license Power BI Premium Per User + Workspace is Premium: Distribute content to users who have free and Pro licenses
NEW QUESTION 52
You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode.
A database administrator reports a drastic increase in the number of queries sent from the Power BI service to an Azure SQL database since the creation of the deployment pipeline.
An investigation into the issue identifies the following:
One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows.
When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset.
You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production.
What should you recommend?
- A. Create a dataset parameter to reduce the fact table row count in the development and test pipelines.
- B. Turn off auto refresh when publishing the dataset changes to the Power Bl service.
- C. Enable the large dataset storage format for workspace.
- D. In the dataset. change the fact table from an import table to a hybrid table.
Answer: D
Explanation:
Hybrid tables
Hybrid tables are tables with incremental refresh that can have both import and direct query partitions. During a clean deployment, both the refresh policy and the hybrid table partitions are copied. When deploying to a pipeline stage that already has hybrid table partitions, only the refresh policy is copied. To update the partitions, refresh the table.
Refreshes are faster - Only the most recent data that has changed needs to be refreshed.
NEW QUESTION 53
You need to build a Transact-SQL query to implement the planned changes for the internal users.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 54
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. rollup
- B. explain
- C. freqltems
- D. describe
Answer: D
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 55
......
New Microsoft DP-500 Dumps & Questions: https://www.exam-killer.com/DP-500-valid-questions.html
Dumps to Pass your DP-500 Exam with 100% Real Questions and Answers: https://drive.google.com/open?id=12J4peHCqiDMwsrdRBryMVIcmnOxNBuuF
