- Article
- 18 minutes to read
Last update: 03/26/2022
PLEASE FILL THISSURVEY RESEARCH(https://aka.ms/samplequestions)
Microsoft is investigating providing sample questions as an exam preparation resource, and we'd love to hear your feedback. Although we prefer that you complete thisSurvey ResearchAfter the exam, you can take it at any time. Thank you very much!
user's Guide
These sample questions are intended to provide an overview of the style, wording, and difficulty of the questions you are likely to encounter on this exam. these questions arenothe same as you will see on the exam, nor does this document clarify the length of the exam or its complexity (for example, you may see additional question types, various case studies, and possibly exercises). these questions areexamplesjust to give you an idea of what to expect on the test and to help you determine if any additional preparation is needed.
In the first section you will find unanswered questions so you can test your knowledge. In the second section, just below each question, the answer, a rationale, and a URL that takes you to additional information are provided.
Questions
Question #1 (full sentences)
Choose the answer that correctly completes the sentence.
The objects to which data-related items must be registered and stored are called: ____________.
The. tables
B. Entities
C son
D.Columnas
Question #2 (full sentences)
Choose the answer that correctly completes the sentence.
They must process data that is continuously generated and require near real-time responses.
You should use _________.
A. Batch Processing
B. planned data processing
C. Buffering and Processing
D. Transmission Data Processing
Question #3 (assignment)
Evaluates data processing approaches.
Match the data processing approaches on the left with the requirements on the right.
| data processing approaches | descriptions |
|---|---|
| A. Extract, Transform, Load (ETL) B. Extract, Load, Transform (ELT) | _____ 1. Optimize data protection. _____ 2. Provide support for Azure Data Lake. _____ 3. Manage large amounts of data. |
Question 4 (multiple choice)
Choose the answer that correctly completes the sentence.
The technique that provides recommended actions you should take to achieve a goal or objective is called _____________ analysis.
A. descriptive
B diagnosis
C predictive
D. Prescription
Question #5 (assignment)
Map data processing objects on the left to requirements on the right.
| data processing objects | descriptions |
|---|---|
| The. tables B. indices C. Views D key | _____ 1. Build relationships. _____ 2. Improve data lookup processing speed. _____ 3. Store entity instances as lines. _____ 4. View data from predefined queries. |
Question #6 (sentence completion)
Choose the answer that correctly completes the sentence.
The process of splitting an entity into more than one table to reduce data redundancy is known as _____________.
A. Deduplication
B. Denormalization
C. Normalization
D. Optimization
Question #7 (sentence completion)
Choose the answer that correctly completes the sentence.
Azure SQL Database is an example of ________________ as a service.
A. Platform
Infrastructure B
C.-Software
D. Application
Question #8 (assignment)
You must query an Azure SQL Database.
Match the query tools on the left with the right scenarios on the right.
| Abfrage-Tools | descriptions |
|---|---|
| A. Azure Data Studio B. Azure Query Editor C. SQL Server-Datentools | _____ 1. Query data while working on a Visual Studio project. _____ 2. Query data residing on a non-Microsoft platform. _____ 3. Query data from the Azure Portal. |
Question #9 (sentence completion)
Choose the answer that correctly completes the sentence.
Increasing or decreasing the resources available to a service is known as _____________.
A. Calculations
B. Implementation
C. Nest
D. Escalation
Question #10 (Mapping)
Queries are created to retrieve data from an Azure SQL Database.
Map the SQL clauses or functions on the left to the requirements on the right.
| SQL clauses | descriptions |
|---|---|
| A. BECOME A MEMBER B. OS C. SUMA D.GRAF | _____ 1. Filter records. _____ 2. Combine rows from multiple tables. _____ 3. Calculate the total value of a numeric column. _____ 4. Determine the number of rows retrieved. |
Question 11 (multiple choice)
What are the three characteristics of non-relational data? Each correct answer represents a complete solution.
A. Required schema for data structures
B. Flexible storage of recorded data
C. Entities describe themselves
D. Entities can have different fields
E. Each row has exactly the same columns
Question #12 (sentence completion)
Choose the answer that correctly completes the sentence.
You have data consisting of JSON-based documents.
You must store the data in an Azure environment that supports efficient lookups based on keyless fields.
You must use ____________________ as data storage.
A. Azure Table Storage
B. Azure Blob Storage
C. Azure File Storage
D. Azure Cosmos DB
Question 13 (multiple choice)
You need to create a graphics database.
Which Azure Data Service Should You Use?
A. Blue table
B. Azure Cosmos DB
C. Blue spot
D. Azure-Datei
Question #14 (sentence completion)
Choose the answer that correctly completes the sentence.
It uses Azure Table Storage as a non-relational data store.
You need to optimize data recovery. You must use ______________________________ as the query criteria.
A. Partition key only
B. line keys only
C. Partition key and row key
D. properties only
Question 15 (multiple choice)
You must use JavaScript Object Notation (JSON) files to provision Azure Storage.
What should you wear?
A. Portal do Azure
B. Azure Command Line Interface (CLI)
C. Azure PowerShell
D. Plantillas de Azure Resource Manager (ARM)
Question 16 (multiple choice)
Why should you use a data warehouse?
A. Record daily sales transactions.
B. Perform sales trend analysis.
C. Print sales orders.
D. Sales order search status.
Question 17 (multiple choice)
Which two Azure data services support Apache Spark clusters? Each correct answer represents a complete solution.
A. Azure Synapse Analysis
B. Azure Cosmos DB
C. Azure Databricks
D. Azure Data Factory
Question 18 (multiple choice)
You design a data ingestion and transformation solution using the Azure Data Factory service.
You must retrieve data from an Azure SQL Database.
Which two resources should you use? Each correct answer is part of the solution.
A. Linked Service
B. Data Copy Activity
C. Registration
D. Azure Databricks-Notebook
Question 19 (multiple choice)
Which Azure Data Factory component should you use to represent the data you want to collect for processing?
A. Related services
B. Records
c.pipe
D. Cadernos
Question 20 (multiple choice)
You create reports using Microsoft Power BI.
For which three scenarios can you create Power BI reports as paginated reports? Each correct answer represents a complete solution.
A. A report that has a table image with the option to print all table data
For example, a report that has a table image that can be used to display all of the table's data
C. A report with a repeatable header and footer
D. A report formatted to fit comfortably on a printed page
E. A report that uses only Power BI visuals
questions and answers
Question #1 (full sentences)
Choose the answer that correctly completes the sentence.
The objects to which data-related items must be registered and stored are called: ____________.
The. tables
B. Entities
C son
D.Columnas
| Article | Description |
|---|---|
| Responder: | B. Entities |
| Look: | 1.1 Describe the types of core data workloads |
| Reason: | An entity is a thing in which information needs to be known or stored. A table is the object that stores a collection of entities. A line represents a single instance of an entity. A column defines a specific property of an entity. |
| URL: | https://learn.microsoft.com/training/modules/describe-concepts-of-relational-data/2-explore-characteristics |
Question #2 (full sentences)
Choose the answer that correctly completes the sentence.
They must process data that is continuously generated and require near real-time responses.
You should use _________.
A. Batch Processing
B. planned data processing
C. Buffering and Processing
D. Transmission Data Processing
| Article | Description |
|---|---|
| Responder: | D. Transmission Data Processing |
| Look: | 1.1 Describe the types of core data workloads |
| Reason: | When data is continuously generated and insights are needed, you need to be able to see the data immediately, process it as it comes in, rather than storing and processing it later as a group. Batch processing, scheduled processing and buffering of all data collected and stored for further processing. |
| URL: | https://learn.microsoft.com/training/modules/explore-core-data-concepts/4-describe-difference |
Question #3 (assignment)
Evaluates data processing approaches.
Match the data processing approaches on the left with the requirements on the right.
| data processing approaches | descriptions |
|---|---|
| A. Extract, Transform, Load (ETL) B. Extract, Load, Transform (ELT) | _____ 1. Optimize data protection. _____ 2. Provide support for Azure Data Lake. _____ 3. Manage large amounts of data. |
| Article | Description |
|---|---|
| Responder: | Extract, Transform, Load (A) corresponds to Description 1: Optimize data protection. Extract, Load, Transform (B) corresponds to Description 2: Azure Data Lake support and Description 3: Manage large amounts of data. |
| Look: | 1.2 Describe the fundamentals of data analysis |
| Reason: | Extract, Transform, Load (ETL) is the right approach when you need to filter sensitive data before loading it into an analytical model. It's suitable for simple data models that don't require Azure Data Lake support. Extract, Load, Transform (ELT) is the right approach as it supports Azure Data Lake as a data store and manages large amounts of data. |
| URL: | https://learn.microsoft.com/training/modules/explore-concepts-of-data-analytics/2-describe-data-ingestion-process |
Question 4 (multiple choice)
Choose the answer that correctly completes the sentence.
The technique that provides recommended actions you should take to achieve a goal or objective is called _____________ analysis.
A. descriptive
B diagnosis
C predictive
D. Prescription
| Article | Description |
|---|---|
| Responder: | D. Prescription only |
| Look: | Test goal number and text |
| Reason: | Prescriptive analytics helps define the actions (recipe) you need to take to achieve what you need (or solve a problem). Descriptive analysis helps you understand what happened by looking at historical data. You can further analyze the information using diagnostic analysis. Predictive analytics helps predict future values based on historical values. |
| URL: | https://learn.microsoft.com/training/modules/explore-concepts-of-data-analytics/4-explore |
Question #5 (assignment)
Map data processing objects on the left to requirements on the right.
| data processing objects | descriptions |
|---|---|
| The. tables B. indices C. Views D key | _____ 1. Build relationships. _____ 2. Improve data lookup processing speed. _____ 3. Store entity instances as lines. _____ 4. View data from predefined queries. |
| Article | Description |
|---|---|
| Responder: | Top Matches (D) Description 1: Establish relationships. Index Match (B) Description 2: Improves processing speed for data lookups. Table Matches (A) Description 3: Stores instances of entities as rows. Views (C) correspond to Description 4: Show data from predefined queries. |
| Look: | 2.1 Describing relational data workloads |
| Reason: | Tables use rows to store data or entity instances. Indexes are a subset of data used to speed up data lookups. Views are virtual tables based on the results of a query. It uses primary keys and foreign keys to create Relationships between tables. |
| URL: | https://learn.microsoft.com/training/modules/describe-concepts-of-relational-data/2-explore-characteristics
|
Question #6 (sentence completion)
Choose the answer that correctly completes the sentence.
The process of splitting an entity into more than one table to reduce data redundancy is known as _____________.
A. Deduplication
B. Denormalization
C. Normalization
D. Optimization
| Article | Description |
|---|---|
| Responder: | C. Normalization |
| Look: | 2.2 Describe Azure relational data services |
| Reason: | Normalization is the process of breaking a logical entity into multiple tables and designing the relationship between the tables. Normalization is commonly used to improve query completion speed for transaction processing databases. Deduplication removes duplicate data from tables. Denormalization is the process of combining tables. This process is commonly used to store data in databases used for data mining and reporting. Optimization is the process of changing database fields and structure to improve overall performance. |
| URL: | https://learn.microsoft.com/training/modules/describe-concepts-of-relational-data/2-explore-characteristics |
Question #7 (sentence completion)
Choose the answer that correctly completes the sentence.
Azure SQL Database is an example of ________________ as a service.
A. Platform
Infrastructure B
C.-Software
D. Application
| Article | Description |
|---|---|
| Responder: | A. Platform |
| Look: | 2.2 Describe Azure relational data services |
| Reason: | Azure SQL Database is an example of a platform as a service. Infrastructure as a service includes technologies such as virtual machines and virtual networks. Software as a Service describes a software delivery method in which users obtain software licenses online through a subscription. Microsoft offers subscriptions to license Office products such as Microsoft Excel. Application as a service describes applications hosted in the cloud and offered to users on a subscription basis. This is like software as a service but is often referred to as industry custom solutions. There are no Azure data services that use the Software as a Service or Application as a Service model. |
| URL: | https://learn.microsoft.com/training/modules/explore-relational-data-offerings/2-azure-data-services |
Question #8 (assignment)
You must query an Azure SQL Database.
Match the query tools on the left with the right scenarios on the right.
| Abfrage-Tools | descriptions |
|---|---|
| A. Azure Data Studio B. Azure Query Editor C. SQL Server-Datentools | _____ 1. Query data while working on a Visual Studio project. _____ 2. Query data residing on a non-Microsoft platform. _____ 3. Query data from the Azure Portal. |
| Article | Description |
|---|---|
| Responder: | SQL Server Data Tools (C) Mailings Description 1: Query data while working in a Visual Studio project. Azure Data Studio (A) corresponds to Description 2: Query data residing on a non-Microsoft platform. The Azure Query Editor (B) corresponds to Description 3: Query data from the Azure portal. |
| Look: | 2.3 Identify basic relational data management tasks |
| Reason: | Azure Data Studio is a cross-platform database tool that you can use with on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Query Editor is available in the Azure portal. You can use this tool to query Azure SQL databases. SQL Server Data Tools are available in Visual Studio. You can use this tool to connect and query local and cloud data services. |
| URL: | https://learn.microsoft.com/training/modules/query-relational-data/3-sql-database?ns-enrollment-type=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals-explore- relationship data
|
Question #9 (sentence completion)
Choose the answer that correctly completes the sentence.
Increasing or decreasing the resources available to a service is known as _____________.
A. Calculations
B. Implementation
C. Nest
D. Escalation
| Article | Description |
|---|---|
| Responder: | D. Escalation |
| Look: | 2.3 Identify basic relational data management tasks |
| Reason: | Scaling is increasing or decreasing the resources used by a service. Computer science is data processing. Deployment is the completion of a series of tasks to create and configure a service. Network is the provision of connectivity to a data resource. |
| URL: | https://learn.microsoft.com/training/modules/explore-provision-deploy-relational-database-offerings-azure/2-describe-provision-relational-data-services |
Question #10 (Mapping)
Queries are created to retrieve data from an Azure SQL Database.
Map the SQL clauses or functions on the left to the requirements on the right.
| SQL clauses | descriptions |
|---|---|
| A. BECOME A MEMBER B. OS C. SUMA D.GRAF | _____ 1. Filter records. _____ 2. Combine rows from multiple tables. _____ 3. Calculate the total value of a numeric column. _____ 4. Determine the number of rows retrieved. |
| Article | Description |
|---|---|
| Responder: | WHERE (B) matches Description 1: Filters records. JOIN(A) matches description 2: it combines rows from multiple tables. SUM (C) corresponds to Description 3: Calculates the total value of a numeric column. COUNT(D) corresponds to Description 4: Determines the number of rows retrieved. |
| Look: | 2.4 Describe data query techniques using the SQL language |
| Reason: | Use the JOIN clause to combine rows retrieved from multiple tables based on a condition. Use the WHERE clause to filter rows. Use the SUM function to calculate the grand total of a numeric column. Use the COUNT function to return the number of rows that match a specific criteria. |
| URL: | https://learn.microsoft.com/training/modules/query-relational-data/6-exercise-perform-query?ns-enrollment-type=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals- Explore relational data |
Question 11 (multiple choice)
What are the three characteristics of non-relational data? Each correct answer represents a complete solution.
A. Required schema for data structures
B. Flexible storage of recorded data
C. Entities describe themselves
D. Entities can have different fields
E. Each row has exactly the same columns
| Article | Description |
|---|---|
| Responder: | B. Flexible storage of recorded data. AND C. Entities describe themselves. AND D. Entities can have different fields. |
| Look: | 3.1 Describing non-relational data workloads |
| Reason: | Characteristics of non-relational data are flexible storage of ingested data, self-describing entities, and the ability to have different fields for entities. Forced schemas are a feature of relational tables. Applying each row to keep the same columns describes a relational table. |
| URL: | https://learn.microsoft.com/training/modules/explore-concepts-of-non-relational-data/2-explore-characteristics |
Question #12 (sentence completion)
Choose the answer that correctly completes the sentence.
You have data consisting of JSON-based documents.
You must store the data in an Azure environment that supports efficient lookups based on keyless fields.
You must use ____________________ as data storage.
A. Azure Table Storage
B. Azure Blob Storage
C. Azure File Storage
D. Azure Cosmos DB
| Article | Description |
|---|---|
| Responder: | D. Azure Cosmos DB |
| Look: | 3.1 Describing non-relational data workloads |
| Reason: | Azure Cosmos DB is a non-relational document database that supports high latency for reads and writes. Automatically adds indexes to elements. Azure Table Storage is a NoSQL key-value store that supports semi-structured dynamic column data. This technique optimizes data retrieval and writing, but performance is poor when looking for partitionless keys and keyless values. Azure File Storage and Blob Storage are for files and blobs, not searchable JSON documents. |
| URL: | https://learn.microsoft.com/training/modules/explore-non-relational-data-offerings-azure/5-explore-azure-cosmos-database?ns-enrollment-type=LearningPath&ns-enrollment-id=learn. wwl.azure-data-fundamentals-explore-non-relational-data |
Question 13 (multiple choice)
You need to create a graphics database.
Which Azure Data Service Should You Use?
A. Blue table
B. Azure Cosmos DB
C. Blue spot
D. Azure-Datei
| Article | Description |
|---|---|
| Responder: | B. Azure Cosmos DB |
| Look: | 3.2 Describe non-relational data offerings on Azure |
| Reason: | Only Azure Cosmos DB supports creating graph databases. Azure Table Storage, Azure Blob Storage, and Azure File Storage do not support graph databases. |
| URL: | https://learn.microsoft.com/training/modules/explore-non-relational-data-offerings-azure/5-explore-azure-cosmos-database |
Question #14 (sentence completion)
Choose the answer that correctly completes the sentence.
It uses Azure Table Storage as a non-relational data store.
You need to optimize data recovery. You must use ______________________________ as the query criteria.
A. Partition key only
B. line keys only
C. Partition key and row key
D. properties only
| Article | Description |
|---|---|
| Responder: | C. Partition key and row key |
| Look: | 3.2 Describe non-relational data offerings on Azure |
| Reason: | You can optimize the performance of reading data with Azure Table Storage when the search completes using a partition key and arrow key. Azure Table Storage does not support property lookup. |
| URL: | https://learn.microsoft.com/training/modules/explore-non-relational-data-offerings-azure/2-explore-azure-table-storage?ns-enrollment-type=LearningPath&ns-enrollment-id=learn. wwl.azure-data-fundamentals-explore-non-relational-data |
Question 15 (multiple choice)
You must use JavaScript Object Notation (JSON) files to provision Azure Storage.
What should you wear?
A. Portal do Azure
B. Azure Command Line Interface (CLI)
C. Azure PowerShell
D. Plantillas de Azure Resource Manager (ARM)
| Article | Description |
|---|---|
| Responder: | D. Plantillas de Azure Resource Manager (ARM) |
| Look: | 3.3 Identify basic non-relational data management tasks |
| Reason: | Azure Resource Manager templates use JSON to create text files to standardize your Azure Storage implementation. The Azure portal, Azure CLI, and Azure PowerShell don't use JSON text files. |
| URL: | https://learn.microsoft.com/training/modules/explore-provision-deploy-non-relational-data-services-azure/2-describe-provision-non-relational-data-services |
Question 16 (multiple choice)
Why should you use a data warehouse?
A. Record daily sales transactions.
B. Perform sales trend analysis.
C. Print sales orders.
D. Sales order search status.
| Article | Description |
|---|---|
| Responder: | B. Perform sales trend analysis |
| Look: | 4.1, Describing Analytical Workloads |
| Reason: | Typically, you build data warehouses to support analytic queries that involve large amounts of data and generate aggregated values. Daily sales entry, report printing, and sales order placement are typical operations found in online data processing (OLTP) databases rather than data warehouses. |
| URL: | https://learn.microsoft.com/training/modules/examine-components-of-modern-data-warehouse/1-introductionhttps://learn.microsoft.com/training/modules/examine-components-of-modern-data-warehouse/2-describe-warehousing |
Question 17 (multiple choice)
Which two Azure data services support Apache Spark clusters? Each correct answer represents a complete solution.
A. Azure Synapse Analysis
B. Azure Cosmos DB
C. Azure Databricks
D. Azure Data Factory
| Article | Description |
|---|---|
| Responder: | A. Azure Synapse Analytics UND C. Azure Databricks |
| Look: | 4.2 Describe the components of a modern data warehouse |
| Reason: | Azure Synapse Analytics and Azure Databricks support using Apache Spark clusters to process data. Azure Cosmos DB is designed for non-relational data. You can use Azure Data Factory for data migration and integration. |
| URL: | https://learn.microsoft.com/training/modules/explore-provision-deploy-non-relational-data-services-azure/2-describe-provision-non-relational-data-services |
Question 18 (multiple choice)
You design a data ingestion and transformation solution using the Azure Data Factory service.
You must retrieve data from an Azure SQL Database.
Which two resources should you use? Each correct answer is part of the solution.
A. Linked Service
B. Data Copy Activity
C. Registration
D. Azure Databricks-Notebook
| Article | Description |
|---|---|
| Responder: | A. Linked Service E B Registration |
| Look: | 4.3 Describe data collection and processing in Azure |
| Reason: | To retrieve data from a source, you must create an Azure Data Factory linked service. The linked service contains details about the data source, including the server name and credentials. You must also define a record to describe the expected data structure. A dataset stores data retrieved from a data source. You can use the Copy Data activity to transfer data from one source to another (destination). You can use an Azure Databricks notebook to process data using Spark clusters with the provided instructions. |
| URL: | https://learn.microsoft.com/training/modules/explore-data-ingestion-azure/2-describe-common-practices-for-data-loading?ns-enrollment-type=LearningPath&ns-enrollment-id=learn. wwl.azure-data-fundamentals-explore-data-warehouse-analytics |
Question 19 (multiple choice)
Which Azure Data Factory component should you use to represent the data you want to collect for processing?
A. Related services
B. Records
c.pipe
D. Cadernos
| Article | Description |
|---|---|
| Responder: | B. Records |
| Look: | 4.3 Describe data collection and processing in Azure |
| Reason: | A dataset represents the data you want ingested for processing. A record can also represent output data from a process. It uses a pipeline to carry out tasks and processes. It uses a linked service to connect to a source or destination. A notebook can contain cells that read data, process it, and write the results to a data store. |
| URL: | https://learn.microsoft.com/training/modules/explore-data-ingestion-azure/2-describe-common-practices-for-data-loading |
Question 20 (multiple choice)
You create reports using Microsoft Power BI.
For which three scenarios can you create Power BI reports as paginated reports? Each correct answer represents a complete solution.
A. A report that has a table image with the option to print all table data
For example, a report that has a table image that can be used to display all of the table's data
C. A report with a repeatable header and footer
D. A report formatted to fit comfortably on a printed page
E. A report that uses only Power BI visuals
| Article | Description |
|---|---|
| Responder: | A. A report that has a table image with the ability to print all data in the AND table C. A report with a repeatable header and footer AND D. A report formatted to fit comfortably on a printed page |
| Look: | 4.4 Describe data visualization in Power BI |
| Reason: | If a Power BI report with a visual table contains multiple rows, only those records that can be displayed are printed. All records are printed, if you design the report as a paginated report using the Report Builder, all records will be printed. Only paginated reports support repeatable headers and footers. You cannot create paginated reports with Power BI visuals. Instead, you must use Report Builder. |
| URL: | https://learn.microsoft.com/training/modules/get-started-with-power-bi/1-introduction?ns-enrollment-type=LearningPath&ns-enrollment-id=learn.wwl.azure-data-fundamentals- explore-analysis-of-data-warehouse |