DP-500 無料問題集「Microsoft Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI」
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 se 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 a Power Query query in a Power Bl report. The query maps source database columns to the input columns of a time series machine learning model.
You discover that the model fails to process a source time field.
You need to ensure that the model processes the field.
Solution: You add a Power Query step to convert the time column into an integer column that represents the number of minutes.
Does this meet the requirement?
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 a Power Query query in a Power Bl report. The query maps source database columns to the input columns of a time series machine learning model.
You discover that the model fails to process a source time field.
You need to ensure that the model processes the field.
Solution: You add a Power Query step to convert the time column into an integer column that represents the number of minutes.
Does this meet the requirement?
正解：B
解答を投票する
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.
From Power Query Editor, you profile the data s
the following exhibit
The loT GUID and loT ID columns are unique to each row in the query.
You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You change the loT DateTime column to the date data type.
Does this meet the goal?
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.
From Power Query Editor, you profile the data s
the following exhibit
The loT GUID and loT ID columns are unique to each row in the query.
You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You change the loT DateTime column to the date data type.
Does this meet the goal?
正解：B
解答を投票する
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.
From Power Query Editor, you profile the data shown in the following exhibit.
From Power Query Editor, you profile the data shown in the following exhibit The loT GUIO and loT ID columns are unique to each row in the query.
You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You remove the loT GUID column and retain the loT ID column.
Does this meet the goal?
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.
From Power Query Editor, you profile the data shown in the following exhibit.
From Power Query Editor, you profile the data shown in the following exhibit The loT GUIO and loT ID columns are unique to each row in the query.
You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You remove the loT GUID column and retain the loT ID column.
Does this meet the goal?
正解：B
解答を投票する
You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.
You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.
Which type of pool should you recommend?
You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.
Which type of pool should you recommend?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a Power BI tenant.
You plan to register the tenant in an Azure Purview account.
You need to ensure that you can scan the tenant by using Azure Purview.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to register the tenant in an Azure Purview account.
You need to ensure that you can scan the tenant by using Azure Purview.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正解：B、D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You need to implement object-level security (OLS) in the Power Bl dataset for the sales associates.
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.
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.
正解：
1 - From Power BI Desktop, create a role for the sales associates.
2 - From Tabular Editor, set Object Level Security to None for the Customer[Email] column and save the changes.
3 - From Power BI Desktop, publish the dataset to the Sales Analytics workspace.
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 using openrowset with to explicitly define the collation for businessName and surveyName as Latim_Generai_100_BiN2_UTF8.
Does this meet the goal?
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 using openrowset with to explicitly define the collation for businessName and surveyName as Latim_Generai_100_BiN2_UTF8.
Does this meet the goal?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)