Microsoft Microsoft Certifications DP-500 Questions & Answers

• Question 131:

  You deploy a tabular model named DM1 to a Power BI Premium capacity. DM1 was created as an import model.

  You change a fact table named Table1 into a hybrid table.

  What else occurred on DM1 automatically after the change?

  A. Table1 was removed from the scheduled refresh.

  B. Dimension tables that relate to Table1 were changed to dual storage mode.

  C. A related aggregation table was created.

  D. A DirectQuery partition was added to Table1.

  Correct Answer: D

• Question 132:

  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. summary

  B. explain

  C. cov

  D. corr

  Correct Answer: A

• Question 133:

  You have a PostgreSQL database named db1.

  You have a group of data analysts that will create Power BI datasets. Each analyst will use data from a different schema in db1.

  You need to simplify the process for the analysts to initially connect to db1 when using Power BI Desktop.

  Which type of file should you use?

  A. PBIT

  B. PBIX

  C. PBIDS

  Correct Answer: C

  To simplify the process for the data analysts to initially connect to the PostgreSQL database (db1) when using Power BI Desktop, you should use a PBIDS (Power BI Data Source) file.

• Question 134:

  You have a Power BI report hosted on the Power BI service. The report displays expenses by department for department managers and contains a line chart that shows expenses by month.

  You need to ensure that users can choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.

  What should you do?

  A. Create a mobile report that contains a column chart.

  B. Add a column chart a bookmark, and a button for users to choose a visual.

  C. Enable report readers to personalize visuals.

  D. Create a separate report page for users to view a column chart.

  Correct Answer: C

  Enable report readers to personalize visuals allows users to customize the visuals based on their preferences. They can choose to switch between a line chart and a column chart without requiring additional development or maintenance effort from the report creator.

• Question 135:

  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. describe

  B. corr

  C. freqItems

  D. explain

  Correct Answer: A

• Question 136:

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IoT GUID and IoT ID columns are unique to each row in the query.

  You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You split the IoT DateTime column into a column named Date and a column named Time.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 137:

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IoT GUID and IoT ID columns are unique to each row in the query.

  You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You remove the IoT ID column and retain the IoT GUID column.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 138:

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IoT GUID and IoT ID columns are unique to each row in the query.

  You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You change the IoT DateTime column to the date data type.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 139:

  You need to use Power BI to ingest data from an API. The API requires that an API key be passed in the headers of the request. Which type of authentication should you use?

  A. organizational account

  B. Basic

  C. Web API

  D. Anonymous

  Correct Answer: C

  https://learn.microsoft.com/en-us/power-query/connector-authentication#select-an-authentication-method

• Question 140:

  You have a Power BI tenant.

  You need to ensure that all reports use a consistent set of colors and fonts. The solution must ensure that the colors and fonts can be applied to existing reports.

  What should you create?

  A. a report theme file

  B. a PBIX file

  C. a Power BI template

  Correct Answer: A