IT Exam Solutions
  • QUESTIONS
  • COURSES
    • CCNA
    • Cisco Enterprise Core
    • VMware vSphere: Install, Configure, Manage
  • CERTIFICATES
No Result
View All Result
  • Login
  • Register
IT Quesion Library
  • Cisco
    • 200-301
    • 200-901
      • Multiple Choice
      • Drag Drop
    • 350-401
      • Multiple Choice
      • Drag Drop
    • 350-701
    • 300-410
      • Multiple Choice
      • Drag Drop
    • 300-415
      • Multiple Choice
      • Drag Drop
    • 300-425
    • Others
  • AWS
    • CLF-C02
    • SAA-C03
    • SAP-C02
    • ANS-C01
    • Others
  • Microsoft
    • AZ-104
    • AZ-204
    • AZ-305
    • AZ-900
    • AI-900
    • SC-900
    • Others
  • CompTIA
    • SY0-601
    • N10-008
    • 220-1101
    • 220-1102
    • Others
  • Google
    • Associate Cloud Engineer
    • Professional Cloud Architect
    • Professional Cloud DevOps Engineer
    • Others
  • ISACA
    • CISM
    • CRIS
    • Others
  • LPI
    • 101-500
    • 102-500
    • 201-450
    • 202-450
  • Fortinet
    • NSE4_FGT-7.2
  • VMware
  • >>
    • Juniper
    • EC-Council
      • 312-50v12
    • ISC
      • CISSP
    • PMI
      • PMP
    • Palo Alto Networks
    • RedHat
    • Oracle
    • GIAC
    • F5
    • ITILF
    • Salesforce
Contribute
IT Exam Solutions
  • QUESTIONS
  • COURSES
    • CCNA
    • Cisco Enterprise Core
    • VMware vSphere: Install, Configure, Manage
  • CERTIFICATES
No Result
View All Result
IT Exam Solutions
No Result
View All Result
Home Practice Test Free

DP-900 Practice Test Free

Table of Contents

Toggle
  • DP-900 Practice Test Free – 50 Questions to Test Your Knowledge
  • 50 Free DP-900 Practice Questions
  • Get More DP-900 Practice Questions

DP-900 Practice Test Free – 50 Questions to Test Your Knowledge

Are you preparing for the DP-900 certification exam? If so, taking a DP-900 practice test free is one of the best ways to assess your knowledge and improve your chances of passing. In this post, we provide 50 free DP-900 practice questions designed to help you test your skills and identify areas for improvement.

By taking a free DP-900 practice test, you can:

  • Familiarize yourself with the exam format and question types
  • Identify your strengths and weaknesses
  • Gain confidence before the actual exam

50 Free DP-900 Practice Questions

Below, you will find 50 free DP-900 practice questions to help you prepare for the exam. These questions are designed to reflect the real exam structure and difficulty level.

Question 1

HOTSPOT -
You have the following JSON document.
 Image
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Hot Area:
 Image

 









Suggested Answer:

Correct Answer Image


Reference:

https://www.w3schools.com/js/js_json_arrays.asp


https://www.w3schools.com/js/js_json_objects.asp








Question 2




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/








Question 3




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

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








Question 4




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.

Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl








Question 5




You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.


A. zone-redundant storage (ZRS)


B. read-access geo-redundant storage (RA-GRS)


C. locally-redundant storage (LRS)


D. geo-redundant storage (GRS)


 










Suggested Answer: BD


D: Azure Storage offers two options for copying your data to a secondary region:

✑ Geo-redundant storage (GRS)

✑ Geo-zone-redundant storage (GZRS)

B: With GRS or GZRS, the data in the secondary region isn’t available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-

GZRS).

Reference:

https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region








Question 6




You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?


A. az storage share create


B. az storage account create


C. az cosmosdb create


D. az storage container create


 










Suggested Answer: D


Reference:

https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest








Question 7




DRAG DROP -
Match the Azure Data Factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
 Image


 










Suggested Answer:

Correct Answer Image


Box 1: Dataset –

Datasets must be created from paths in Azure datastores or public web URLs, for the data to be accessible by Azure Machine Learning.

Box 2: Linked service –

