DP-900 Microsoft Azure Data Fundamentals - Practice Questions - Post 1
Featured Image: 
1. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 1
Option A: See Explanation section for answer.
Answer(s): 1
Explanation:
2. HOTSPOT (Drag and Drop is not supported) For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
Page: Page 1
Option A: See Explanation section for answer.
Answer(s): 1
Explanation:
3. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 1
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.
4. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 1
Option A: See Explanation section for answer.
Answer(s): 1
Explanation:
5. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 2
Answer(s):
Explanation:
6.
Page: Page 2
Answer(s):
Explanation:
7.
Page: Page 2
Answer(s):
Explanation:
8.
Page: Page 2
Answer(s):
Explanation:
9. DRAG DROP (Drag and Drop is not supported) Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:
Page: Page 3
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Box 1: The CRM system Data is extracted from the CRM system. Box 2: The data warehouse Data is loaded to the data warehouse. Box 3: An in-memory data integration tool The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.
10. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 3
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Generally speaking, data analytics comes in four types (Figure 1): Descriptive, to answer the question: What's happening? Diagnostic, to answer the question: Why's happening? Predictive, to answer the question: What will happen? Prescriptive, to answer the question: What actions should we take?
11. DRAG DROP (Drag and Drop is not supported) Match the types of visualizations to the appropriate descriptions. To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:
Page: Page 3
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Box 1: Tree map Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles. Box 2: Key influencer A key influencer chart displays the major contributors to a selected result or value. Box 3: Scatter Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which order, etc.
12. You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Page: Page 3
Option A: zone-redundant storage (ZRS)
Option B: read-access geo-redundant storage (RA-GRS)
Option C: locally-redundant storage (LRS)
Option D: geo-redundant storage (GRS)
Answer(s): 2,4
Explanation: D: Azure Storage offers two options for copying your data to a secondary region: -Geo-redundant storage (GRS) -Geo-zone-redundant storage (GZRS) B: With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
13. HOTSPOT (Drag and Drop is not supported) For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
Page: Page 4
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Box 1: Yes Like IaaS, PaaS includes infrastructure ג€" servers, storage, and networking ג€" but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating. PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources Box 2: No You manage the applications and services you develop, and the cloud service provider typically manages everything else. Box 3: No There really is no way to pause / stop billing for your Azure SQL Database. Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB."
14. Which statement is an example of Data Manipulation Language (DML)?
Page: Page 4
Option A: REVOKE
Option B: DISABLE
Option C: INSERT
Option D: GRANT
Answer(s): 3
Explanation: Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database. -BULK INSERT -DELETE -INSERT -SELECT -UPDATE -MERGE
15. You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create?
Page: Page 4
Option A: an index
Option B: a view
Option C: a scalar function
Option D: a table
Answer(s): 2
Explanation: A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
16. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 4
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Box 1: simple lookups A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation. An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
17. DRAG DROP (Drag and Drop is not supported) Match the types of data to the appropriate Azure data services. To answer, drag the appropriate data type from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:
Page: Page 5
Answer(s):
Explanation:
18.
Page: Page 5
Answer(s):
Explanation:
19.
Page: Page 5
Answer(s):
Explanation:
20.
Page: Page 5
Answer(s):
Explanation:
21. DRAG DROP (Drag and Drop is not supported) Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:
Page: Page 6
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Box 1: Batch Batch processing refers to the processing of blocks of data that have already been stored over a period of time. Box 2: Streaming Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as they get generated and get instant analytics results. Box 3: Batch
22. DRAG DROP (Drag and Drop is not supported) Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:
Page: Page 6
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Box 1: The CRM system Data is extracted from the CRM system. Box 2: The data warehouse Data is loaded to the data warehouse. Box 3: A standalone data analysis tool The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.
23. Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?
Page: Page 6
Option A: predictive
Option B: prescriptive
Option C: descriptive
Option D: diagnostic
Answer(s): 1
Explanation: Predictive, to answer the question. What will happen?
24. Which statement is an example of Data Manipulation Language (DML)?
Page: Page 6
Option A: REVOKE
Option B: DISABLE
Option C: CREATE
Option D: UPDATE
Answer(s): 4
Explanation: Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database. -BULK INSERT -DELETE -INSERT -SELECT -UPDATE -MERGE
25. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 7
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Descriptive, to answer the question. What's happening? Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a full-text transcript for closed captioning and keywords. You can process one media file or multiple media files in a batch.
26. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 7
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Generally speaking, data analytics comes in four types: 1. Descriptive, to answer the question. What's happening? 2. Diagnostic, to answer the question. Why's happening? 3. Predictive, to answer the question. What will happen? 4. Prescriptive, to answer the question. What actions should we take?
27. HOTSPOT (Drag and Drop is not supported) Select the answer that correctly completes the sentence.
Page: Page 7
Option A: See Explanation section for answer.
Answer(s): 1
Explanation: Box: a data pipeline that includes a transformation engine. Extract, transform, and load (ETL) process Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources. It then transforms the data according to business rules, and it loads the data into a destination data store. The transformation work in ETL takes place in a specialized engine, and it often involves using staging tables to temporarily hold data as it is being transformed and ultimately loaded to its destination. Incorrect: * a target store more powerful to transform data With ELT, the data store used to perform the transformation is the same data store where the data is ultimately consumed.
28. You need to create an Azure resource to store data in Azure Table storage. Which command should you run?
Page: Page 7
Option A: az storage share create
Option B: az storage account create
Option C: az cosmosdb create
Option D: az storage container create
Answer(s): 2
Explanation: https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest
29. HOTSPOT (Drag and Drop is not supported) To complete the sentence, select the appropriate option in the answer area. Hot Area:
Page: Page 8
Answer(s):
Explanation:
30.
Page: Page 8
Answer(s):
Explanation: Not available
Post a Comment