DP-900試験無料問題集「Microsoft Azure Data Fundamentals 認定」
Drag and Drop Question
Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level 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 Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level 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:
Box 1: Azure Storage account
Azure file shares are deployed into storage accounts, which are top-level objects that represent a shared pool of storage.
Box 2: Container
In which case you would create a container not a file share. You can have folders and files in the container.
Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share
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
Hotspot Question
Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

正解:

Explanation:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console
Drag and Drop Question
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right.
Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right.
Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

正解:

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:
Speech service, part of Azure Cognitive Services, is certified by SOC, FedRAMP, PCI DSS, HIPAA, HITECH, and ISO.
https://azure.microsoft.com/en-us/services/cognitive-services/speech-to-text/#overview
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: No
You can duplicate a dashboard. The duplicate ends up in the same Power BI workspace. There is no current functionality that allows you to move reports from one workspace to another.
Box 2: No
Box 3: Yes
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://powerbi.microsoft.com/en-us/excel-and-power-bi/
Drag and Drop Question
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right.
Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right.
Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

正解:

Explanation:
Box 1: Microsoft SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.
Box 2: Microsoft Visual Studio Code
Box 3: Azure Data Studio
Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience.
Box 4: Microsoft SQL Server Data Tools (SSDT)
SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
Reference:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
https://code.visualstudio.com/docs/supporting/FAQ
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
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
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/create-reports/desktop-upload-desktop-files