Database & Analytics Services Flashcards
Which service would you use to build AI solutions, support data science frameworks and ApacheSpark
Azure Databricks
Which service would you use for machine learning, IoT, ETL, data warehousing and open source analytics services
Azure HD Insight
Which service would you use for enterprise data warehousing, big data analytics and can query data using serverless or provisioned resources at scale
Azure Synapse Analytics
Which service would you use for on demand analytics jobs and where you can write queries to transform data and extract insights
Data Lake Analytics
Which service offers PaaS relational database allowing you to build data driven apps and websites in a language of your choice
Azure SQL Database
Which service provides an open source relational database in the cloud
MySQL
Which service provides a PaaS database engine
SQL Managed Instance
Which service can you use to migrate on prem to cloud
Azure DB Migration Service
Which service offers globally distributed multi-model database service and supports schema-less data
Azure Cosmos DB
Which service is a no SQL managed database
Cosmos DB
Which service supports multi-region writing
Cosmos DB
You plan to store 20TB data in Azure. The data will be accessed infrequently and visualised using Power BI. Which two solutions should you recommend.
Azure Data Lake
Azure Synapse Analytics (Azure SQL data warehouse)
Which service is managed Hadoop service that allows you to process batches by using R, Python, SQL, Scala and Java
HD Insight
Which service is an Apache Spark based analytics platform designed to provide a collaborative analytics workflow
Azure Databricks