PrepAway - Latest Free Exam Questions & Answers

What should you create first to access the SQL database?

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

Explanation:
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/


Leave a Reply