[30-March-2021] New Fundamentals DP-900 Dumps with VCE and PDF from Lead4Pass (Latest Update)

New 2021 Fundamentals DP-900 exam questions from Lead4Pass DP-900 dumps!
Welcome to download the newest Lead4Pass DP-900 dumps VCE and PDF: https://www.lead4pass.com/dp-900.html (162 Q&As)

P.S. Free 2021 Fundamentals DP-900 Dumps are available on Google Drive shared by Lead4Pass: https://drive.google.com/file/d/1-vDM036k6WxmOSpGK297NTBEmOMFBFjM/

Free Fundamentals DP-900 exam questions and answers

QUESTION 1

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?

A. service principal authentication
B. Azure Active Directory (Azure AD) authentication
C. SQL authentication
D. certificate authentication

Correct Answer: B
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

 

QUESTION 2

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:

microsoft dp-900 exam questions q2

Correct Answer:

microsoft dp-900 exam questions q2-1

Box 1: No
A pipeline is a logical grouping of activities that together perform a task.
Box 2: Yes
You can construct pipeline hierarchies with data factory.
Box 3: Yes
A pipeline is a logical grouping of activities that together perform a task.
Reference:
https://mrpaulandrew.com/2019/09/25/azure-data-factory-pipeline-hierarchies-generation-control/

 

QUESTION 3

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

microsoft dp-900 exam questions q3

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

 

QUESTION 4

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.ach term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

microsoft dp-900 exam questions q4

Correct Answer:

microsoft dp-900 exam questions q4-1

Reference:
https://en.wikipedia.org/wiki/Table_(database)#:~:text=A%20table%20is%20a%20collection,table%20format%20within
%20a%20database.andtext=In%20relational%20databases%2C%20and%20flat,a%20row%20and%20column%20inter
sect.
https://en.wikipedia.org/wiki/View_(SQL)
https://en.wikipedia.org/wiki/Database_index#:~:text=A%20database%20index%20is%20a,maintain%20the%20index%
20data%20structure.

 

QUESTION 5

Your company is designing a database that will contain session data for a website. The data will include
notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will
provide the lowest latency to retrieve the data?

A. key/value
B. graph
C. columnar
D. document

Correct Answer: C
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores

 

QUESTION 6

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:

microsoft dp-900 exam questions q6

Correct Answer:

microsoft dp-900 exam questions q6-1

Box 1: Yes
Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-andcolumn format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in
the record.
Box 2: No
An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view.
Box 3: Yes
A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns
and rows of data.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described
https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15

 

QUESTION 7

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

microsoft dp-900 exam questions q7

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

 

QUESTION 8

You have an application that runs on Windows and requires across to a mapped drive. Which Azure service should you
use?

A. Azure Cosmos DB
B. Azure Table storage
C. Azure Files
D. Azure Blob Storage

Correct Answer: A

 

QUESTION 9

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

microsoft dp-900 exam questions q9

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:

microsoft dp-900 exam questions q9-1

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:

microsoft dp-900 exam questions q9-2

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:

microsoft dp-900 exam questions q9-3

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-tablesoverview 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 10

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

A. sqlcmd
B. bcp
C. azdata
D. Azure CLI

Correct Answer: D
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-contentguide?tabs=singledatabase

 

QUESTION 11

Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema. Which type of data store should you use?

A. key/value
B. document
C. graph
D. columnar

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

 

QUESTION 12

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

microsoft dp-900 exam questions q12

Correct Answer:

microsoft dp-900 exam questions q12-1

Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

 

QUESTION 13

Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit.

microsoft dp-900 exam questions q13

Which type of analysis is shown for the fourth quarter?

A. predictive
B. prescription
C. descriptive
D. diagnostic

Correct Answer: B

Continue to follow to get more free updates…

New 2021 Fundamentals DP-900 exam questions from Lead4Pass DP-900 Dumps! Welcome to download the newest Lead4Pass DP-900 VCE and PDF dumps: https://www.lead4pass.com/dp-900.html (162 Q&As)

P.S. Free 2021 Fundamentals DP-900 Dumps are available on Google Drive shared by Lead4Pass: https://drive.google.com/file/d/1-vDM036k6WxmOSpGK297NTBEmOMFBFjM/

Author: exam

On our Fulldumps platform, you can search for all free Microsoft exams and test or practice online for yourself. And can download PDF files. Any other questions, you can email [email protected]