Microsoft Certified Azure Data Fundamentals Exam Questions & Answers

All 41 questions

1. Q1 Which of the following Azure SQL options allows you to run your own full version of SQL Server with full control over…
2. Q2 True or False: Non-relational databases are also commonly known as NoSQL databases.
3. Q3 You have a SQL Database Server named SQLDB, and two SQL Databases named DB1 and DB2. SQLDB has a server-level firewall that…
4. Q4 Which of the following are true about stream processing? (Select all that apply)
5. Q5 You have a small 25MB database currently hosted in AWS DynamoDB that you'd like to move to Azure Cosmos DB. You've chosen…
6. Q6 Why would someone choose Azure Cosmos DB Table API instead of Azure Table Storage?
7. Q7 True or False: Transactional systems often handle high volumes of transactions and require quick data accessibility.
8. Q8 You are required to store event log data that is semi-structured and arrives in real time as events happen.Which type of storage…
9. Q9 Which edition of MySQL is available free of charge and is popular for web applications running under Linux?
10. Q10 When trying to merge rows from two tables based on a related column, which of the following SQL keywords can we use?
11. Q11 What happens if you do not provision enough Request Units per second (RU/s) than your application requires?
12. Q12 Which Azure Storage service is specifically designed to store large quantities of raw and unprocessed data, at very fast speeds? That is,…
13. Q13 Which of the following is a type of structured data that allows for efficient storage and retrieval of data through the use…
14. Q14 What method of provisioning a non-relational database involves first defining the database in a JSON file, which can then be checked into…
15. Q15 Which of the following Azure databases is considered Infrastructure as a Service (Iaas)?
16. Q16 In a general stream processing architecture, what is the role of a queue in the data processing flow?
17. Q17 What is the primary reason for offering Azure data services for MySQL, MariaDB, and PostgreSQL?
18. Q18 What is the maximum amount of data that can be stored in a Azure Table Storage database?
19. Q19 True or False: A view can contain data from multiple underlying tables.
20. Q20 What are the two elements that make up the key in an Azure Table Storage table?
21. Q21 You need to create an Azure resource to store data in Azure Table storage.Which command should you run?
22. Q22 Which of the following is NOT a feature of relational databases in Microsoft Azure?
23. Q23 What do you get when you use Archive access tier for Azure Blob Storage?
24. Q24 Which of the following best describes the query language used in Azure Stream Analytics jobs?
25. Q25 Which optimized file format stores data in a row-based format and utilizes JSON for storing headers?
26. Q26 What type of non-relational data revolves around data that is formatted in a readable format (JSON, XML, YAML, etc)? It is sometimes…
27. Q27 What is one of the crucial requirements for gaming applications when it comes to databases?
28. Q28 In ELT, what happens to the data store's performance as the target data store scales?
29. Q29 Which of the following is NOT a feature of Azure Table Storage tables?
30. Q30 You need a storage solution in Azure that supports binary data. Your application will receive multiple GBs per day of images and…
31. Q31 In a relational database, what does a row represent?
32. Q32 What technologies are commonly used for processing and querying data stored in data lakes?
33. Q33 What does Cosmos DB use to ensure fast read and write performance?
34. Q34 For each of the following statements, choosing yes if the statement is true, otherwise, choosing no. Statements: Azure Synapse Analytics scales storage…
35. Q35 What feature of Azure Blob Storage, if enabled, allows you to retrieve files that have previously been deleted within a time period?
36. Q36 To complete the statement, choosing the appropriate option in the answer. Statement: In batch processing.
37. Q37 Which of the following statements accurately describes the process of normalization in relational database design?
38. Q38 What data structure allows a database server to find data much faster than without it?
39. Q39 True or False: Azure SQL Managed Instance is considered a Platform-as-a-Service (PaaS) option.
40. Q40 Which data loading approach is more suitable for situations that require scaling, and is ideal for large volumes of data?
41. Q41 What are two uses of data visualization?