Practice Free DP-900 Exam Online Questions
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.
Explanation:
Box 1: Yes
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
You can use Azure Data Studio to connect to an Azure SQL Database server. You’ll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.
Box 2: No
SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks. Instead use Azure Data Studio to create SQL notebook.
Box 3: Yes
You can use the Azure Data Studio to restore databases.
Reference: https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio
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.
Which type of Microsoft Power Bl visual can you use to examine trends over time for one or more series of values?
- A . funnel chart
- B . pie chart
- C . table
- D . line chart
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.
Which statement is an example of Data Definition Language (DDL)?
- A . SELECT
- B . INSERT
- C . DELETE
- D . DROP
D
Explanation:
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database.
These statements include:
ALTER
Collations
CREATE
DROP
DISABLE TRIGGER
ENABLE TRIGGER
RENAME
UPDATE STATISTICS
TRUNCATE TABLE
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
DRAG DROP
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Explanation:
Box 1: The CRM system
Data is extracted from the CRM system.
Box 2: The data warehouse
Data is loaded to the data warehouse.
Box 3: A standalone data analysis tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
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
C
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores
You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
- A . az scorage share create
- B . az scorage account creace
- C . az cosmosdb creace
- D . az scorage concainer creace
B
Explanation:
Reference: https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest
HOTSPOT
To complete the sentence select the appropriate option in the answer area.
