DP-600 sample exam questions

QuickVisualize from the powerbiclient package, called with get_dataset_config(df), auto-generates a new Power BI report from the DataFrame and renders it in the notebook. It does not embed an existing report (that uses the Report class), and it does not output a statistical summary of the DataFrame as describe() would.

TRUNCATE TABLE requires ALTER permission on the table, and granting ALTER ON SCHEMA::schemaA covers every table in schemaA only. CONNECT only allows connecting and EXECUTE runs procedures; DATABASE:: would cover all schemas and OBJECT:: targets a single object, not a schema.

Tables in the lakehouse must be stored in delta format to appear automatically in Lakehouse explorer. saveAsTable takes a table name rather than a folder path, so passing sales creates a managed table with that name.

A FILTER over a single Import-mode column used as a CALCULATE filter can be replaced by a simple predicate wrapped in KEEPFILTERS, which the storage engine applies directly without iterating a table, so it runs faster. When FILTER references measures, nested CALCULATE or columns from several tables, KEEPFILTERS cannot express the same logic as a simple column filter.

ISEMPTY(RELATEDTABLE('Order Item')) returns TRUE for customers with no order items, which reverses the original logic (customers whose order item count is greater than zero), so the query returns the wrong customers. The correct optimization is NOT ISEMPTY(CALCULATETABLE('Order Item')).

A Lookup activity executes the stored procedure against the warehouse and exposes the returned row(s) as activity output that downstream activities can reference. KQL runs Kusto queries, Switch is control flow, and Append variable only adds a value to an array variable.

An Amazon S3 shortcut connection authenticates with an AWS IAM user's access key ID and secret access key. SAS tokens belong to Azure Storage, and certificate thumbprints or a generic access ID are not used for S3 shortcuts.

A product dimension holds descriptive attributes of a product: the key ProductID plus ProductName and ProductColor. TransactionID, Date and SalesAmount describe individual sales transactions and belong in the FactSales table.

The large semantic model storage format improves XMLA write operation performance and allows models bigger than 10 GB, so XMLA-based deployments of Model1 complete faster. Small format is slower for XMLA writes, and the web editing and shortcut cache settings do not affect deployment time.

A Lookup activity can execute the stored procedure in the warehouse and expose the returned values as output for downstream activities. Get metadata returns file or table metadata, Switch is control flow, and Append variable only modifies an array variable.

A dynamic format string for the measure uses a DAX expression to return a format string such as the selected currency's symbol, so the value keeps its numeric type but shows the right symbol. Field parameters switch fields, linguistic schemas serve Q&A, and WINDOW is a calculation function.

Retired Roles is matched on Role then Division, so Employee needs the same two columns in that order. Left Anti keeps only Employee rows with no match, removing retired roles. The wording about duplicates is loose, but this is the join that excludes rows found in both queries.

Without a Lookup option, the Script activity is the choice: it can run a query or EXEC the stored procedure against the warehouse and returns result sets in its output for downstream activities. The Stored procedure activity runs the procedure but does not return its result set, and Get metadata and Append variable do not execute procedures.

Tabular Editor writes changes to a published model through the XMLA endpoint, which needs read-write access, so set XMLA Endpoint to Read Write in the Power BI workload settings of Capacity1. Git integration, external sharing and managed private endpoints do not enable XMLA writes.

DirectQuery keeps the large fact table current for near-real-time reporting. Dual dimensions can answer slicer queries from cache and join efficiently with the DirectQuery fact table, which keeps queries fast and avoids weak relationships. Import dimensions would be weakly related to the fact table and perform worse.