Summer Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

DP-900 Sample Questions Answers

Questions 4

What are two uses of data visualization? Each correct answer present a complete solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Represent trends and patterns over time.

B.

Communicate the significance of data.

C.

implement machine learning to predict future values.

D.

Consistently implement business logic across reports

Buy Now
Questions 5

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 6

You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.

Which type of data store should you rec ommend?

Options:

A.

document

B.

key/value

C.

object

D.

columnar

Buy Now
Questions 7

Match the types of data stores to the appropriate scenarios.

To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Options:

Buy Now
Questions 8

When you create an Azure SQL database, which account can always connect to the database ?

Options:

A.

the Azure Active director/ (Azure AO) account that created the database

B.

the Azure Active Directly Azure AD) administrator account

C.

the sa account

D.

the server admin login account of the logical server

Buy Now
Questions 9

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?

Options:

A.

Azure Functions

B.

Microsoft SQL Server Integration Services (SSIS)

C.

PolyBase

D.

Azure Data Factory

Buy Now
Questions 10

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 11

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

Options:

Buy Now
Questions 12

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 13

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 14

What is a difference between structured data and semi-structured data?

Options:

A.

Structured data has a fixed schema and semi-structured data has a flexible schema.

B.

Only Structured data supports entities.

C.

Structured data has a flexible schema and semi-structured data has a fixed schema.

D.

Only Structured data supports attributes.

Buy Now
Questions 15

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.

Options:

Buy Now
Questions 16

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.

Options:

Buy Now
Questions 17

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?

Options:

A.

a scalar function

B.

a table

C.

an index

D.

a view

Buy Now
Questions 18

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 19

You need to gather real-time telemetry data from a mobile application.

Which type of workload describes this scenario?

Options:

A.

Online Transaction Processing (OLTP)

B.

batch

C.

massively parallel processing (MPP)

D.

streaming

Buy Now
Questions 20

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

Options:

A.

INSERT

B.

MERGE

C.

UPDATE

D.

CREATE

Buy Now
Questions 21

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 22

Which three actions are used when performing diagnostic analytics?

Options:

A.

• Identify data anomalies

• Collect anomaly-related data

• Discover relationships and trends that explain anomalies.

B.

• Identify data anomalies

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

C.

• Apply serf-learning loops to draw inferences from anomalies.

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

D.

• Identify data anomalies

• Use machine learning to find patterns in large datasets.

• Discover relationships and trends that explain anomalies.

Buy Now
Questions 23

What can be used with native notebook support to query and visualize data by using a web-based interface?

Options:

A.

Azure Databricks

B.

pgAdmin

C.

Microsoft Power Bl

Buy Now
Questions 24

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 25

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

Options:

A.

a waterfall chart

B.

a ribbon chart

C.

a bar chart

D.

a decomposition tree

Buy Now
Questions 26

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

Options:

Buy Now
Questions 27

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

Options:

Buy Now
Questions 28

You have an Azure Cosmos DB account that uses the Core (SQL) API.

Which two settings can you configure at the container level? Each correct answer presents a complete

solution. (Choose two.)

NOTE: Each correct selection is worth one point.

Options:

A.

the throughput

B.

the read region

C.

the partition key

D.

the API

Buy Now
Questions 29

You have an application that runs on Windows and requires access to a mapped drive.

Which Azure service should you use?

Options:

A.

Azure Files

B.

Azure Blob storage

C.

Azure Cosmos DB

D.

Azure Table storage

Buy Now
Questions 30

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

Options:

Buy Now
Questions 31

When can you use an Azure Resource Manager template?

Options:

A.

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

B.

to automate the creation of an interdependent and develop can deploy from the Azure portal

C.

To provision Azure subscriptions and apply policies for multi-tenant deployments

D.

To set complex permissions automatically on existing objects in an Azure subscription

Buy Now
Questions 32

Select the answer that correctly completes the sentence.For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 33

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

Options:

Buy Now
Questions 34

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 35

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

Options:

A.

SELECT

B.

INSERT

C.

DELETE

D.

DROP

Buy Now
Questions 36

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL

database.

Which type of authentication should you use?

Options:

A.

service principal authentication

B.

Azure Active Directory (Azure AD) authentication

C.

SQL authentication

D.

certificate authentication

Buy Now
Questions 37

Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

Options:

A.

graph

B.

key/value

C.

object

D.

columnar

Buy Now
Questions 38

Which Azure Data Factory component initiates the execution of a pipeline?

Options:

A.

a control flow

B.

a trigger

C.

a parameter

D.

an activity

