Download Microsoft Azure Data Fundamentals.CertDumps.DP-900.2022-08-26.1e.161q.vcex

Download Exam

File Info

Exam Microsoft Azure Data Fundamentals
Number DP-900
File Name Microsoft Azure Data Fundamentals.CertDumps.DP-900.2022-08-26.1e.161q.vcex
Size 8.29 Mb
Posted August 26, 2022
Downloads 58

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Coupon: EXAM_HUB

Discount: 20%


Demo Questions

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

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

  • A: built-in high availability
  • B: native support for cross-database queries and transactions
  • C: system-initiated automatic backups
  • D: support for encryption at rest

Question 3
The visualizations on the Power BI dashboard are known as

  • A: Canvas
  • B: Elements
  • C: Tiles
  • D: Reports

Question 4
Which of the following are the characteristics of real-time data processing? (Select 2 Options)

  • A: Expected low latency
  • B: Periodic data processing
  • C: Data is processed just after creation
  • D: Acceptable high latency

Question 5
Read the statement - "In relational databases, all the values in a column will have the same data type."
Choose the correct option with respect to the given statement.

  • A: Yes
  • B: No

Question 6
An organization has been using a bar chart to present the year-wise sales of a region to track the status of sales year by year. How would you recognize the analytics here?

  • A: Descriptive
  • B: Diagnostic
  • C: Predictive
  • D: Prescriptive

Question 7
You are working in an organization and your client wants to migrate all of his SQL workloads to the Azure such that complete SQL Server compatibility and operating system-level access will be maintained. Which Azure Database would you recommend to the client?

  • A: Azure SQL Database
  • B: Azure Cosmo DB
  • C: Azure SQL Managed Instance
  • D: SQL Server on Virtual Machines

Question 8
Fill in the blank:
A database index allows a query to __________ data efficiently from a database.

  • A: Delete
  • B: Retrieve
  • C: Find
  • D: Search

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

Question 10
You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?

  • A: You need to generate reports without affecting the transactional workload.
  • B: You need to audit the transactional application.
  • C: You need to implement high availability in the event of a regional outage.
  • D: You need to improve the recovery point objective (RPO).



You can buy ProfExam with a 20% discount..

Get Now!


Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen


Use VCE Exam Simulator to open VCE files