Microsoft Certified Azure Data Engineer Associate Exam Questions & Answers

All 54 questions

1. Q1 Which workload management feature influences the order in which a request gets access to resources?
2. Q2 Scenario: Pym Tech is a U.S. based Technology manufacturer headed by Hank Pym. Their headquarters is located at Treasure Island, San Francisco…
3. Q3 Scenario: Honest Eddie's Car Dealership is an establishment in South Carolina USA, which is dedicated to the purchase and sale of cars…
4. Q4 Azure provides many ways to store your data. An Azure storage account contains all of your Azure Storage data objects, including blobs,…
5. Q5 Because the Databricks API is declarative, a large number of optimizations are available to us. Among the most powerful components of Spark…
6. Q6 Within creating a notebook, you need to specify the pool that needs to be attached to the notebook that is, a SQL…
7. Q7 You can natively perform data transformations with Azure Synapse pipelines code free using the Mapping Data Flow task. Mapping Data Flows provide…
8. Q8 Azure Databricks is an amalgamation of multiple technologies that enable you to work with data at scale.Which of the following is best…
9. Q9 Which of the following is a good analogy for the access keys of a storage account?
10. Q10 Which method for renaming a DataFrame column is incorrect?
11. Q11 Scenario: You need to provision a data store that will store but not query data.Which is the least expensive option which will…
12. Q12 True or False: When using Azure Synapse Analytics, the preferred method for loading data is to use the service administrator account as…
13. Q13 Scenario: You are working as a consultant at Advanced Idea Mechanics (A.I.M.) who is a privately funded think tank organized of a…
14. Q14 Which ALTER DATABASE statement parameter allows a dedicated SQL pool to scale?
15. Q15 Azure Storage accounts are the base storage type within Azure. Azure Storage offers a very scalable object store for data objects and…
16. Q16 Scenario: Honest Eddie's Car Dealership is an establishment in South Carolina USA, which is dedicated to the purchase and sale of cars…
17. Q17 Scenario: You are working in an Azure Databricks workspace and you want to filter based on the end of a column value…
18. Q18 How do you infer the data types and column names when you read a JSON file?
19. Q19 Identify the missing word(s) in the following sentence within the context of Microsoft Azure.[ ? ] is a fully-managed, cloud-based Big Data…
20. Q20 True or False: Azure Blob Storage is the least expensive method to store data and one of it best features is that…
21. Q21 Scenario: You are a consultant at Avengers Security which has an SaaS solution which uses Azure SQL Database with elastic pools. The…
22. Q22 How do you cache data into the memory of the local executor for instant access?
23. Q23 What does Azure Data Lake Storage (ADLS) Passthrough enable?
24. Q24 Identify the missing word(s) in the following sentence within the context of Microsoft Azure.[ ? ] makes it possible to replicate data…
25. Q25 Which Azure Synapse Analytics component enables you to perform Hybrid Transactional and Analytical Processing?
26. Q26 Identify the missing word(s) in the following sentence within the context of Microsoft Azure.Apache Spark Structured Streaming is a fast, scalable, and…
27. Q27 Microsoft Azure Storage is a managed service that provides durable, secure, and scalable storage in the cloud. You can create an Azure…
28. Q28 Knowing now the different concepts of spark it is imperative to understand how it fits in with the different Data services on…
29. Q29 Azure Cosmos DB analytical store is a fully isolated column store for enabling large-scale analytics against operational data in your Azure Cosmos…
30. Q30 Scenario: You have started at a new job within a company which has a Data Lake Storage Gen2 account. You have been…
31. Q31 True or False: In simple terms, you could view DataFrames as you might see in excel, which we could also refer to…
32. Q32 Azure Databricks includes an integrated notebook interface for working with Spark. Notebooks provide an intuitive way to combine code with Markdown notes,…
33. Q33 Identify the missing word(s) in the following sentence within the context of Microsoft Azure.Azure Monitor provides base-level infrastructure metrics and logs for…
34. Q34 Identify the missing word(s) in the following sentence within the context of Microsoft Azure.[ ? ] is a Hadoop-compatible data repository that…
35. Q35 Which technology is typically used as a staging area in a modern data warehousing architecture?
36. Q36 SQL Server Integration Services (SSIS) is a platform for building complex Extract Transform and Load (ETL) solutions. SSIS is a component within…
37. Q37 Within Azure Synapse Link for Azure Cosmos DB, which Column-oriented store is optimized for queries?
38. Q38 Before we can query our data using Azure Synapse Analytics using Azure Synapse Link, we must first create the container that is…
39. Q39 True or False: The self-hosted integration runtime is logically registered to the Azure Data Factory and the compute resource used to support…
40. Q40 Scenario: Mercs for Money is a collection of mercenaries gathered together by Wade Wilson who organized the group and is now a…
41. Q41 What size does OPTIMIZE compact small files to?
42. Q42 Identify the missing word(s) in the following sentence within the context of Microsoft Azure.From a high level, the Azure Databricks service launches…
43. Q43 Scenario: You are working on a new project and creating storage accounts and blob containers for your application.Which of the below describes…
44. Q44 What is Apache Spark notebook?
45. Q45 Spark pools in Azure Synapse Analytics is one of Microsoft's implementation of Apache Spark.Which of the following are not true about Spark…
46. Q46 How many drivers does a Cluster have?
47. Q47 With the wide range of data stores available in Azure, there's the need to manage and orchestrate the movement data between them.…
48. Q48 Scenario: James Rhodes has taken on a role at Wakanda Secret Service (WSS).  T'Challa is the sponsor on a WSS project where…
49. Q49 Whilst Azure Synapse Analytics is used for the storage of data for analytical purposes, SQL Pools do support the use of transactions…
50. Q50 Scenario: You are working as a consultant at Avengers Security. At the moment, you are consulting with Tony, the lead of the…
51. Q51 Scenario: You have been contracted by Wayne Enterprises, a company owned by Bruce Wayne with  market value of over twenty seven million…
52. Q52 Scenario: You are working at a bank setting up a database which will be used by all employee-levels of the bank. At…
53. Q53 With the Azure-SSIS integration runtime installed and SQL Server Data Tools (SSDT) you have the capability to deploy and manage SSIS packages…
54. Q54 During the process of creating a notebook, you need to specify the pool that needs to be attached to the notebook that…