DP-900 Exam Questions And Answers Rated A+ New Update Assured Satisfaction

______ is a traditional approach and has established best practices. It is more commonly found in onpremises environments since it was around before cloud platforms. It is a process that involves a lot o data movement, which is something you want to avoid on the cloud if possible due to its resourceintensive nature. - ETL ________ seems similar to ETL at first glance but is better suited to big data scenarios since it leverages the scalability and flexibility of MPP engines like Azure Synapse Analytics, Azure Databricks, or Azure HDInsight. - ELT ____________ is the new name for Azure SQL Data Warehouse, but it extends it in many ways. It aims to be the comprehensive analytics platform, from data ingestion to presentation, bringing together oneclick data exploration, robust pipelines, enterprise-grade database service, and report authoring. - Azure Synapse Analytics _____________ is a cloud service from the creators of Apache Spark, combined with a great integration with the Azure platform. - Azure Databricks _____________ is a feature of SQL Server and Azure SQL Database that enables you to run Transact-SQL queries that read data from external data sources. ______ makes these external data sources appear like tables in a SQL database. A. SSMS B. Data Tools C. Polybase D. Analysis Service - Polybase PolyBase is a feature of SQL Server and Azure SQL Database that enables you to run Transact-SQL queries that read data from external data sources. PolyBase makes these external data sources appear like tables in a SQL database. Using PolyBase, you can read data managed by Hadoop, Spark, and Azure Blob Storage, as well as other database management systems such as Cosmos DB, Oracle, Teradata, and MongoDB._____________ is a term used by database professionals for a schema design process that minimizes data duplication and enforces data integrity. - Normalization _______________ is a cloud service that lets you implement, manage, and monitor a cluster for Hadoop, Spark, HBase, Kafka, Store, Hive LLAP, and ML Service in an easy and effective way. - Azure HDInsight _________________ API of Cosmos DB is used to work with data that has many different entities that share a relationship. - Table - MongoDB - Gremlin - CassandraDB - Gremlin