Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
Microsoft
Exam Questions DP-900
Microsoft Azure Data Fundamentals
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
NEW QUESTION 1
A bar chart showing year-to date sales by region is an example of which type of analytics?
A. descriptive
B. diagnostic
C. predictive
D. prescriptive
Answer: B
NEW QUESTION 2
Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the
reporting solution use?
A. stream processing
B. Online Transaction Processing (OLTP)
C. batch processing
D. Online Analytical Processing (OLAP)
Answer: D
NEW QUESTION 3
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. container
B. item
C. database
D. partition
Answer: AC
NEW QUESTION 4
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 5
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.
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.
Answer: ACE
NEW QUESTION 6
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
To complete the sentence, select the appropriate option in the answer area.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 7
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 8
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 9
You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
A. Microsoft SQL Server Data Tools (SSDT)
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Databricks
D. Azure Data Studio
Answer: A
NEW QUESTION 10
To complete the sentence, select the appropriate option in the answer area.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 10
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
Which type of authentication should you use?
A. service principal authentication
B. Azure Active Directory (Azure AD) authentication
C. SQL authentication
D. certificate authentication
Answer: B
NEW QUESTION 12
To complete the sentence select the appropriate option in the answer area.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 16
What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
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
Answer: A
NEW QUESTION 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.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
NEW QUESTION 25
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.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 27
Which scenario is an example of a streaming workload?
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
Answer: C
NEW QUESTION 30
To complete the sentence, select the appropriate option in the answer area.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
NEW QUESTION 32
When can you use an Azure Resource Manager template?
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
Answer: C
NEW QUESTION 33
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. MERGE
D. CREATE
Answer: D
NEW QUESTION 35
You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?
A. Online Transaction Processing (OLTP)
B. batch processing
C. Online Analytical Processing (OLAP)
D. stream processing
Answer: A
NEW QUESTION 39
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 43
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
To complete the sentence, select the appropriate option in the answer area.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 44
For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 45
You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario?
A. Online Transaction Processing (OLTP)
B. batch
C. massively parallel processing (MPP)
D. streaming
Answer: D
NEW QUESTION 47
Which Azure Data Factory component provides the compute environment for activities?
A. a linked service
B. an integration runtime
C. a control flow
D. a pipeline
Answer: A
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
NEW QUESTION 50
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 53
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
A. document
B. columnar
C. graph
D. time series
Answer: A
NEW QUESTION 58
For each of the following statements, select yes if he statement is true, Otherwise select No. NOTE: Each correct selection is worth one point.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 63
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 65
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 67
To complete the sentence, select the appropriate option in the answer area.
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 72
What are two uses of data visualization? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.
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
Answer: AC
NEW QUESTION 75
Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of
data store should you use?
A. relational
B. columnar
C. graph
D. time series
Answer: A
NEW 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.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 80
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?
A. queue
B. blob
C. file
D. table
Answer: B
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
NEW QUESTION 81
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.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
NEW QUESTION 83
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
Answer: A
NEW QUESTION 86
You need to create an Azure Storage account.
Data in the account must replica outside the Azure region automatically.
Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one pint.
A. read-access geo-redundant storage (RA_GRS)
B. zone-redundant storage (ZRS)
C. geo-redundant storage (GRS)
D. locally-redundant storage (LRS)
Answer: AC
NEW QUESTION 88
To complete the sentence, select the appropriate option in the answer area.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 93
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SCX database from the computers. The developers require code assistance features such as intellSense.
What should the developers use ?
A. Azure Data Studio
B. sq1cmd
C. Microsoft SQL Server Management Studio (SSMS)
D. Azure Data Explorer
Answer: B
NEW QUESTION 96
To complete the sentence, select the appropriate option in the answer area.
A. Mastered
B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 98
......
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure DP-900 dumps!
https://www.certshared.com/exam/DP-900/ (122 Q&As)
Thank You for Trying Our Product
We offer two products:
1st - We have Practice Tests Software with Actual Exam Questions
2nd - Questons and Answers in PDF Format
DP-900 Practice Exam Features:
* DP-900 Questions and Answers Updated Frequently
* DP-900 Practice Questions Verified by Expert Senior Certified Staff
* DP-900 Most Realistic Questions that Guarantee you a Pass on Your FirstTry
* DP-900 Practice Test Questions in Multiple Choice Formats and Updatesfor 1 Year
100% Actual & Verified — Instant Download, Please Click
Order The DP-900 Practice Test Here
Guaranteed success with Our exam guides visit - https://www.certshared.com
Powered by TCPDF (www.tcpdf.org)
