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.leads4pass.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:
Correct Answer:
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:
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:
Correct Answer:
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:
Correct Answer:
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:
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.
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:
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:
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:
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:
Correct Answer:
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.
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.leads4pass.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/