DP-900試験無料問題集「Microsoft Azure Data Fundamentals 認定」
Drag and Drop Question
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.
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.
正解：
Explanation:
Box 1: Tree map
Treemaps are chart 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.
https://docs.microsoft.com/en-us/learn/modules/explore-concepts-of-data-analytics/3-explore- data-visualization
Drag and Drop Question
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.
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.
正解：
Explanation:
Box 1: Image files
Image files are what you upload on a blob, as they are unstructured data.
Box 2: Relationship between employees
Relationships between employees are context based, meaning the entities will exist as nodes in a graph and you will use the Cosmos DB Gremlin API.
Box 3: Key/value pairs
Key/value data can be stored in a Cosmos DB, but it can also be stored in an Azure Table.
Reference:
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling
Hotspot Question
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
正解：
Explanation:
Batch data can be run weekly, monthly, or even yearly.
Hotspot Question
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
Star Schema in data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. It is known as star schema as its structure resembles a star.
Dimension tables describe business entities - the things you model. Entities can include products, people, places, and concepts including time itself.
Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc. A fact table contains dimension key columns that relate to dimension tables, and numeric measure columns.
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Hotspot Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
Box 1: Yes
Compute is separate from storage, which enables you to scale compute independently of the data in your system.
Box 2: Yes
You can use the Azure portal to pause and resume the dedicated SQL pool compute resources.
Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be charged compute during that hour.
Box 3: No
Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2 TBs.
Reference:
https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/
Hotspot Question
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
正解：
Explanation:
Clustered indexes sort and store the data rows in the table or view based on their key values.
These are the columns included in the index definition. There can be only one clustered index per table, because the data rows themselves can be stored in only one order.