DP-201 Free Sample Questions

Your company wants to setup an Azure SQL data warehouse. Data would be loaded weekly from an Azure SQL database instance. You have to advise on recommendations based on the following security requirements for the data warehouse: - You have to ensure data engineers can only connect from their on-premise workstations - You have to ensure the right authentication and authorization measures are put in place - You have to ensure the data is encrypted at rest Which of the following would you recommend for the requirement? “You have to ensure the data is encrypted at rest”

A company has an Azure Data Lake Storage Gen 2 account that is used to store data used by data engineers. The data engineers would query the data by using notebooks from Azure Databricks. The folders in the Data Lake storage account would be secured by ensuring that users only have access for the folders they require. Which of the following would you use as the authentication method for Azure Databricks?

A company has an Azure Data Lake Storage Gen 2 account that is used to store data used by data engineers. The data engineers would query the data by using notebooks from Azure databricks. The folders in the Data Lake storage account would be secured by ensuring that users only have access for the folders they require. Which of the following would you use as the authentication method for Data Lake storage?

A company is planning on setting up an Azure SQL database. The database will be used to store sensitive data. Below are the requirements for the data store: - Only the application accessing the data can perform the encryption - The client application must have the access keys for encrypting and decrypting the data - The data must not appear in plaintext in the database - The strongest encryption method must be used on the database - The application should be able to search on select data values Which of the following would you use as the encryption method for Searchable data?

A company is planning on setting up an Azure SQL database. The database will be used to store sensitive data. Below are the requirements for the data store: - Only the application accessing the data can perform the encryption - The client application must have the access keys for encrypting and decrypting the data - The data must not appear in plaintext in the database - The strongest encryption method must be used on the database - The application should be able to search on select data values Which of the following would you use as the encryption method for Non-Searchable data?

A company is planning on building a solution that would contain the below layers: You have to decide on which services will be used for each layer. Which of the following would you choose as the service to use Service A?