| Question.16 You have a service published to a website. When you connect to the website, you receive the following data.  You need to create a query that retrieves the Categories data and the Customers data. Which type of source should you use? (A) JSON (B) Text/CSV (C) OData Feed (D) XML |
16. Click here to View Answer
Answer is (C) OData Feed
OData supports two formats for representing the resources (Collections, Entries, Links, etc) it exposes: the XML-based Atom format and the JSON format.
Reference:
https://www.odata.org/documentation/odata-version-2-0/atom-format/
| Question.17 In Power BI Desktop, you are updating an existing report that connects to a Microsoft SQL Server database. You use database (SQL authentication) credentials to connect to the source. The last credentials that were entered are expired. You need to update the credentials. Which two actions should you perform? (A) Open the Data Source Settings dialog box and locate the data source. (B) Select Edit Permissions and enter new credentials. (C) Open the Get Data dialog box and make a new connection to the database. (D) Open the Options dialog box and allow data previews to download in the background. |
17. Click here to View Answer
Answer is (A) & (B)
| Question.18 You plan to populate a table in a Power BI dataset with data from a Microsoft SharePoint Online list. Which storage mode will be used? (A) DirectQuery (B) live connection (C) Composite (D) Imported |
18. Click here to View Answer
Answer is (D)
| Question.19 Which data role enables advanced analytics capabilities through reports and visualizations? (A) Data analyst (B) Data scientist (C) Data engineer (D) All of these |
19. Click here to View Answer
Answer is (A) Data analyst
| Question.20 Which data analyst task has critical performance impact on reporting and data analysis? (A) Analyze (B) Visualize (C) Model (D) All of these |
20. Click here to View Answer
Answer is (C) Model