Exam MB-400 topic 2 question 14 discussion

Actual exam question from Microsoft's MB-400

Question #: 14
Topic #: 2

A company uses the Data Export Service (DES) to refresh their Azure SQL Data Warehouse instance. The data warehouse is used for historical trend analysis and forecasting.
The refresh process from the Common Data Service (CDS) environment to the data warehouse has errors. Users report that data is missing.
A CDS test environment that contains DES is available to troubleshoot the import outside of the production environment. You create a new SQL database for testing.
You need to configure the test environment to point to the new SQL database.
What should you create first to access the SQL database?

A. a new secret in Azure Key Vault
B. a new export profile in CDS test
C. a new user in the SQL database
D. a new application registration

Show Suggested Answer

Suggested Answer: A 🗳️
Because this service requires access to an external Microsoft Azure SQL Database from Dynamics 365 (online), a number of prerequisites must be satisfied before you can successfully access this service including:
✑ Global / Tenant Admin access, or an Azure Key Vault must be provisioned and the setup user must have permissions on Secrets.
Reference:
https://blog.crgroup.com/dynamics-365-latest-feature-the-data-export-service/

by RobinS at June 18, 2020, 3:22 p.m.

Comments

Submit Cancel

jkaur

4 years, 5 months ago

A is correct

upvoted 1 times

...

sanharshu7

4 years, 10 months ago

I think A is correct

upvoted 3 times

...

RobinS

4 years, 10 months ago

Here is the Microsoft reference: https://docs.microsoft.com/en-us/power-platform/admin/replicate-data-microsoft-azure-sql-database

upvoted 4 times

...

Exam MB-400 All Questions

View all questions & answers for the MB-400 exam

Exam MB-400 topic 2 question 14 discussion

Comments

jkaur

sanharshu7

RobinS

SY0-701