Linked services are much like connection strings, which define the connection information needed for Data Factory to connect to external resources.

Box 3: Pipeline –

A pipeline is a logical grouping of activities that together perform a task.

Reference:

https://k21academy.com/microsoft-azure/dp-100/datastores-and-datasets-in-azure/

https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services

https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities








Question 8




DRAG DROP -
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.
Select and Place:
 Image


 










Suggested Answer:

Correct Answer Image


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: File share –

Reference:

https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share








Question 9




What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.


A. Data is processed periodically


B. Low latency is expected


C. High latency is acceptable


D. Data is processed as it is created


 










Suggested Answer: BD


Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses.

Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/real-time-processing








Question 10




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:
 Image


 










Suggested Answer:

Correct Answer Image


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 –

Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing








Question 11




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


When to use batch processing.

You might expect latencies when using batch processing. For many situations, however, this type of delay before the transfer of data begins is not a big issue – the processes that use this function are not mission critical at the exact moment.

Reference:

https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/








Question 12




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Box 1: simple lookups –

A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value

(either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.

An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.

Reference:

https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview








Question 13




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:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

https://www.sqlshack.com/what-is-database-normalization-in-sql-server/








Question 14




You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?


A. an index


B. a view


C. a scalar function


D. a table


 










Suggested Answer: B


A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/views/views








Question 15




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:
 Image


 










Suggested Answer:

Correct Answer Image


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 16




DRAG DROP -
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
 Image


 










Suggested Answer: Incorrect Answer:


Box 1: Diagnostic –

Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships.

Box 2: Prescriptive –

Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.

Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome

Box 3: Descriptive –

✑ Generally speaking, data analytics comes in four types:

✑ Descriptive, to answer the question: What’s happening?

✑ Diagnostic, to answer the question: Why’s happening?

✑ Predictive, to answer the question: What will happen?

✑ Prescriptive, to answer the question: What actions should we take?

Reference Image

Reference: alt=”Reference Image” />

Reference:

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

https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/








Question 17




Which type of database contains nodes and edges?


A. graph


B. key/value


C. columnar


D. time series


 










Suggested Answer: A


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 18




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture








Question 19




A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as
IntelliSense.
What should the developers use?


A. sqlcmd


B. Microsoft SQL Server Management Studio (SSMS)


C. Azure Data Studio


D. Azure Data Explorer


 










Suggested Answer: C


Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.

Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.

Reference:

https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio








Question 20




HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


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








Question 21




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


When you create a new server in Azure SQL Database or Azure Synapse Analytics named mysqlserver, for example, a server-level firewall blocks all access to the public endpoint for the server

Reference:

https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql








Question 22




What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.


A. access to the latest features


B. complete control over backup and restore processes


C. in-database machine learning services


D. reduced administrative effort for managing the server infrastructure


 










Suggested Answer: AD


A: Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

D: SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview








Question 23




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15








Question 24




Which storage solution supports access control lists (ACLs) at the file and folder level?


A. Azure Data Lake Storage


B. Azure Queue storage


C. Azure Blob storage


D. Azure Cosmos DB


 










Suggested Answer: A


Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).

Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control








Question 25




When can you use an Azure Resource Manager template?


A. to automate the creation of an interdependent group of Azure resources in a repeatable way


B. to apply Azure policies for multi-tenant deployments


C. to provision Azure subscriptions


D. to control which services and feature administrators and developers can deploy from the Azure portal


 










Suggested Answer: A


You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed

To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object

Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.

Reference:

https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview








Question 26




DRAG DROP -
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.
Select and Place:
 Image


 










Suggested Answer:

Correct Answer Image


Box 1: Tree map –

Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles.

<img src=”https://www.examtopics.com/assets/media/exam-media/04277/0002600001.jpg” alt=”Reference Image” />

Box 2: Key influencer –

A key influencer chart displays the major contributors to a selected result or value.

Box 3: Scatter –

Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures — whether or not, in which order, etc.








Question 27




HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


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 –

Reference Image

✑ GROUPING_ID

✑ MAX

✑ MIN

✑ STDEV

✑ STDEVP

✑ STRING_AGG

✑ SUM

✑ VAR

✑ VARP

