DP-900 無料問題集「Microsoft Azure Data Fundamentals」
Drag and Drop Question
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right.
Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right.
Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
正解：
Explanation:
ETL
https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl Fact table
https://www.techtarget.com/searchdatamanagement/definition/fact-
table#:~:text=A%20fact%20table%20stores%20quantitative,fact%20table%20can%20be%20anal yzed.
DW
https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing
You work as a Data Associate in a cloud provider company and Data Scientist asks you for a suggestion on which cloud service a client should be used if he wants to get a fully managed platform to run his application, such that he will only use the software with no management. What would you suggest?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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:
A clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column.
Reference:
https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes- in-sql-server
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.
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:
Transparent data encryption (TDE) helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics against the threat of malicious offline activity by encrypting data at rest.
https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde- overview?tabs=azure-portal
Hotspot Question
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
正解：
Explanation:
https://learn.microsoft.com/en-us/power-bi/fundamentals/service-service-vs-desktop
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
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.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered- indexes-described
https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15
Drag and Drop Question
For each of the business questions, choose the appropriate type of analysis to answer the question.
To answer, drag the appropriate analysis type to each question. An analysis type may be used once, more than once, or not at all.
For each of the business questions, choose the appropriate type of analysis to answer the question.
To answer, drag the appropriate analysis type to each question. An analysis type may be used once, more than once, or not at all.
正解：
Explanation:
Cutting cost of sales by at least 5 percent over the next two quarters requires prescriptive analysis to determine the actions you should take to meet that goal. This type of analysis is the goal of prescriptive analysis. Prescriptive analysis is used to help answer questions about what actions should be taken to achieve a goal or target Descriptive analysis would be used to see the correlation between advertising campaigns and recent orders. Descriptive analysis answers questions about what has happened based on historical data and can include complex relationships.
Predictive analysis would be used to determine when to rotate stock from summer to fall items.
Predictive analysis is used to help answer questions about the future by using historic data to identify trends.
None of the questions are based on a scenario in which you would use diagnostic analysis.
Diagnostic analysis looks into why things happen by identifying and analyzing data anomalies.
For example, you might use diagnostic analysis to investigate a sudden, unexpected increase in sales of camping equipment.
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:
Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description#:~:text=Normalization%20is%20the%20process%20of,eliminating%20redundancy%20and%20inconsistent%20dependency