DP-900 practice engine – Prepaway Exam Dumps

Get Ready to Pass the DP-900 exam Right Now Using Our Microsoft Certified: Azure Data Fundamentals Exam Package

Enhance Your Career With Available Preparation Guide for DP-900 Exam

NO.79 Which type of database is Azure Database for PostgreSQL?

Platform as a service (PaaS)

Infrastructure as a service (laaS)

Microsoft SQL Server

on-premises

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

NO.80 To complete the sentence, select the appropriate option in the answer area.

Reference:
https://www.sqlshack.com/graph-database-implementation-with-azure-cosmos-db-using-the-api/

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

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

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

Reference:
https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/

NO.83 To complete the sentence, select the appropriate option in the answer area.

Explanation
Paginated Reports
https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/

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

Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy
https://manojchoudhari.wordpress.com/2019/12/16/azure-cosmos-db-enable-multi-region-writes

NO.85 To complete the sentence, select the appropriate option in the answer area.

NO.86 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.

NO.87 Which command-line tool can you use to query Azure SQL databases?

sqlcmd

bcp

azdata

Azure CLI

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

Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs

NO.89 You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?

Azure Functions

Microsoft SQL Server Integration Services (SSIS)

PolyBase

Azure Data Factory

Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html

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

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/

NO.91 Match the Azure Data Lake Storage 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.

NO.92 You have the following JSON document.

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.

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

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

NO.94 To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-cosmosdb-resources-portal

Loading …

Microsoft DP-900: Microsoft Azure Data Fundamentals exam is designed for individuals who are interested in pursuing a career in data science and data analysis using Microsoft Azure. Microsoft Azure Data Fundamentals certification exam focuses on the fundamental concepts of data storage, management, and processing in the cloud environment. DP-900 exam is intended for data professionals, business analysts, IT professionals, and developers who want to gain knowledge and skills in working with data on the Azure platform.

Get Special Discount Offer of DP-900 Certification Exam Sample Questions and Answers: https://www.prepawayexam.com/Microsoft/braindumps.DP-900.ete.file.html

Prepaway Exam Dumps

Tag: DP-900 practice engine

Get Ready to Pass the DP-900 exam Right Now Using Our Microsoft Certified: Azure Data Fundamentals Exam Package [Q79-Q94]

Tag Archives: DP-900 practice engine