Reference: alt=”Reference Image” />

✑ 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 28




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Generally speaking, data analytics comes in four types (Figure 1):

Descriptive, to answer the question: What’s happening?

Diagnostic, to answer the question: Why’s happening?

Predictive, to answer the question: What will happen?

Prescriptive, to answer the question: What actions should we take?

Reference:

https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/








Question 29




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:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl








Question 30




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Disadvantages of non-relational databases include: Data Consistency ג€” non-relational databases do not perform ACID transactions.

Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.

Incorrect Answers:

Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes.

Use Cloud storage (no relational database) for geographically distributed writes.

Reference:

https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77








Question 31




Which type of database is Azure Database for PostgreSQL?


A. Platform as a service (PaaS)


B. Infrastructure as a service (IaaS)


C. Microsoft SQL Server


D. on-premises


 










Suggested Answer: A


Reference:

https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options








Question 32




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15








Question 33




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Generally speaking, data analytics comes in four types:

1. Descriptive, to answer the question: What’s happening?

2. Diagnostic, to answer the question: Why’s happening?

3. Predictive, to answer the question: What will happen?

4. Prescriptive, to answer the question: What actions should we take?

Reference Image

Reference: alt=”Reference Image” />

Reference:

https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/








Question 34




HOTSPOT -
You are reviewing the data model shown in the following exhibit.
 Image
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Box 1: star schema –

In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.

Example:

Reference Image

Incorrect Answers:

The data in the question is not normalized.

The snowflake schema is a variation of the star schema, featuring normalization of dimension tables. Example:

Reference Image

Note: A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.[citation needed]. “Snowflaking” is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.

Box 2: dimension –

The star schema consists of one or more fact tables referencing any number of dimension tables.

Reference: alt=”Reference Image” />

Incorrect Answers:

The data in the question is not normalized.

The snowflake schema is a variation of the star schema, featuring normalization of dimension tables. Example:

<img src=”https://www.examtopics.com/assets/media/exam-media/04277/0001600001.jpg” alt=”Reference Image” />

Note: A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.[citation needed]. “Snowflaking” is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.

Box 2: dimension –

The star schema consists of one or more fact tables referencing any number of dimension tables.

Reference:

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview

https://en.wikipedia.org/wiki/Star_schema

https://en.wikipedia.org/wiki/Snowflake_schema

https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/








Question 35




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Descriptive, to answer the question: What’s happening?

Reference Image

Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a full-text transcript for closed captioning and keywords.

You can process one media file or multiple media files in a batch.

Reference: alt=”Reference Image” />

Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a full-text transcript for closed captioning and keywords.

You can process one media file or multiple media files in a batch.

Reference:

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

https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

https://docs.microsoft.com/en-us/azure/media-services/previous/media-services-index-content








Question 36




Which statement is an example of Data Manipulation Language (DML)?


A. REVOKE


B. DISABLE


C. CREATE


D. UPDATE


 










Suggested Answer: D


Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.

BULK INSERT –

DELETE –

INSERT –

SELECT –

UPDATE –

MERGE –

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements








Question 37




HOTSPOT -
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

https://azure.microsoft.com/en-us/overview/what-is-saas/


https://azure.microsoft.com/en-us/overview/what-is-paas/








Question 38




DRAG DROP -
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 stages. Each location 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.
Select and Place:
 Image


 










Suggested Answer:

Correct Answer Image


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: A standalone data analysis tool

The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.

Reference Image

Reference: alt=”Reference Image” />

Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl








Question 39




DRAG DROP -
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
 Image


 










Suggested Answer:

Correct Answer Image


Box 1: Batch –

Batch processing refers to the processing of blocks of data that have already been stored over a period of time.

Box 2: Streaming –

Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as they get generated and get instant analytics results.

Box 3: Batch –

Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing








Question 40




HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Azure Cosmos DB SQL API accounts provide support for querying items using the Structured Query Language (SQL) syntax.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api








Question 41




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:
 Image


 










Suggested Answer:

Correct Answer Image


Box 1: Yes –

Like IaaS, PaaS includes infrastructure ג€” servers, storage, and networking ג€” but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.

PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources

Box 2: No –

You manage the applications and services you develop, and the cloud service provider typically manages everything else.

