Which Azure service and feature should you recommend using to manage the transient data for Data Lake Storage?

HOTSPOT Which Azure service and feature should you recommend using to manage the transient data for Data Lake Storage? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario: Stage inventory data in Azure Data Lake Storage Gen2...

June 1, 2021 No Comments READ MORE +

What should you recommend?

You need to recommend a solution for storing the image tagging data. What should you recommend?A . Azure File StorageB . Azure Cosmos DBC . Azure Blob StorageD . Azure SQL DatabaseE . Azure SQL Data WarehouseView AnswerAnswer: C Explanation: Image data must be stored in a single data store...

June 1, 2021 No Comments READ MORE +

What should you recommend using to secure sensitive customer contact information?

What should you recommend using to secure sensitive customer contact information?A . data labelsB . column-level securityC . row-level securityD . Transparent Data Encryption (TDE)View AnswerAnswer: B Explanation: Scenario: All cloud data must be encrypted at rest and in transit. Always Encrypted is a feature designed to protect sensitive data...

June 1, 2021 No Comments READ MORE +

What should you recommend?

You need to design the solution for analyzing customer data. What should you recommend?A . Azure DatabricksB . Azure Data Lake StorageC . Azure SQL Data WarehouseD . Azure Cognitive ServicesE . Azure BatchView AnswerAnswer: A Explanation: Customer data must be analyzed using managed Spark clusters. You create spark clusters...

May 31, 2021 No Comments READ MORE +

What should you recommend?

You need to recommend a backup strategy for CONT_SQL1 and CONT_SQL2. What should you recommend?A . Use AzCopy and store the data in Azure.B . Configure Azure SQL Database long-term retention for all databases.C . Configure Accelerated Database Recovery.D . Use DWLoader.View AnswerAnswer: B Explanation: Scenario: The database backups have...

May 31, 2021 No Comments READ MORE +

What should you recommend?

A company stores sensitive information about customers and employees in Azure SQL Database. You need to ensure that the sensitive data remains encrypted in transit and at rest. What should you recommend?A . Transparent Data EncryptionB . Always Encrypted with secure enclavesC . Azure Disk EncryptionD . SQL Server AlwaysOnView...

May 31, 2021 No Comments READ MORE +

Which three actions should you recommend?

You need to design the disaster recovery solution for customer sales data analytics. Which three actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Provision multiple Azure Databricks workspaces in separate Azure regions.B . Migrate users, notebooks, and...

May 31, 2021 No Comments READ MORE +

What should you recommend?

You need to recommend an Azure SQL Database service tier. What should you recommend?A . Business CriticalB . General PurposeC . PremiumD . StandardE . BasicView AnswerAnswer: C Explanation: The data engineers must set the SQL Data Warehouse compute resources to consume 300 DWUs. Note: There are three architectural models...

May 30, 2021 No Comments READ MORE +

Which types of tables should you include in the design?

HOTSPOT You need to design the storage for the Health Insights data platform. Which types of tables should you include in the design? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Hash-distributed tables The new...

May 30, 2021 No Comments READ MORE +

Which two options provide Litware with the ability to quickly calculate the current inventory levels by store and product?

Inventory levels must be calculated by subtracting the current day's sales from the previous day's final inventory. Which two options provide Litware with the ability to quickly calculate the current inventory levels by store and product? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one...

May 30, 2021 No Comments READ MORE +