DP-200

A company plans to use Azure SQL Database to support a mission-critical application. The application must be highly available without performance degradation during maintenance windows. You need to implement the solution. Which three technologies should you implement? Each correct answer presents part of the solution. NOTE: Each correct selection is...

A company uses Azure SQL Database to store sales transaction data. Field sales employees need an offline copy of the database that includes last year’s sales on their laptops when there is no internet connection available. You need to create the offline export copy. Which three options can you use?...

A company manages several on-premises Microsoft SQL Server databases. You need to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. Which data technology should you use?A . Azure SQL Database single databaseB . Azure SQL Data WarehouseC . Azure Cosmos DBD . Azure...

Load the data using the INSERT…SELECT statement Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: You load the data using the CREATE TABLE AS SELECT statement. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lakestore

Load the data using the INSERT…SELECT statement Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: You need to create an external file format and external table using the external data source. You then load the data using the CREATE TABLE AS SELECT statement. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lakestore

A company uses Azure SQL Database to store sales transaction data. Field sales employees need an offline copy of the database that includes last year’s sales on their laptops when there is no internet connection available. You need to create the offline export copy. Which three options can you use?...

On which data store you configure TDE to meet the technical requirements?A . Cosmos DBB . SQL Data WarehouseC . SQL DatabaseView AnswerAnswer: B Explanation: Scenario: Transparent data encryption (TDE) must be enabled on all data stores, whenever possible. The datacentre for Mechanical Workflow must be moved to Azure SQL...

DRAG DROP You are developing a solution to visualize multiple terabytes of geospatial data. The solution has the following requirements: - Data must be encrypted. - Data must be accessible by multiple resources on Microsoft Azure. You need to provision storage for the solution. Which four actions should you perform...

Each day, company plans to store hundreds of files in Azure Blob Storage and Azure Data Lake Storage. The company uses the parquet format. You must develop a pipeline that meets the following requirements: Process data every six hours Offer interactive data analysis capabilities Offer the ability to process data...

A company uses Azure SQL Database to store sales transaction data. Field sales employees need an offline copy of the database that includes last year’s sales on their laptops when there is no internet connection available. You need to create the offline export copy. Which three options can you use?...