DP-900のPDF問題集で2024年08月22日最近更新された問題 [Q28-Q47]

DP-900のPDF問題集で2024年08月22日最近更新された問題

DP-900試験問題有効なDP-900問題集PDF

質問 # 28
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?

A. columnar
B. graph
C. key/value
D. document

正解：A

解説：
Section: Describe how to work with non-relational data on Azure
Explanation/Reference:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores

質問 # 29
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

正解：

解説：

Section: Describe core data concepts
Explanation/Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive- cognitive-analytics/

質問 # 30
Select the answer that correctly completes the sentence.

正解：

解説：

Explanation
Graphical user interface, text, application, email Description automatically generated

A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the
data hierarchy.

質問 # 31
You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount day. The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.

正解：

解説：

質問 # 32
Which clause should you use in a select statement to combine rows in one table with rows in another table?

A. KEY
B. JOIN
C. VALUES
D. set

正解：B

解説：
Reference:
https://www.tutorialspoint.com/sql/sql-using-joins.htm

質問 # 33
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service from the column on the left to its requirement on the right. Each
service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

正解：

解説：

Explanation

Box 1: Azure Data Factory
Box 2: Azure Data Lake Storage
Azure Data Lake Storage (ADLA) now natively supports Parquet files. ADLA adds a public preview of the
native extractor and outputter for the popular Parquet file format
Box 3: Azure Synapse Analytics
Use Azure Synapse Analytics Workspaces.

質問 # 34
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

Explanation
Table Description automatically generated

A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.

質問 # 35
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service from the column on the left to its requirement on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs

質問 # 36
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer
presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.

A. data acquisition and preparation
B. data modeling
C. report sharing and distribution
D. report and dashboard creation

正解：A、D

質問 # 37
Select the answer that correctly completes the sentence.

正解：

解説：

質問 # 38
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

正解：

解説：

質問 # 39
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. Each location may be used 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.

正解：

解説：

Explanation

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: An in-memory data integration tool
The data transformation that takes place usually involves various operations, such as filtering, sorting,
aggregating, joining data, cleaning data, deduplicating, and validating data.

質問 # 40
Select the answer that correctly completes the sentence.

正解：

解説：

質問 # 41
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

質問 # 42
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

質問 # 43
Select the answer that correctly completes the sentence.

正解：

解説：

質問 # 44
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
Big data solutions often use long-running batch jobs to filter, aggregate, and otherwise prepare the data for analysis. Usually these jobs involve reading source files from scalable storage (like HDFS, Azure Data Lake Store, and Azure Storage), processing them, and writing the output to new files in scalable storage.
Box 2: No
Box 3: No

質問 # 45
What is a characteristic of a non-relational database?

A. a fixed schema
B. full support for Transact-SQL
C. self-describ ing entities

正解：B

質問 # 46
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.