DP-600 Practice Test

Answer choices

1. A. Use the shortcut because referenced data is always independently retained, as the primary implementation for the described business requirement.
2. B. Create more connections until transformations appear automatically, as the selected approach for the stated technical and business outcome.
3. C. Use only destination sharing links as the ingestion method, under the stated technical, operational, and governance constraints.
4. D. Ingest a managed copy, implement transformations, and configure downstream authorization separately from the source connection, for the required business outcome.

Wrong-answer review

• A. Use the shortcut because referenced data is always independently retained, as the primary implementation for the described business requirement.: A shortcut references the target and does not create the required retained copy.
• B. Create more connections until transformations appear automatically, as the selected approach for the stated technical and business outcome.: Connections do not generate business transformations merely by being duplicated.
• C. Use only destination sharing links as the ingestion method, under the stated technical, operational, and governance constraints.: Sharing links authorize access and do not ingest or transform source records.

Answer choices

1. A. PBIDS only, for the required maintain a data analytics solution outcome.
2. B. PBIP, as the organization’s selected response.
3. C. A PDF export, as the recommended response to this scenario.
4. D. A collection of table CSV files, within this design.

Answer choices

1. A. Use ISBLANK to rewrite source rows and recalculate the expression each time, within the defined security and accountability boundaries.
2. B. Store the filtered balance in a DAX variable and use an information function to branch on its state, within organization-wide risk-and-accountability boundaries.
3. C. Create a relationship whose key is the blank status, for the described technical objective and its associated operational control requirements, within this context.
4. D. Replace the source column with formatted text, for the described technical objective and its associated operational control requirements, within the defined security and accountability boundaries.

Answer choices

1. A. Enumerate every effective access path and inspect whether the principal or its group is included in an applicable OneLake role, for the specified implementation requirement.
2. B. Delete the service principal without investigating dependencies, for the described technical objective and its associated operational control requirements, for the required maintain a data analytics solution outcome.
3. C. Check only direct item permissions because group membership cannot grant OneLake access, as the selected approach for the stated technical and business outcome.
4. D. Apply a stricter sensitivity label and assume the label revokes every permission, for the required maintain a data analytics solution outcome.

Answer choices

1. A. A Power BI template (.pbit) file exported from the finished report
2. B. Power BI Desktop project format with a .pbip project file
3. C. A TMDL definition file as the only file for both report visuals and model
4. D. A PBIX report committed through Git Large File Storage

Answer choices

1. A. A SQL view over Customer and Account, as the primary implementation for the described business requirement.
2. B. A nightly copied table, under the described prepare data criteria.
3. C. An imported semantic-model table used as the warehouse object, under the stated decision criteria.
4. D. A static CSV stored in Lakehouse Files, under end-to-end security-and-governance requirements.

Answer choices

1. A. Relate Sales[SaleKey] to Customer[CustomerKey] as one-to-one, for the described technical objective and its associated operational control requirements.
2. B. Put Sales on the one side and Customer on the many side, for the described technical objective and its associated operational control requirements, as presented.
3. C. Create a bridge table even though each sale has one customer, in this situation.
4. D. Put Customer on the one side and Sales on the many side using CustomerKey, as proposed.

Answer choices

1. A. Add a sensitivity label, for the described technical objective and its associated operational control requirements, as described.
2. B. Create a OneLake shortcut, for the described technical objective and its associated operational control requirements, for this requirement.
3. C. Use a field parameter to deploy the role, within the defined security and accountability boundaries.
4. D. Enable XMLA read-write and grant sufficient semantic model permissions to the caller

Answer choices

1. A. A warehouse-generated surrogate key for each dimension version
2. B. The current account display name, within organization-wide risk-and-accountability boundaries.
3. C. The mutable operational AccountNumber alone, within the defined security and accountability boundaries.
4. D. The fact table's transaction amount, within the documented operational, security, ownership, and validation requirements.

Answer choices

1. A. The semantic model project's definition folder containing TMDL files
2. B. The report project's StaticResources folder containing report image assets
3. C. The semantic model project's diagramLayout.json file containing diagram coordinates
4. D. The report project's report.json file containing report visual layout metadata