DP-200

You need to configure a disaster recovery solution for SALESDB to meet the technical requirements. What should you configure in the backup policy?A . weekly long-term retention backups that are retained for three weeksB . failover groupsC . a point-in-time restoreD . geo-replicationView AnswerAnswer: C Explanation: Scenario: SALESDB must be...

Load the data using the INSERT…SELECT statement Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: There is no need to convert the parquet files to CSV files. 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-lake-store

DRAG DROP You need to set up access to Azure SQL Database for Tier 7 and Tier 8 partners. Which three actions should you perform in sequence? To answer, move the appropriate three actions from the list of actions to the answer area and arrange them in the correct order....

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region. To complete this task, sign...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: A Explanation: We use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column...

You need to process and query ingested Tier 9 data. Which two options should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Azure Notification HubB . Transact-SQL statementsC . Azure Cache for RedisD . Apache Kafka statementsE . Azure...

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to ensure that an email notification is sent to [email protected] if a suspicious login to an Azure SQL database named db2...

You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries. You need to monitor resource utilization to determine the source of the performance issues. Which metric should you monitor?A ....

Topic 3, Litware, inc Overview General Overview Litware, Inc. is an international car racing and manufacturing company that has 1,000 employees. Most employees are located in Europe. The company supports racing teams that complete in a worldwide racing series. Physical Locations Litware has two main locations: a main office in...

HOTSPOT You have an Azure SQL database that contains a table named Customer. Customer contains the columns shown in the following table. You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements: ✑ The first six numerals of the customer phone...