Microsoft DP-900 Actual Free Exam Questions & Community Discussion
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.
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.
Correct 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 a nd outputter for the popular Parquet file format Box 3: Azure Synapse Analytics Use Azure Synapse Analytics Workspaces.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-co decs
For each of the following statements. select Yes if the statement is true. Otherwise, select No.
NOTE Each correct selection is worth one point.
NOTE Each correct selection is worth one point.
Correct Answer:
Which language is used to define queries in Azure Synapse Data Explorer?
Correct Answer: D
Vote an answer
SELECT, INSERT, and UPDATE are examples of which type of SQL statement?
Correct Answer: B
Vote an answer
You need to store data by using Azure Table storage.
What should you create first?
What should you create first?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer:
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.
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.
Correct Answer:
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 trans formation 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
You have data in a tabular format as shown in the following table.
Of which type of data is this an example?
Of which type of data is this an example?
Correct Answer: A
Vote an answer
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?
Which Azure service should you use to support the application?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Expl anation:
Box 1: Yes
Like IaaS, PaaS includes infrastructure - servers, storage, and networking - but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources Box 2: Yes You manage the applications and services you develop, and the cloud service provider typically manages everything else.
Box 3: No
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft ' s official answer " Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB. " ference:
https://azure.microsoft. com/en-us/overview/what-is-paas
htt ps://feedback.azure.com/forums/2173 21-sql-database/suggestions/69311 52-please-add-abilit y-to- temporarily-turn-off-on-sql
You have an application that runs on Windows and requires across to a mapped drive.
Which Azure service should you use?
Which Azure service should you use?
Correct Answer: D
Vote an answer
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
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?
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?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
0
0
0
10