nerdexam
Microsoft

70-467 · Question #117

You are deploying the Research model. You need to ensure that the data contained in the model can be refreshed. What should you do?

The correct answer is B. Assign the Tabular instance service account permissions to the MarketResearch.xlsx network. For a tabular model to refresh data from a file-based source, the Analysis Services service account must have read permissions on that source file.

Design BI data models

Question

You are deploying the Research model. You need to ensure that the data contained in the model can be refreshed. What should you do?

Options

  • AImport MarketResearch.xlsx to a new tabular database on the Tabular instance.
  • BAssign the Tabular instance service account permissions to the MarketResearch.xlsx network
  • CCreate a SQL Server Integration Services (SSIS) package that imports data from
  • DUpload MarketResearch.xlsx to Library1.

How the community answered

(29 responses)
  • A
    14% (4)
  • B
    79% (23)
  • C
    3% (1)
  • D
    3% (1)

Why each option

For a tabular model to refresh data from a file-based source, the Analysis Services service account must have read permissions on that source file.

AImport MarketResearch.xlsx to a new tabular database on the Tabular instance.

Importing the workbook into a new tabular database creates an entirely separate model and does not enable refresh of the existing Research model.

BAssign the Tabular instance service account permissions to the MarketResearch.xlsx networkCorrect

When Analysis Services processes a tabular model, the Windows service account running the Tabular instance is the identity used to connect to data sources. Granting that service account read access to MarketResearch.xlsx on the network share allows the engine to open the file during scheduled or on-demand refresh without authentication errors.

CCreate a SQL Server Integration Services (SSIS) package that imports data from

Creating an SSIS package adds unnecessary complexity and an extra ETL layer; the tabular engine can read Excel files directly once the service account has the required file permissions.

DUpload MarketResearch.xlsx to Library1.

Uploading the file to a SharePoint library changes its location but does not grant the Tabular instance service account the permissions it needs to access the file during processing.

Concept tested: Analysis Services service account permissions for data refresh

Source: https://learn.microsoft.com/en-us/analysis-services/instances/configure-service-accounts-analysis-services

Topics

#tabular model#data refresh#Excel data source#service account permissions

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice