Databricks MCQ Questions - Microsoft Azure
This section focuses on "Databricks" of Microsoft Azure. These Multiple Choice Questions (MCQ) should be practiced to improve the Microsoft Azure skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exams and other competitive examinations.
1. Which one of the following is not a operations that can be performed using Azure Databricks?
A. It is Apache Spark based analytics platform
B. It helps to extract, transform and load the data
C. Visualization if data is not possible with it
D. All of the above
View Answer
Ans : C
Explanation: Azure Databricks also helps in visualization of data.
2. To which one of the following sources do Azure Databricks connect for collecting streaming data?
A. Kafka
B. Azure data lake
C. CosmosDB
D. None of the above
View Answer
Ans : A
Explanation: Azure Databricks can be connected with sources like Kafka, Event Hubs for the purpose of collecting streaming data.
3. Which one of the following is a Databrick concept?
A. Workspace
B. Authentication and authorization
C. Data Management
D. All of the above
View Answer
Ans : D
Explanation: There are mainly 5 categories of Databricks concepts viz Workspace, Data Management, Computational Management, Model Management and Authentication and authorization.
4. Which of the following ensures data reliability even after termination of cluster in Azure Databricks?
A. Databricks Runtime
B. Databricks File System
C. Dashboards
D. Workspace
View Answer
Ans : B
Explanation: DataBricks File System is a distributed file system available on DataBricks clusters.
5. Choose the correct option with respect to ETL operations of data in Azure Databricks?
A. For loading of data, data is moved from databricks to data warehouse
B. for loading of data, blob storage is used
C. Blob storage serves as a temporary storage
D. All of the above
View Answer
Ans : D
Explanation: All the above statements are true. Loading is basically to load the data to SQL Datawarehouse.
6. Which one of the following is incorrect regarding Workspace of Azure Databricks concept?
A. It manages ETL operations of data
B. It can store notebooks, libraries and dashboards
C. It is the root folder of Azure Databricks
D. None of the above
View Answer
Ans : A
Explanation: ETL i.e Extract, Transform and Load operations come under computational management.
7. Which of the following Azure datasources can be connected to Azure Databricks?
A. Azure Blob Storage
B. Azure Datawarehouse
C. Azure CosmosDB
D. All of the above
View Answer
Ans : D
Explanation: Azure Databricks can connect to different datasources which includes all the above three data sources.
8. Streaming data can be captured by?
A. Kafka
B. Event Hubs
C. Both A and B
D. None of the above
View Answer
Ans : C
Explanation: Both Kafka and Event Hubs are capable of capturing streaming data.
9. Authentication and authorization in databricks can be managed for :
A. User, Group, Access Control List
B. User, Group
C. Access Control List
D. Group, Access Control List
View Answer
Ans : A
Explanation: Azure DataBricks has a benefit that authentication and authorization can be managed for user, group as well as Access Control List.
10. Which one of the following is a set of components that run on clusters of Azure Databricks?
A. DataBricks File System
B. Databricks Runtime
C. CosmosDB
D. Azure Data Lake
View Answer
Ans : B
Explanation: Databricks Runtime is built on Apache Spark which is a set of components that be used to run in databricks.
Discussion