Need Help!!!

[Anonymous]

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?

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

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

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

True 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

Create a report and publish with user interactions. Then Create a dashboard from that report with no user interaction. 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 Create the Dataset in Power BI Service using data flow, then use that dataset in those two reports All of the above

[v-kelly-msft]

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]

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?	Edit the interactions from the Format Menu Set a visual level filter on the bar chart Set a visual level filter on the donut chart 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 user1@contoso.com with the ability to edit and publish the reports What should you do?	Configure security for the dataset used by the app Share the dashboard and then modify the access settings of the dashboard From the app workspace, click Update app, and then configure the Access settings Modify the members of the app workspace	Modify the members of the app workspace.
	What are the combination of Data Source Connection modes can be used together in a report	Import, Direct Import, Live Direct, Live Import, Direct, Live 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?	Deploy an on premise data gateway , connect to the data by using the Direct Query  Data Connectivity mode. Deploy an on premise data gateway, Connect to the data by using the import Data Connectivity mode, Deploy an on-premises data gateway (personal mode) Connect to the data by using the Direct Query Data Connectivity mode Deploy an on-premises data gateway (personal mode) Connect to the data by using the Import Data Connectivity mode.	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?	From the Office 365 Admin Centre, You remove the Power BI License form user1 From the Power BI Admin Portal, You modify the Dashboard Settings. From the properties of each dashboard, you modify the share settings. None of the Above	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	True False	False
9	Choose which ever the Below Options are true	Power BI Workspaces are used to publish the reports We can share the report to entire organization from the Power BI Workspace We can share a Group of reports using Power BI Service App There is a Possibility in Power BI Service to share the report outside of the organization None of the above are true	Power BI Workspaces are used to publish the reports 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?	Deploy an on-premises data gateway (personal mode) and configure the connection to Sales DB to use the Direct Query Data Connectivity mode. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live Option Deploy and on-premises data gateway and configure the connection to SalesDB to use the Connectivity mode. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Direct Query Data Connectivity mode	Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live Option

[amitchandak]

@Anonymous , For the first two I think

1

2