Exam DP-200 topic 1 question 1 discussion

Could the write answer be D becase Spark has; 1) Interactive queries through spark-sql 2) Datawarehousing capabilities through Delta Lake (and also spark-sql creates in memory tables) 3) Less management because these are out-of-the-box features?

I think the answer should be A. Interactive Query. Here I am implementing Lambda architecture using a open source technology which can be Apache Spark and already in use. The prevailing issue here Analytical Processing is very slow , in another words queries are slow. So I created an HDInsight Cluster of type "Interactive Query" to support Analytical processing/ fast query access, data warehousing etc. We can use HiveQL on Interactive Query. Refer to https://docs.microsoft.com/en-us/azure/hdinsight/interactive-query/apache-interactive-query-get-started

A - Interactive Query - "Deliver SQL query responses in less than one second" https://docs.microsoft.com/en-us/azure/hdinsight/interactive-query/apache-interactive-query-get-started

D is correct based on Data warehousing requirement.

correct

https://docs.microsoft.com/en-us/azure/cosmos-db/lambda-architectur

Correct Answer in Spark because it is in memory

hi to all, answer: https://azure.microsoft.com/pt-pt/blog/general-availability-of-hdinsight-interactive-query-blazing-fast-data-warehouse-style-queries-on-hyper-scale-data-2/ sub-second ! Summary This week at Ignite, we are pleased to announce general availability of Azure HDInsight Interactive Query. Backed by our enterprise-grade SLA, HDInsight Interactive Query brings sub-second speed to data warehouse style SQL queries to the hyper-scale data stored in commodity cloud storage. regards

Exam was updated on Nov 24, 2020. Didn't see too many questions from the test on ExamTopics...maybe 20-30% of the test questions. Suggest waiting a bit to take the test so that all the exam prep questions are updated. Exam definitely requires hands-on knowledge of the products. A lot of questions on CosmosDB consistency settings, encryption/security, monitoring/metrics.

I also vote for Interactive Query as "An Interactive Query cluster is different from an Apache Hadoop cluster. It contains only the Hive service. Requirements: ✑ Provide data warehousing ( Yes) ✑ Reduce ongoing management activities (Not sure) ✑ Deliver SQL query responses in less than one second ( Yes)

D: Apache spark

https://azure.microsoft.com/en-in/blog/lambda-architecture-using-azure-cosmosdb-faster-performance-low-tco-low-devops/

Apache Spark is correct Answer !! https://docs.microsoft.com/en-us/azure/hdinsight/spark/apache-spark-overview

i think the logic to answer this question is: Lambda architecture: https://databricks.com/glossary/lambda-architecture Azure implementation: https://azure.microsoft.com/en-us/services/databricks/ Azure Databricks = Fast, easy, and collaborative Apache SparkTM based analytics service

How does Spark meet the requirements? Spark does not provide data warehousing by itself, it is not a data store.

https://docs.microsoft.com/en-us/azure/cosmos-db/lambda-architecture

Would suggest to use the original link from MS: https://docs.microsoft.com/en-us/azure/cosmos-db/lambda-architecture as better background documentation