Q18. You are creating a Python visual in Power Bl Desktop.
You need to retrieve the value of a column named Unit Price from a DataFrame.
How should you reference the Unit Price column in the Python code?

Q19. You plan to generate a line chart to visualize and compare the last six months of sales data for two
departments. You need to increase the accessibility of the visual. What should you do?

Q20. You need to create Power BI reports that will display data based on the customers’ subscription level.
順番に実行すべき3つのアクションはどれでしょう？答えるには、アクションのリストから適切なアクションを解答エリアに移動し、正しい順番に並べます。

Q21. You are creating a Power Bl Desktop report.
You add a Python visual to the report page.
You plan to create a scatter chart to visualize the data.
You add Python code to the Python script editor.
You need to create the scatter chart.
How should you complete the Python code? To answer, select the appropriate options in the answer area.
注意：各選択肢の正誤は1点満点とする。

Q22. このセクションの質問に答えた後は、その質問に戻ることはできません。その結果、これらの質問はレビュー画面には表示されません。
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.
これは目標を達成しているのか？

Q23. You are creating a Power 81 single-page report.
Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.
You need to ensure that the users can consume content on a report page in a logical order.
What should you configure on the report page?

Q24. You are planning a Power Bl solution for a customer.
The customer will have 200 Power Bl users. The customer identifies the following requirements:
* Ensure that all the users can create paginated reports.
* Ensure that the users can create reports containing Al visuals.
* Provide autoscaling of the CPU resources during heavy usage spikes.
You need to recommend a Power Bl solution for the customer. The solution must minimize costs. What should
you recommend?

Q25. 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.
何をお勧めしますか？

Q26. データ・リフレッシュの問題の根本原因を特定する必要があります。
何を使うべきか？

Q27. You have a Power Bl dataset that has the query dependencies shown in the following exhibit.

ドロップダウンメニューを使用して、図に示されている情報に基づいて、各ステートメントを完成させる回答の選択肢を選択します。
注意：各選択肢の正誤は1点満点とする。

Q28. 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.
注意：各選択肢の正誤は1点満点とする。

Q29. You need to recommend a solution for the customer workspaces to support the planned changes.
Which two configurations should you include in the recommendation? Each correct answer presents part of the
solution.
注意：各選択肢の正誤は1点満点とする。

Q30. You have the following code in an Azure Synapse notebook.

Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the code.
注意：各選択肢の正誤は1点満点とする。

Q31. Azure Synapse AnalyticsサーバーレスSQLプールを使用して、Apache Parquet形式のネットワーク トラフィック ログをクエリしています。データのサンプルを次の表に示します。

送信元IPアドレスを返すTransact-SQLクエリを作成する必要があります。
送信元IPアドレスを取得するには、select文でどの関数を使用すればよいですか？

Q32. 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?

Q33. You need to recommend a solution to ensure that sensitivity labels are applied. The solution must minimize administrative effort.
Which three actions should you include in the recommendation? Each correct answer presents part of the solution.
注意：各選択肢の正誤は1点満点とする。

Q34. You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.
順番に実行すべき4つのアクションはどれでしょう？答えるには、アクションのリストから適切なアクションを解答エリアに移動し、正しい順番に並べます。

Q35. 注：この問題は、同じシナリオを提示する一連の問題の一部です。シリーズの各問題
には、指定された目標を満たす可能性のあるユニークな解答が含まれています。問題によっては
正解がある場合もあれば、正解がない場合もある。
このセクションの質問に答えた後は、その質問に戻ることはできません。そのため、これらの質問は
はレビュー画面に表示されません。
あなたは展示に示されているPower Blデータモデルを持っています。(Exhibitタブをクリックしてください)。

ユーザーは、データモデルからレポートを作成する際、レポートの読み込みに時間がかかると指摘している。
レポートのロード時間を短縮するソリューションを提案する必要があります。
Solution: You recommend normalizing the data model.
これは目標を達成しているのか？

Q36. 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?