Microsoft DP-900 Exam Questions Instant Access

Question 1

Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

AArchive to Cool

BHot to Cool

CCool to Archive

DHot to Archive

Answer : A, A

Question 2

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

AMERGE

BALTER

CINSERT

DUPDATE

Answer : B, B

Question 3

Which type of Microsoft Power Bl visual can you use to examine trends over time for one or more series of values?

Bpie chart

Afunnel chart

Ctable

Bpie chart

Dline chart

Ctable

Dline chart

Answer : D, D

Question 4

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?

Astream processing

BOnline Transaction Processing (OLTP)

Cbatch processing

DOnline Analytical Processing (OLAP)

Answer : B, B

https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

Question 5

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

Aa waterfall chart

Ba ribbon chart

Ca bar chart

Da decomposition tree

Answer : A, A

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Question 6

Which storage solution supports access control lists (ACLs) at the file and folder level?

AAzure Data Lake Storage

BAzure Cosmos DB

CAzure Queue storage

DAzure Blob storage

Answer : A, A

Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).

https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

Question 7

You have an Azure SQL database that you access directly from the internet.

You recently changed your external IP address.

After changing the IP address, you can no longer access the database. You can connect to other resources in Azure

What is a possible cause of the issue?

Aa database-level firewall

Brole-based access control (RSAC)

CDynamic Host Configuration Protocol (DHCP)

DDomain Name Service (DNS)

Answer : A, A

The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database.

When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.

https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/

Microsoft Azure Data Fundamentals DP-900 Exam Questions