DP-900 V5

DP-900 Microsoft Azure Data Fundamentals exam is a hot Microsoft certification exam, Exam4Training offers you the latest free online DP-900 dumps to practice. You can get online training in the following questions, all these questions are verified by Microsoft experts. If this exam changed, we will share new update questions.

Home » Microsoft » DP-900 V5

Which three requirements must be met to query the table from the internet?

Leave a comment

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.NOTE: Each correct selection is worth one point. (Choose three.)
A . You must be assigned the Reader role for the resource group that contains thedatabase.
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: B,C,E

Explanation:

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15

What should you use to build a Microsoft Power BI paginated report?

Leave a comment

What should you use to build a Microsoft Power BI paginated report?
A . Power BI report Builder
B. Power BI Desktop
C. Charticulator
D. the Power BI service

Answer: A

Explanation:

Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-quickstart-

aw

What should you use?

Leave a comment

Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.

What should you use?
A . Azure DNS
B. Azure Application Gateway
C. Azure Private link
D. Azure Traffic Manager

Answer: C

Explanation:

Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.

Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary

Reference: https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

Match the Azure services to the appropriate requirements

Leave a comment

DRAG DROP

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.

Answer:

Explanation:

Box 1: Azure Data Factory

Box 2: Azure Data Lake Storage

Azure Data Lake Storage (ADLA) now natively supports Parquet files. ADLA adds a public preview of the native extractor and outputter for the popular Parquet file format

Box 3: Azure Synapse Analytics

Use Azure Synapse Analytics Workspaces.

Which type of authentication should you use?

Leave a comment

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

Answer: B

Explanation:

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

Which two types of replica can you us for the storage account?

Leave a comment

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: A,C

Explanation:

Azure Storage offers two options for copying your data to a secondaryregion:

– Geo-redundant storage (GRS)

– Geo-zone-redundant storage (GZRS)

With GRS or GZRS, the data in the secondary region isn’t available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region