Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need Help!!!

Please select only true statements form the Below Options

1. By Default Measures are working on Filter Context.

2. By Default Calculated Columns are working on Filter Context

3. We can Create Table Relations on Measures

4. We can Create Table relations on calculated columns

5. We can create table relations on both Measures and Calculated Columns

Choose the best option

1) 2,4

2) 1,5

3) 1,4

4) 2,5

5) Not Sure

--------------------------------------------------------------------------------------------------------------

You company has 2,000 users in a Microsoft Office 365 subscription. A Power BI administrator creates 20 dashboards and shares them with 50 users. You discover that a user named user1 can access all the dashboards.

You need to prevent user1 from accessing all the dashboards. Which of the following will be a Solution for this?

    1. From the Office 365 Admin Center, You remove the Power BI License form user1
    2. From the Power BI Admin Portal, You modify the Dashbaord Settings.
    3. From the properties of each dashboard, you modify the share settings.
    4. None of the Above

-----------------------------------------------------------------------------------------------------------------------------------------

Formula engine doesn’t have the cache to reuse the result of the expression

    1. True
    2. False

------------------------------------------------------------------------------------------------------------------------------------------

There is a requirement to create two report with same data source one report should be to display on a screen with no user interaction and another is to embed in the web application with user interactions

While scheduling these two reports, sometimes one of the report got failed due to that we see difference in values between these two reports

So choose what are the below options will be the solution for this issue

      1. Create a report and publish with user interactions. Then

Create a dashboard from that report with no user interaction.

      1. Create a report and publish with user interaction. Then

create a separate report without user interactions in Power BI Service  using same data set in service

      1. Create the Dataset in Power BI Service using data flow, then use that dataset in those two reports

All of the above

Need Help

3 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Based on my understanding:

    Question1:  2) 1,5

    Question2:

    From the Power BI Admin Portal, You modify the Dashbaord Settings.

    Question 3:

    False

    Question 4:

    Create the Dataset in Power BI Service using data flow, then use that dataset in those two reports

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Could someone authenticate the correct answers below, if the answered question are false please mention the correct one. Thanks in Advance.

       

      S.No

      Question

      MCQ's

      Correct Answer

      Comments

      1

      You have a query for a table names sales, Sales has a column named order ID. The Data Typed of Order ID is Whole Number

      You refresh the data and find several errors. You discover that new entries in the sales table contain non-numeric values

      You need to ensure that nonnumeric values in the order ID Column and click Remove Errors

      Does this meet the goal

      True / False

      False

       

      2

      You have a Power BI Report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category

      You need to ensure that when you select a year on the bar char, the donut chart remains unchanged.

      What should you do?

        1. Edit the interactions from the Format Menu
        2. Set a visual level filter on the bar chart
        3. Set a visual level filter on the donut chart
        4. Add a slicer to the page that uses the year column

      Edit the interactions from the Format Menu

       

      3

      Do we need a Data gateway for live connection?

      1.Yes we need of data gateway if the data source is on premise

      2.No we don’t need of Data Gateway if the connection mode is live

      3.Yes, we need of Data Gateway whether the data source is on-Premise or in Cloud

      4.4No we need of Data Gateway while connecting data source using Import of Direct Mode

      3.Yes, we need of Data Gateway whether the data source is on-Premise or in Cloud

       

      4

      In the Power BI Service, you create an app workspace that contains several reports and Dashboards.

      You need to provide a user named [email protected] with the ability to edit and publish the reports

      What should you do?

        1. Configure security for the dataset used by the app
        2. Share the dashboard and then modify the access settings of the dashboard
        3. From the app workspace, click Update app, and then configure the Access settings
        4. Modify the members of the app workspace

      Modify the members of the app workspace.

       

        1.  

      What are the combination of Data Source Connection modes can be used together in a report

        1. Import, Direct
        2. Import, Live
        3. Direct, Live
        4. Import, Direct, Live
        5. None of the above

      Import & Direct

       

      6

      You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organizations You need to ensure that the users will see the current data when they view the dashboard.

      How should you configure the connection to the data source?

        1. Deploy an on premise data gateway , connect to the data by using the Direct Query  Data Connectivity mode.
        2. Deploy an on premise data gateway, Connect to the data by using the import Data Connectivity mode,
        3. Deploy an on-premises data gateway (personal mode) Connect to the data by using the Direct Query Data Connectivity mode
        4. Deploy an on-premises data gateway (personal mode) Connect to the data by using the Import Data Connectivity mode.
        1. Deploy an on-premises data gateway (personal mode) Connect to the data by using the Direct Query Data Connectivity mode

       

      7

      You company has 2,000 users in a Microsoft Office 365 subscription. A Power BI administrator creates 20 dashboards and shares them with 50 users. You discover that a user named user1 can access all the dashboards.

      You need to prevent user1 from accessing all the dashboards. Which of the following will be a Solution for this?

        1. From the Office 365 Admin Centre, You remove the Power BI License form user1
        2. From the Power BI Admin Portal, You modify the Dashboard Settings.
        3. From the properties of each dashboard, you modify the share settings.
        4. None of the Above
        1. From the Power BI Admin Portal, You modify the Dashboard Settings.

       

      8

      Formula engine doesn’t have the cache to reuse the result of the expression

        1. True
        2. False

      False

       

      9

      Choose which ever the Below Options are true

        1. Power BI Workspaces are used to publish the reports
        2. We can share the report to entire organization from the Power BI Workspace
        3. We can share a Group of reports using Power BI Service App
        4. There is a Possibility in Power BI Service to share the report outside of the organization
        5. None of the above are true
        1. Power BI Workspaces are used to publish the reports
        2. We can share the report to entire organization from the Power BI Workspace

       

      10

      You Plan to use Power BI Desktop to create a report. The Report will consume data from an on-premises tabular data named SalesDB in Microsoft SQL Server Analysis Service . The report will be published to the Power BI Service. You need to ensure that the report published to the Power BI Service will access the current data in SalesDB

      What should you do?

        1. Deploy an on-premises data gateway (personal mode) and configure the connection to Sales DB to use the Direct Query Data Connectivity mode.
        2. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live Option
        3. Deploy and on-premises data gateway and configure the connection to SalesDB to use the Connectivity mode.
        4. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Direct Query Data Connectivity mode
        1. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live Option