Skip to main content This browser is no longer supported. Show
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. DP-900: Microsoft Azure Data Fundamentals Sample Questions
In this articleLast Updated: 3/26/2022 PLEASE COMPLETE THIS SURVEY (https://aka.ms/samplequestions) Microsoft is exploring the possibility of providing sample questions as an exam preparation resource, and we would like your feedback. While we prefer that you complete the survey after taking the exam, you may complete it at any time. Thank You! User GuideThese sample questions are intended to provide an overview of the style, wording, and difficulty of the questions that you are likely to experience on this exam. These questions are not the same as what you will see on the exam nor is this document illustrative of the length of the exam or its complexity (e.g., you may see additional question types, multiple case studies, and possibly labs). These questions are examples only to provide insight into what to expect on the exam and help you determine if additional preparation is required. In the first section, you will find the questions without answers so that you can test your knowledge. In the second section, the answer, a rationale, and a URL that will link you to additional information is provided immediately below each question. QuestionsQuestion # 1 (Sentence completion)Select the answer that correctly completes the sentence. Objects in which things about data should be captured and stored are called: ____________. A. tables Question # 2 (Sentence completion)Select the answer that correctly completes the sentence. You need to process data that is generated continuously and near real-time responses are required. You should use _________. A. batch processing Question # 3 (Matching)You are evaluating data processing approaches. Match the data processing approaches on the left to the requirements on the right.
Question # 4 (Multiple choice)Select the answer that correctly completes the sentence. The technique that provides recommended actions that you should take to achieve a goal or target is called _____________ analytics. A. descriptive Question # 5 (Matching)Match the data processing objects on the left to the requirements on the right.
Question # 6 (Sentence completion)Select the answer that correctly completes the sentence. The process of splitting an entity into more than one table to reduce data redundancy is called: _____________. A. deduplication Question # 7 (Sentence completion)Select the answer that correctly completes the sentence. Azure SQL Database is an example of ________________ -as-a-service. A. platform Question # 8 (Matching)You need to query an Azure SQL database. Match the query tools on the left to the correct scenarios on the right.
Question # 9 (Sentence completion)Select the answer that correctly completes the sentence. The act of increasing or decreasing the resources that are available for a service is called: _____________. A. computing Question # 10 (Matching)You are creating queries to retrieve data from an Azure SQL database. Match the SQL clauses or functions on the left to the requirements on the right.
Question # 11 (Multiple choice)What are three characteristics of non-relational data? Each correct answer presents a complete solution. A. Forced schema on data structures Question # 12 (Sentence completion)Select the answer that correctly completes the sentence. You have data that consists of JSON-based documents. You need to store the data in an Azure environment that supports efficient non-key, field-based searching. You should use _______________________ as the data store. A. Azure Table Storage Question # 13 (Multiple Choice)You need to create a graph database. Which Azure data service should you use? A. Azure Table Question # 14 (Sentence completion)Select the answer that correctly completes the sentence. You use Azure Table Storage as a non-relational data store. You need to optimize data retrieval. You should use ______________________________ as query criteria. A. only partition keys Question # 15 (Multiple Choice)You need to use JavaScript Object Notation (JSON) files to provision Azure storage. What should you use? A. Azure portal Question # 16 (Multiple Choice)For which reason should you deploy a data warehouse? A. Record daily sales transactions. Question # 17 (Multiple Choice)Which two Azure data services support Apache Spark clusters? Each correct answer presents a complete solution. A. Azure Synapse Analytics Question # 18 (Multiple Choice)You design a data ingestion and transformation solution by using Azure Data Factory service. You need to get data from an Azure SQL database. Which two resources should you use? Each correct answer presents part of the solution. A. Linked service Question # 19 (Multiple Choice)Which Azure Data Factory component should you use to represent data that you want to ingest for processing? A. Linked services Question # 20 (Multiple Choice)You are designing reports by using Microsoft Power BI. For which three scenarios can you create Power BI reports as paginated reports? Each correct answer presents a complete solution. A. a report that has a table visual with an
ability to print all the data in the table Questions and AnswersQuestion # 1 (Sentence completion)Select the answer that correctly completes the sentence. Objects in which things about data should be captured and stored are called: ____________. A. tables
Question # 2 (Sentence completion)Select the answer that correctly completes the sentence. You need to process data that is generated continuously and near real-time responses are required. You should use _________. A. batch processing
Question # 3 (Matching)You are evaluating data processing approaches. Match the data processing approaches on the left to the requirements on the right.
Question # 4 (Multiple choice)Select the answer that correctly completes the sentence. The technique that provides recommended actions that you should take to achieve a goal or target is called _____________ analytics. A. descriptive
Question # 5 (Matching)Match the data processing objects on the left to the requirements on the right.
Question # 6 (Sentence completion)Select the answer that correctly completes the sentence. The process of splitting an entity into more than one table to reduce data redundancy is called: _____________. A. deduplication
Question # 7 (Sentence completion)Select the answer that correctly completes the sentence. Azure SQL Database is an example of ________________ -as-a-service. A. platform
Question # 8 (Matching)You need to query an Azure SQL database. Match the query tools on the left to the correct scenarios on the right.
Question # 9 (Sentence completion)Select the answer that correctly completes the sentence. The act of increasing or decreasing the resources that are available for a service is called: _____________. A. computing
Question # 10 (Matching)You are creating queries to retrieve data from an Azure SQL database. Match the SQL clauses or functions on the left to the requirements on the right.
Question # 11 (Multiple choice)What are three characteristics of non-relational data? Each correct answer presents a complete solution. A. Forced schema on data structures
Question # 12 (Sentence completion)Select the answer that correctly completes the sentence. You have data that consists of JSON-based documents. You need to store the data in an Azure environment that supports efficient non-key, field-based searching. You should use _______________________ as the data store. A. Azure Table Storage
Question # 13 (Multiple Choice)You need to create a graph database. Which Azure data service should you use? A. Azure Table
Question # 14 (Sentence completion)Select the answer that correctly completes the sentence. You use Azure Table Storage as a non-relational data store. You need to optimize data retrieval. You should use ______________________________ as query criteria. A. only partition keys
Question # 15 (Multiple Choice)You need to use JavaScript Object Notation (JSON) files to provision Azure storage. What should you use? A. Azure portal
Question # 16 (Multiple Choice)For which reason should you deploy a data warehouse? A. Record daily sales transactions.
Question # 17 (Multiple Choice)Which two Azure data services support Apache Spark clusters? Each correct answer presents a complete solution. A. Azure Synapse Analytics
Question # 18 (Multiple Choice)You design a data ingestion and transformation solution by using Azure Data Factory service. You need to get data from an Azure SQL database. Which two resources should you use? Each correct answer presents part of the solution. A. Linked service
Question # 19 (Multiple Choice)Which Azure Data Factory component should you use to represent data that you want to ingest for processing? A. Linked services
Question # 20 (Multiple Choice)You are designing reports by using Microsoft Power BI. For which three scenarios can you create Power BI reports as paginated reports? Each correct answer presents a complete solution. A. a report that has a table visual with an ability to print all the data in the table
What do data analysts use to label the type of data contained in each column in a spreadsheet?These column labels are usually called attributes. An attribute is a characteristic or quality of data used to label a column in a table.
Which of the following tasks would a data analyst be responsible for select all that apply?Data analysts are responsible for analyzing data using statistical techniques, implementing and maintaining databases, gathering data from primary and secondary sources, identifying, analyzing and interpreting trends from the data.
What process do data analysts use to keep project related files together?What process do data analysts use to keep project-related files together and organize them into subfolders? Data analysts use archiving to separate current from past work.
During which phase of data analysis would a data analyst use spreadsheet?During which phase would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions? The analyze step involves using data analytics tools such as spreadsheets and query languages to transform data in order to draw conclusions and make informed decisions.
|