Prepstellar
Get the app

DP-600 · Practice set 8 of 8

XMLA Semantic Model Management: 10 practice questions

10 questions · Untimed · Free

10 free DP-600 practice questions on XMLA Semantic Model Management, with an explanation for every answer. Untimed. The full mock exam and the timed version are in the app.

Set 8 · XMLA Semantic Model Management · 10 questions Read the lesson

  1. Question 1 of 10

    Which XMLA access mode is enabled by default?

    1. ARefresh-only access
    2. BDeployment-only access
    3. CRead-only access
    4. DRead-write mode
    Show the answer

    The default permits queries against model data and metadata; modification and deployment belong to the administrator-enabled read-write mode.

    Next → 1 / 10

  2. Question 2 of 10

    Which XMLA access mode supports deploying semantic model changes from an external tool?

    1. AMetadata-only access
    2. BRead-write access
    3. CQuery-only access
    4. DRead-only access
    Show the answer

    Deployment modifies the model, so it requires read-write access; the default read-only mode is limited to querying data and metadata.

    Next → 2 / 10

  3. Question 3 of 10

    What does the documented XMLA connection string target?

    1. AA model table
    2. BA Fabric notebook cell
    3. CA Power BI workspace
    4. DA DAX measure definition
    Show the answer

    The URL identifies the tenant and workspace; the client selects the semantic model only after establishing that workspace connection.

    Next → 3 / 10

  4. Question 4 of 10

    Which SemPy function identifies foreign-key rows without matching primary-key values?

    1. Alist_relationships()
    2. Bread_table()
    3. Clist_relationship_violations()
    4. Devaluate_measure()
    Show the answer

    Relationship-violation analysis compares table DataFrames using model relationship metadata; listing relationships only returns the definitions.

    Next → 4 / 10

  5. Question 5 of 10

    Which XMLA-connected tool compares the schemas of development and production semantic models?

    1. AALM Toolkit
    2. BTabular Editor BPA
    3. CDAX Studio
    4. DSemPy read_table()
    Show the answer

    ALM Toolkit is the schema-comparison choice; DAX Studio tests queries, while Tabular Editor focuses on structure and best-practice rules.

    Next → 5 / 10

  6. Keep the ones you got wrong

    In the app, every question you miss comes back exactly when you’re about to forget it.

    Get the app

  7. Question 6 of 10

    Which tool is designed for interactive DAX query testing against a published semantic model?

    1. ASemPy list_columns()
    2. BDAX Studio
    3. CTabular Editor BPA
    4. DALM Toolkit
    Show the answer

    DAX Studio supplies interactive query feedback; schema comparison, structural-rule analysis, and column inventory address different management tasks.

    Next → 6 / 10

  8. Question 7 of 10

    How does SemPy specify a semantic model after connecting through XMLA?

    1. AIt appends the table name to the workspace URL
    2. BIt passes the model name as a parameter
    3. CIt embeds the measure name in the tenant segment
    4. DIt selects the model as an initial catalog
    Show the answer

    SemPy uses an explicit model-name parameter; desktop clients such as DAX Studio or Tabular Editor select a database or initial catalog instead.

    Next → 7 / 10

  9. Question 8 of 10

    A team can query a production model through XMLA, but Tabular Editor cannot deploy an approved model change. What should the capacity administrator change?

    1. AKeep read-only XMLA access and select the model again
    2. BReplace the workspace connection with a table URL
    3. CEnable read-write XMLA access for the workspace
    4. DRun list_relationship_violations() before reconnecting
    Show the answer

    Successful queries confirm read-only connectivity, while deployment is a modification operation that requires administrator-enabled read-write access.

    Next → 8 / 10

  10. Question 9 of 10

    A team must run the same relationship and measure checks before every semantic model deployment. Which approach best fits?

    1. AUse Tabular Editor BPA to evaluate grouped measure values
    2. BUse DAX Studio for a one-time interactive schema comparison
    3. CUse a SemPy notebook as a repeatable validation suite
    4. DUse ALM Toolkit to read table data into DataFrames
    Show the answer

    SemPy combines scripted relationship checks and measure evaluation in notebooks, making the same validation sequence repeatable before deployment.

    Next → 9 / 10

  11. Question 10 of 10

    DAX Studio has connected to the correct XMLA workspace URL, but no semantic model has been chosen. What is the next step?

    1. AAdd the semantic model name to the tenant-name segment
    2. BSwitch the endpoint from encrypted to unencrypted traffic
    3. CSelect the semantic model as the database or initial catalog
    4. DCall read_table() without providing a model name
    Show the answer

    The URL establishes workspace scope; desktop tools then select the model as the database or initial catalog before querying it.

    Next → 10 / 10

  12. You’ve finished this set

    That’s 10 questions on XMLA Semantic Model Management. In the app the ones you miss come back exactly when you’re about to forget them.

    Back to the course Get the app
Keep your progress · Get the app

The whole course, on your phone

Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.

Get the app