Summer Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test

Page: 1 / 31
Total 313 questions

Microsoft Azure Data Fundamentals Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$49  $139.99

PDF Study Guide

  • Product Type: PDF Study Guide
$42  $119.99
Question 1

Select the answer that correctly completes the sentence.

Options:

Question 2

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

Options:

A.

Scale down the data warehouse units (DWUs).

B.

Pause the pool.

C.

Create a user-defined restore point.

D.

Delete the pool

Question 3

Select the answer that correctly completes the sentence.

Options:

Question 4

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:

Question 5

You have an Azure SQL database that you access directly from the internet.

You recently changed your external IP address.

After changing the IP address, you can no longer access the database. You can connect to other resources in Azure

What is a possible cause of the issue?

Options:

A.

a database-level firewall

B.

role-based access control (RSAC)

C.

Dynamic Host Configuration Protocol (DHCP)

D.

Domain Name Service (DNS)

Question 6

Select the answer that correctly completes the sentence.

Options:

Question 7

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

Question 8

Select the answer that correctly completes the sentence.

Options:

Question 9

You are reviewing the data model shown in the following exhibit.

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

Options:

Question 10

Select the answer that correctly completes the sentence.

Options:

Question 11

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

Options:

A.

an Azure SQL Database elastic pool

B.

Azure SQL Managed Instance

C.

Azure Database for MySQL

D.

Azure SQL Database

Question 12

Match the job roles to the appropriate tasks.

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

NOTE: Each correct match is worth one point.

Options:

Question 13

What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?

Options:

A.

a few milliseconds

B.

a few seconds

C.

a few minutes

D.

a few hours

Question 14

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:

Question 15

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

Question 16

What is a primary characteristic of a relational database?

Options:

A.

data is queried and manipulated by using a variant of the SQL language

B.

a flexible data structure

C.

a lack of dependencies between tables

D.

a large amount of duplicate data

Question 17

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:

Question 18

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

Options:

A.

Data Definition Language (DDL)

B.

Data Control Language (DCL)

C.

Data Manipulation Language (DML)

Question 19

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

Options:

Question 20

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:

Question 21

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

Options:

Question 22

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:

Question 23

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:

Question 24

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

Question 25

Select the answer that correctly completes the sentence.

Options:

Question 26

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

Question 27

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:

Question 28

You need to store event log data that is semi-structured and received as the logs occur. What should you use?

Options:

A.

Azure Table storage

B.

Azure Queue storage

C.

Azure Files

Question 29

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:

Question 30

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

Options:

A.

sqlcmd

B.

bcp

C.

azdata

D.

Azure CLI

Question 31

Select the answer that correctly completes the sentence.

Options:

Question 32

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:

Question 33

Select the answer that correctly completes the sentence.

Options:

Question 34

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

Question 35

Select the answer that correctly completes the sentence.

Options:

Question 36

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

Options:

Question 37

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:

Question 38

You need to create an Azure resource to store data in Azure Table storage.

Which command should you run?

Options:

A.

az scorage share create

B.

az scorage account creace

C.

az cosmosdb creace

D.

az scorage concainer creace

Question 39

Which Azure Data Factory component provides the compute environment for activities?

Options:

A.

a linked service

B.

an integration runtime

C.

a control flow

D.

a pipeline

Question 40

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

Options:

Question 41

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 recommend?

Options:

A.

document

B.

key/value

C.

object

D.

columnar

Question 42

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

Options:

Question 43

Which type of database is Azure Database for PostgreSQL?

Options:

A.

Platform as a service (PaaS)

B.

Infrastructure as a service (laaS)

C.

Microsoft SQL Server

D.

on-premises

Question 44

tence.

Options:

Question 45

Which scenario is an example of a streaming workload?

Options:

A.

sending transactions that are older than a month to an archive

B.

sending transactions daily from point of sale (POS) devices

C.

sending telemetry data from edge devices

D.

sending cloud infrastructure metadata every 30 minutes

Question 46

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

Options:

Question 47

You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.

Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options:

A.

JOIN

B.

ORDERBY

C.

INDEX

D.

SLLLCT

E.

EXISTS

Question 48

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:

Question 49

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.

Question 50

Select the answer that correctly completes the sentence.

Options:

Question 51

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:

Question 52

You manage an application that stores data in a shared folder on a Windows server.

You need to move the shared folder to Azure Storage.

Which type of Azure Storage should you use?

Options:

A.

queue

B.

blob

C.

file

D.

table

Question 53

Select the answer that correctly completes the sentence.

Options:

Question 54

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

Options:

Question 55

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

Options:

Question 56

Match the types of activities to the appropriate Azure Data Factory activities.

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

NOTE: Each correct match is worth one point.

Options:

Question 57

Select the answer that correctly completes the sentence.

Options:

Question 58

What can you use to create data ingestion pipelines?

Options:

A.

Azure HDInsight

B.

Azure SQL Database

C.

Azure Data Factory

D.

Azure Cosmos DB

Question 59

Which setting can only be configured during the creation of an Azure Cosmos DB account?

Options:

A.

geo-redundancy

B.

multi-region writes

C.

production or non-reduction account type

D.

API

Question 60

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

Options:

Question 61

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

Options:

A.

stream processing

B.

batch processing

C.

Online Analytical Processing (OLTP)

D.

Online Transaction Processing (OLTP)

Question 62

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.

Options:

Question 63

Select the answer that correctly completes the sentence.

Options:

Question 64

Match the ACID 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 aft.

NOTE: Each correct match is worth one point.

Options:

Question 65

Select the answer that correctly completes the sentence.

Options:

Question 66

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:

Question 67

Which type of Microsoft Power Bl visual can you use to examine trends over time for one or more series of values?

Options:

A.

funnel chart

B.

pie chart

C.

table

D.

line chart

Question 68

Select the answer that correctly completes the sentence.

Options:

Question 69

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

Question 70

Select the answer that correctly completes the sentence.

Options:

Question 71

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:

Question 72

Select the answer that correctly completes the sentence.

Options:

Question 73

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

Question 74

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

Options:

Question 75

Select the answer that correctly completes the sentence.

Options:

Question 76

Match the tools to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

Options:

Question 77

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.

Which type of data store should you use?

Options:

A.

graph

B.

key/value

C.

document

D.

columnar

Question 78

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:

Question 79

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

Question 80

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.

Options:

Question 81

Select the answer that correctly completes the sentence.

Options:

Question 82

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:

Question 83

You have data in a tabular format as shown in the following table.

Of which type of data is this an example?

Options:

A.

unstructured data

B.

semi-structured data

C.

document

D.

structured data

Question 84

Select the answer that correctly completes the sentence.

Options:

Question 85

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

Options:

Question 86

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.

Options:

Question 87

Select the answer that correctly completes the sentence.

Options:

Question 88

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Options:

A.

native support for cross-database queries and transactions

B.

built-in high availability

C.

system-Initiated automatic backups

D.

support for encryption at rest

Question 89

Which Azure Storage service implements the key/value model?

Options:

A.

Azure Files

B.

Azure Table

C.

Azure Blob

D.

Azure Queue

Question 90

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:

Question 91

How is raw data stored in a data lakehoose?

Options:

A.

as tables

B.

as queues

C.

as files

D.

as disks

Question 92

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Options:

A.

WHERE

B.

SELECT

C.

JOIN

Question 93

What is a characteristic of non-relational data?

Options:

A.

a well-defined schema

B.

no indexes

C.

self-describing entities

D.

no unique key values

Page: 1 / 31
Total 313 questions