Buy Now
Questions 39

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.

The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.

What should the developers use ?

Options:

A.

Azure Data Studio

B.

sq1cmd

C.

Microsoft SQL Server Management Studio (SSMS)

D.

Azure Data Explorer

Buy Now
Questions 40

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

Options:

Buy Now
Questions 41

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

Options:

A.

sqlcmd

B.

bcp

C.

azdata

D.

Azure CLI

Buy Now
Questions 42

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 43

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

Options:

Buy Now
Questions 44

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query. What should you create?

Options:

A.

a table

B.

an index

C.

scalar function

D.

a view

Buy Now
Questions 45

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 46

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Options:

A.

extract transform, and load (ETL)

B.

a data warehouse

C.

online analytical processing (OLAP)

D.

online transaction processing (OLTP)

Buy Now
Questions 47

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 48

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

Options:

A.

multi-master replication

B.

Availability Zones

C.

automatic failover

D.

the strong consistency level

Buy Now
Questions 49

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.

Options:

Buy Now
Questions 50

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 51

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

Options:

Buy Now
Questions 52

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.

Options:

Buy Now
Questions 53

A data engineer is responsible for which task?

Options:

A.

Design and build analytical models.

B.

Design and implement data stores for analytical workloads.

C.

Explore data to identify trends.

D.

Implement policies, tools. and processes for backup and recovery plans.

Buy Now
Questions 54

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Options:

A.

Azure SQL Database Hyperscale

B.

Azure SQL managed instance

C.

Azure SQL Database serveless

D.

Azure SQL Database elastic pod

Buy Now
Questions 55

Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Azure Databricks

B.

Azure Log Analytics

C.

Azure Time Series Insights

D.

Azure HDinsight

Buy Now
Questions 56

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

Options:

A.

isolation

B.

durability

C.

consistency

D.

atomicity

Buy Now
Questions 57

To complement the sentence, select the appropriate option in the answer area.

Options:

Buy Now
Questions 58

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

Options:

Buy Now
Questions 59

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

Options:

A.

JOIN

B.

VALUES

C.

set

D.

KEY

Buy Now
Questions 60

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 61

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

Options:

Buy Now
Questions 62

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

Options:

Buy Now
Questions 63

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.

Options:

Buy Now
Questions 64

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 65

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,

backups, and maintenance tasks?

Options:

A.

Azure SQL Managed Instance

B.

SQL Server on Azure Virtual Machines

C.

Azure SQL Edge

D.

Azure SQL Database

Buy Now
Questions 66

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Options:

A.

normalized data

B.

schema defined in a database

C.

schema defined when reading unstructured data from a database

D.

normalized data

E.

light writes and heavy reads

F.

heavy writes and moderate reads

Buy Now
Questions 67

Match the processes to the appropriate scenarios.

To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Options:

Buy Now
Questions 68

Match the Azure services to appropriate requirements.

To answer, drag the appropriate services 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.

Options:

Buy Now
Questions 69

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 70

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

You must be assigned the Reader role for the resource group that contains the database.

B.

You must have SELECT access to the Products table.

C.

You must have a user in the database.

D.

You must be assigned the Contributor role for the resource group that contains the database.

E.

Your IP address must be allowed to connect to the database.

Buy Now
Questions 71

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 72

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 73

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

denormalized data

B.

schema defined when reading unstructured data from a database

C.

light writes and heavy reads

D.

normalized data

E.

schema defined in a database

F.

heavy writes and moderate reads

Buy Now
Questions 74

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 75

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 76

You have the following SQL query.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 77

You have data saved in the following format.

\

Which format was used?

Options:

A.

XML

B.

yaml

C.

JSON

D.

HTML

Buy Now
Questions 78

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 79

A bar chart showing year-to date sales by region is an example of which type of analytics?

Options:

A.

descriptive

B.

diagnostic

C.

predictive

D.

prescriptive

Buy Now
Questions 80

Match the Azure services to the appropriate locations in the architecture.

To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Options:

Buy Now
Questions 81

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 82

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

Options:

Buy Now
Questions 83

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.

Options:

Buy Now
Questions 84

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

Options:

A.

Azure Data Lake Storage

B.

Azure Cosmos DB

C.

Azure Queue storage

D.

Azure Blob storage

Buy Now
Questions 85

Select the answer that correctly completes the sentence.

Options:

Buy Now
Questions 86

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

Options:

Buy Now
Questions 87

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

Options:

Buy Now
Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Jun 10, 2024
Questions: 292
$68  $169.99
$52  $129.99
$44  $109.99
buy now DP-900