DP-500 Dumps

DP-500 Braindumps DP-500 Real Questions DP-500 Practice Test

DP-500 Actual Questions


killexams.com


Microsoft


DP-500


Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI


https://killexams.com/pass4sure/exam-detail/DP-500


Question: 25


HOTSPOT


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:


Question: 26


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?

  1. [UserPermissions] – USERNAME()

  2. [UserPermissions] – USERPRINCIPALNAME()

  3. [User] = USERPRINCIPALNAME()

  4. [User] = USERNAMEQ()

  5. [User] = USEROBJECTID()


Answer: D


Question: 27


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?

  1. Seaborn only

  2. Matplotlib and Seaborn

  3. Matplotlib only

  4. Matplotlib and TensorFlow

  5. TensorFlow only

  6. Seaborn and TensorFlow


Answer: E Question: 28 HOTSPOT

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. NOTE: Each correct selection is worth one point.



Answer:


Question: 29


DRAG DROP


You need to integrate the external data source to support the planned changes.


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:


Question: 30


HOTSPOT


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. NOTE: Each correct selection is worth one point.


Answer: