Data Lake MCQ Questions - Microsoft Azure
This section focuses on "Data Lake" 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. Choose the correct option with respect to Azure Data Lake?
A. It can only provide high storage capacity but cannot perform analytics opertaion upon that data
B. It can perform analytics operation on the datas that are stored in blob storage, but cannot store data
C. It can store as well as perform analytics on data
D. It can neither store nor perform analytics on data
View Answer
Ans : C
Explanation: Azure Data Lake provides high storage capacity as well as analytics operation can also be performed on the datas.
2. What is the storage capacity of Azure Data Lake?
A. 1024TB
B. 1024EB
C. 512EB
D. Unlimited
View Answer
Ans : D
Explanation: Azure Data Lake has unlimited storage capacity.
3. What format of data can be stored in Azure Data Lake?
A. structured, unstructured and semi structured
B. only structured
C. structured and semi structured
D. only unstructured
View Answer
Ans : A
Explanation: Azure Data Lake has an advantage over traditional analytics method that it helps to store structured,semi structured as well as unstructured data.
4. When data is saved in Azure Data Lake, how many copies of data are saved by default?
A. 1
B. 2
C. 3
D. 4
View Answer
Ans : C
Explanation: It is the property of Azure Data Lake that whenever a data is stored, it has 3 copies of it.
5. Which of the following tools can be used for data ingestion in Azure Data Lake?
A. Sqoop
B. Azure Data Factory
C. Developer SDK
D. All of the above
View Answer
Ans : D
Explanation: In Azure data Lake, data ingestion can be in various form and it can be done with various tools such as Sqoop, Developer SDK, Azure Data Factory, Azure Portal etc.
6. Choose the correct option regarding Azure Data Lake Analytics?
A. It can be used with Azure Blob Storage as well as Azure SQL Database
B. It can be used with Azure Blob Storage but not with Azure SQL Database
C. It can be used with Azure SQL Database but not with Azure Blob Storage
D. It can neither used with Azure Blob Storage nor with Azure SQL Database
View Answer
Ans : A
Explanation: Azure Data Lake Analytics has an advantage that it can also be used with Azure Blob Storage as well as Azure SQL Database.
7. What does U in U-SQL stand for?
A. unique
B. unified
C. unlimited
D. under
View Answer
Ans : B
Explanation: U in U-SQL stands for Unified and it is a query language that is a combination of decalarative SQL and C# programming.
8. Which of the following is not among the major steps of U-SQL for processing data?
A. Extract
B. Eliminate
C. Transform
D. Output
View Answer
Ans : B
Explanation: There are 3 major steps for data processing in U-SQL which are Extract, Transform and Output.
9. Choose the correct option.
A. Azure Data Lake can manage access control of data
B. This access control in Azure Data Lake can be given to the user with the help of ACL
C. Both A and B
D. None of the above
View Answer
Ans : C
Explanation: Both the statements hold true for access control in Azure Data Lake.
10. What does ACL stand for?
A. Azure Control List
B. Access Control List
C. Azure Control Lake
D. Access Control Lake
View Answer
Ans : B
Explanation: ACL stands for Access Control List which helps ADL to manage read,write and execute permissions to users or security groups.
Discussion