Practice Microsoft Certified: Azure Data Fundamentals DP-900 exam. Online Exam Practice Tests with detailed explanations! Pass DP-900 with confidence!
DP-900 - Microsoft Azure Data Fundamentals Practice Tests 2024 | ExamsReviews
NEW QUESTION # 77
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Yes
Tables are database objects that contain all the data in a database. In tables, data is logically organized in a
row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column
represents a field in the record.
Box 2: No
An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or
view.
Box 3: Yes
A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named
columns and rows of data.
NEW QUESTION # 78
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://www.sqlshack.com/graph-database-implementation-with-azure-cosmos-db-using-the-api/
NEW QUESTION # 79
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api
NEW QUESTION # 80
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://azure.microsoft.com/en-us/overview/what-is-saas/
https://azure.microsoft.com/en-us/overview/what-is-paas/
NEW QUESTION # 81
To complete the sentence select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION # 82
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.
Answer:
Explanation:
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.
NEW QUESTION # 83
Select the answer that correctly completes the sentence.
Answer:
Explanation:
NEW QUESTION # 84
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
Disadvantages of non-relational databases include: Data Consistency - non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
NEW QUESTION # 85
match the Azure data factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference:
https://k21academy.com/microsoft-azure/dp-100/datastores-and-datasets-in-azure/
https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities
NEW QUESTION # 86
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api
NEW QUESTION # 87
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.
Answer:
Explanation:
Explanation
Graphical user interface, text, application, chat or text message Description automatically generated
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.
Graphical user interface, text, application Description automatically generated
NEW QUESTION # 88
Select the answer that correctly completes the sentence.
Answer:
Explanation:
NEW QUESTION # 89
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
- A. Online Analytical Processing (OLAP)
- B. stream processing
- C. Online Transaction Processing (OLTP)
- D. batch processing
Answer: C
Explanation:
Explanation
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers
day to day transaction of an organization.
NEW QUESTION # 90
Select the answer that correctly completes the sentence.
Answer:
Explanation:
See the answer below:
Answer as below.
NEW QUESTION # 91
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types 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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling
NEW QUESTION # 92
......
Get instant access to DP-900 practice exam questions: https://drive.google.com/open?id=1MmBVEDC5bcLIB6fb2FsOzvtRS6Rgj_Pj
The best DP-900 exam study material and preparation tool is here: https://www.examsreviews.com/DP-900-pass4sure-exam-review.html