Reference Image

Box 3: No –

There really is no way to pause / stop billing for your Azure SQL Database.

Microsoft’s official answer “Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB.”

Reference: alt=”Reference Image” />

Box 3: No –

There really is no way to pause / stop billing for your Azure SQL Database.

Microsoft’s official answer “Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB.”

Reference:

https://azure.microsoft.com/en-us/overview/what-is-paas








Question 42




Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
 Image
Which type of analysis is shown in the fourth quarter?


A. predictive


B. prescriptive


C. descriptive


D. diagnostic


 










Suggested Answer: A


Predictive, to answer the question: What will happen?

Reference Image

Reference: alt=”Reference Image” />

Reference:

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

https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/








Question 43




DRAG DROP -
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data type from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
 Image


 










Suggested Answer:

Correct Answer Image


Box 1: Image files –

Azure Blob storage is suitable for image files.

Box 2:Key/value pairs –

Azure CosmosDB table API is a key-value storage hosted in the cloud.

Box 3: Relationship between employees

One-to-many relationships between business domain objects occur frequently: for example, one department has many employees. There are several ways to implement one-to-many relationships in the Azure Table service.

Reference:

https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling








Question 44




DRAG DROP -
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 stages. Each location 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.
Select and Place:
 Image


 










Suggested Answer:

Correct Answer Image


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.

Reference Image

Reference: alt=”Reference Image” />

Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl








Question 45




Which statement is an example of Data Manipulation Language (DML)?


A. REVOKE


B. DISABLE


C. INSERT


D. GRANT


 










Suggested Answer: C


Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.

BULK INSERT –

Reference Image

✑ DELETE

✑ INSERT

✑ SELECT

✑ UPDATE

✑ MERGE

Reference: alt=”Reference Image” />

✑ DELETE

✑ INSERT

✑ SELECT

✑ UPDATE

✑ MERGE

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements








Question 46




You have a data store that has the structure shown in the following exhibit.
 Image
Which type of data store is this?


A. key/value


B. object data


C. graph


D. time series


 










Suggested Answer: C


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 47




You need to modify a view in a relational database by adding a new column.
Which statement should you use?


A. MERGE


B. ALTER


C. INSERT


D. UPDATE


 










Suggested Answer: B


 








Question 48




Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?


A. atomicity


B. isolation


C. durability


D. consistency


 










Suggested Answer: A


The purpose of making transactions atomic is to prevent different transactions from interfering with one another. This can only happen if more than one user process is trying to access the database at the same time, as when a server allows several clients to use it concurrently. The simplest way to enforce atomicity is for the DBMS to refuse to start any transaction until the previous one has committed.

Reference:

https://www.sciencedirect.com/topics/computer-science/atomic-transaction








Question 49




HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
 Image


 










Suggested Answer:

Correct Answer Image


Semi-structured data –

Semi-structured data (e.g., JSON, CSV, XML) is the ג€bridgeג€ between structured and unstructured data. It does not have a predefined data model and is more complex than structured data, yet easier to store than unstructured data.

Reference:

https://www.ibm.com/cloud/blog/structured-vs-unstructured-data








Question 50




DRAG DROP -
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.
Select and Place:
 Image


 










Suggested Answer:

Correct Answer Image


Reference:

https://en.wikipedia.org/wiki/Table_(database)


https://en.wikipedia.org/wiki/View_(SQL)


https://en.wikipedia.org/wiki/Database_index






Get More DP-900 Practice Questions


If you’re looking for more DP-900 practice test free questions, click here to access the full DP-900 practice test.


We regularly update this page with new practice questions, so be sure to check back frequently.


Good luck with your DP-900 certification journey!

                                
	                            
                                                            



                        

	                    

                

                    Share18Tweet11
                    

                    
                

                
                

            

	                    
                        

            
            Previous Post
            
DP-500 Practice Test Free

        
    
            
            Next Post
            
DVA-C01 Practice Test Free

        
    
    

        Next Post

                    

                

                                        
                        
                    
                

                

                    
                        DVA-C01 Practice Test Free                    
                

            

                    

                

                                        
                        
                    
                

                

                    
                        DVA-C02 Practice Test Free                    
                

            

                    

                

                                        
                        
                    
                

                

                    
                        GISF Practice Test Free                    
                

            

                
        
    


	

		
