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












































            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?
    A. [UserPermissions] – USERNAME()
    B. [UserPermissions] – USERPRINCIPALNAME()
    C. [User] = USERPRINCIPALNAME()
    D. [User] = USERNAMEQ()
    E. [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?
    A. Seaborn only
    B. Matplotlib and Seaborn
    C. Matplotlib only
    D. Matplotlib and TensorFlow
    E. TensorFlow only
    F. 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:








                         6$03/( 48(67,216








            7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\  )XOO YHUVLRQ LV

            XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV


            .LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ
            H[DP SUHSDUDWLRQ  7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV  H[DP GXPSV  DQG SUDFWLFH WHVWV WR
            KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH  +HUH DUH VRPH NH\
            IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP


            $FWXDO ([DP 4XHVWLRQV  .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG
            LQ WHVW FHQWHUV  7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG
            UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV  %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV  FDQGLGDWHV FDQ
            IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP

            ([DP 'XPSV  .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW  7KHVH GXPSV FRQWDLQ D
            FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV  %\ XVLQJ WKHVH
            GXPSV  FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH
            FHUWLILFDWLRQ H[DP


            3UDFWLFH 7HVWV  .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP
            VLPXODWRU DQG RQOLQH WHVW HQJLQH  7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG
            KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP  7KH SUDFWLFH WHVWV FRYHU D ZLGH
            UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV

            *XDUDQWHHG 6XFFHVV  .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV  7KH\
            FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV  FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\
            ZLOO UHIXQG WKH SXUFKDVH SULFH  7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV
            SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV


            8SGDWHG &RQWHQW  .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR
            HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV  7KLV KHOSV
            FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV


            7HFKQLFDO 6XSSRUW  .LOOH[DPV FRP SURYLGHV IUHH   [  WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV
            ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV  7KHLU FHUWLILHG H[SHUWV
            DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ
            MRXUQH\



                             'PS .PSF FYBNT WJTJU IUUQT   LJMMFYBNT DPN WFOEPST FYBN MJTU
                                .LOO \RXU H[DP DW )LUVW $WWHPSW    *XDUDQWHHG