DP-900試験無料問題集「Microsoft Azure Data Fundamentals 認定」

Which statement is an example of Data Definition Language (DDL)?

解説: (GoShiken メンバーにのみ表示されます)
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.
正解:

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
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

解説: (GoShiken メンバーにのみ表示されます)
The visualizations on the Power BI dashboard are known as

解説: (GoShiken メンバーにのみ表示されます)
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

解説: (GoShiken メンバーにのみ表示されます)
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.
正解:

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.
正解:

Explanation:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console
In a fully denormalized database, how is data read and written for a single entity?

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.
正解:
In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

Hotspot Question
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.
正解:

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.
正解:

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.
正解:

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.
正解:

Explanation:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?

解説: (GoShiken メンバーにのみ表示されます)