Microsoft Power Apps + Dynamics 365 Developer — Question 8

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?

Answer options

• 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

Correct answer: A

Explanation

Creating a new secret in Azure Key Vault is necessary to securely store and access the credentials required to connect to the new SQL database. The other options, such as creating a new export profile, user, or application registration, do not directly address the need for secure access to the database credentials required for the connection.