Leave a Reply Cancel reply
Your email address will not be published. Required fields are marked *
 
 


 


 


 


 


	

	

                                    

            

            


    

                

                    
Recommended

                    
                

                

                
                

                

                

                    
                    

                

                

                    

                        DP-100 Practice Test Free
                    

                    
                

            

                

                    
                    

                

                

                    

                        XK0-005 Practice Test Free
                    

                    
                

            

                

                    
                    

                

                

                    

                        XK0-004 Practice Test Free
                    

                    
                

            

                

                    
                    

                

                

                    

                        SY0-701 Practice Test Free
                    

                    
                

            

                

                    
                    

                

                

                    

                        SY0-601 Practice Test Free
                    

                    
                

            

                

                    
                    

                

                

                    

                        SY0-501 Practice Test Free
                    

                    
                

            

            

                

                

                    

                        
                    

                    

                        

                            

                        

                    

                    

                        

                    

                

            

            

            

                

                
                
            

                
                
            
        


        

            
        


    



                

            


            


            
        


        

    

        

            
        

        

            

                

            

        

        

            

        

    



    

        

            

    

        

            

                

                    

                        

                            
  • About
    • 

  • DMCA
    • 

  • Privacy & Policy
    • 

  • Contact
    • 

                        

                        

                            

                                                            

                        

                    


                    
                    

                        

                            
 ITexamsolutions.net Materials do not contain actual questions and answers from Cisco's Certification Exams. ITexamsolutions.net doesn't offer Real Microsoft Exam Questions. ITexamsolutions.net doesn't offer Real Amazon Exam Questions.
 

                        

                        


                            			

				  			

			
                        

                    


                                        
                

            

        

    


        


        

        	
        

    


    


    
    

    

        

    

        

    

        
    
                    
  •  Login
    • 
                    
  •  Sign Up
    • 
                    
                
	





    
    

    
    





    

    

    

        No Result    

    

         View All Result    



    
  • Quesions

      
	
    • Cisco
      • 
	
    • AWS
      • 
	
    • Microsoft
      • 
	
    • CompTIA
      • 
	
    • Google
      • 
	
    • ISACA
      • 
	
    • ECCouncil
      • 
	
    • F5
      • 
	
    • GIAC
      • 
	
    • ISC
      • 
	
    • Juniper
      • 
	
    • LPI
      • 
	
    • Oracle
      • 
	
    • Palo Alto Networks
      • 
	
    • PMI
      • 
	
    • RedHat
      • 
	
    • Salesforce
      • 
	
    • VMware
      • 

    

    • 

  • Courses

      
	
    • CCNA
      • 
	
    • ENCOR
      • 
	
    • VMware vSphere
      • 

    

    • 

  • Certificates
    • 

    

    

            


    





    

        

            
Welcome Back!
            
Login to your account below


            
            

            

                
            

            

                
            

            

                
                
            

			

			

                
                
                
            

            

                Forgotten Password?
                                 Sign Up
                            

        

    







    

        

            
Create New Account!
            
Fill the forms below to register


            
            


            

                
            

            

                
            

			

            

                
                
                
            

                        

                All fields are required.
                 Log In
            

        

    







    

        

            
Retrieve your password

            
Please enter your username or email address to reset your password.


            
            


            

                
            

			

            

                
                
                
            

            

                 Log In
            

        

    



                

                

                    

                        

                        

                        

                    

                    

                        

                            

                            
                            
                            
                            
                            

                                

                                    

                                        

                                    

                                

                            

                        

                        

                            

                        

                        
                        
                        

                            

                        

                    

                

            

                        

                            
              
                                

                            

                                
      
                            
 
                        
      
                      























































		
		


		

		

		

				
Insert/edit link

		
		

			

				
Enter the destination URL

				

					
				

				

					
				

				

					
				

			

			
Or link to existing content

			

				

					
				

				

					
    
					
    
						
					
    
				
    
				
    
					
    
						No search term specified. Showing recent items.
						
							Search or use up and down arrow keys to select an item.