DP-500 Question #91: Real Exam Question with Answer & Explanation

Question

You need to verify that your PBIDS file is functional. For each of the following statements, select Yes if the statement is true. Otherwise, select No. ```yaml version: "0.1", connections: [ { details: { protocol: "tds", address: { server: "smyServerName-here", database: "myDBName-here" } }, authentication: "null", query: null, options: {}, mode: null } ] ``` Statement 1: This PBIDS file supports DirectQuery, Import and Live Connect connectivity modes. Statement 2: This PBIDS file excludes table and schema information. Statement 3: This PBIDS file supports column-level encryption for the data source.

Explanation

Explanation: Although it supports the DirectQuery and Import connectivity modes, this PBIDS file does not support the Live Connect mode. Power BI Desktop data sources have a specific structure and they are saved with the PBIDS file extension. The sample PBIDS file which is provided in the use-case scenario only supports DirectQuery or Import connectivity modes. Given that the 'mode' parameter reads null, this means that the user will be prompted to select either the DirectQuery or Import connectivity mode when they open the file via Power BI Desktop. Live Connect is not supported as a connectivity mode for a data source in the PBIDS file.

This PBIDS file excludes table and schema information. Given that the "authentication" parameter reads null, in addition to excluding table and schema information, the PBIDS file does not include any authentication information.

This PBIDS file does not support column-level encryption for the data source. If the data source had underlying columns which are encrypted, an error would be returned when trying to Import the data source.

Correct Answers: Statement 1: No Statement 2: Yes Statement 3: No

No community discussion yet for this question.