Microsoft DP-900 Exam Practice Questions (P. 5)
- Full Access (306 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #42
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer:
A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.
Reference:
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15
A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.
Reference:
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15
Question #43
What is a characteristic of batch processing?
- AThe data ingested during batch processing must be processed as soon as the data is received.
- BLarge datasets must be split into batches of less than 1 GB before the data can be processed.
- CThere is a noticeable time delay between ingesting data and obtaining the data processing results.
- DBatch processing can only process data that is structured.
Correct Answer:
D
D
GPT-4o - Answer
Batch processing indeed accommodates various types of data, including structured, semi-structured, and unstructured. Therefore, stating that it can only process structured data, as indicated in option D, is incorrect. The correct characteristic of batch processing is reflected in option C, where there is an expected delay between data ingestion and processing outcomes, which aligns with the general understanding of batch processing systems as handling large data volumes with latency from minutes to hours. This delay allows for handling and analyzing substantial amounts of accumulated data efficiently.
Question #44
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer:
An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:
✑ APPROX_COUNT_DISTINCT
✑ AVG
✑ CHECKSUM_AGG
✑ COUNT
✑ COUNT_BIG
GROUPING -
✑ GROUPING_ID
✑ MAX
✑ MIN
✑ STDEV
✑ STDEVP
✑ STRING_AGG
✑ SUM
✑ VAR
✑ VARP
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15
An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:
✑ APPROX_COUNT_DISTINCT
✑ AVG
✑ CHECKSUM_AGG
✑ COUNT
✑ COUNT_BIG
GROUPING -
✑ GROUPING_ID
✑ MAX
✑ MIN
✑ STDEV
✑ STDEVP
✑ STRING_AGG
✑ SUM
✑ VAR
✑ VARP
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15
Question #45
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Yes -
Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.
Box 2: Yes -
Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.
Box 3: No -
Reference:
https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/
Box 1: Yes -
Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.
Box 2: Yes -
Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.
Box 3: No -
Reference:
https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/
Question #46
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer:
The same set of columns.
In relational databases, a row is a data record within a table. Each row, which represents a complete record of specific item data, holds different data within the same structure. A row is occasionally referred to as a tuple.
Incorrect:
Not: a key value pair.
Unlike relational databases, key-value databases do not have a specified structure. Relational databases store data in tables where each column has an assigned data type. Key-value databases are a collection of key-value pairs that are stored as individual records and do not have a predefined data structure.
Reference:
https://www.techopedia.com/definition/4425/database-row
https://www.techtarget.com/searchdatamanagement/tip/NoSQL-database-types-explained-Key-value-store
The same set of columns.
In relational databases, a row is a data record within a table. Each row, which represents a complete record of specific item data, holds different data within the same structure. A row is occasionally referred to as a tuple.
Incorrect:
Not: a key value pair.
Unlike relational databases, key-value databases do not have a specified structure. Relational databases store data in tables where each column has an assigned data type. Key-value databases are a collection of key-value pairs that are stored as individual records and do not have a predefined data structure.
Reference:
https://www.techopedia.com/definition/4425/database-row
https://www.techtarget.com/searchdatamanagement/tip/NoSQL-database-types-explained-Key-value-store
Question #47
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: No -
Database normalization is the process of restructuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.
Full normalisation will generally not improve performance, in fact it can often make it worse but it will keep your data duplicate free.
Box 2: No -
Analytics systems are deformalized to increase performance.
Transactional database systems are normalized to increase data consistency.
Box 3: Yes -
Transactional database systems are more normalized and requires more joins.
Reference:
https://www.sqlshack.com/what-is-database-normalization-in-sql-server
Box 1: No -
Database normalization is the process of restructuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.
Full normalisation will generally not improve performance, in fact it can often make it worse but it will keep your data duplicate free.
Box 2: No -
Analytics systems are deformalized to increase performance.
Transactional database systems are normalized to increase data consistency.
Box 3: Yes -
Transactional database systems are more normalized and requires more joins.
Reference:
https://www.sqlshack.com/what-is-database-normalization-in-sql-server
Question #48
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer:
A graph database stores two types of information, nodes and edges. Edges specify relationships between nodes. Nodes and edges can have properties that provide information about that node or edge, similar to columns in a table. Edges can also have a direction indicating the nature of the relationship.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
A graph database stores two types of information, nodes and edges. Edges specify relationships between nodes. Nodes and edges can have properties that provide information about that node or edge, similar to columns in a table. Edges can also have a direction indicating the nature of the relationship.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
Question #49
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer:
A key/value store associates each data value with a unique key.
Key/value stores are highly optimized for applications performing simple lookups, but are less suitable if you need to query data across different key/value stores.
Key/value stores are also not optimized for querying by value.
A single key/value store can be extremely scalable, as the data store can easily distribute data across multiple nodes on separate machines.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
A key/value store associates each data value with a unique key.
Key/value stores are highly optimized for applications performing simple lookups, but are less suitable if you need to query data across different key/value stores.
Key/value stores are also not optimized for querying by value.
A single key/value store can be extremely scalable, as the data store can easily distribute data across multiple nodes on separate machines.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
Question #50
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer:
SQL Server on Azure VM -
SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure.
The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine. With this additional control comes the added responsibility to manage the virtual machine.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql
SQL Server on Azure VM -
SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure.
The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine. With this additional control comes the added responsibility to manage the virtual machine.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql
All Pages