Page: 1
/ 14
Total 306 questions
Microsoft Azure Data Fundamentals DP-900 Exam Practice Test
Question 1
Your company is designing a data store that will contain student dat
a. The data has the following format.
Which type of data store should you use?
Answer : D
Question 2
Which statement is an example of Data Definition Language (DDL)?
Question 3
Your company needs to implement a relational database in Azure. The solution must minimize ongoing
maintenance.
Which Azure service should you use?
Question 4
What should you use to build a Microsoft Power BI paginated report?
Answer : A
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
Question 5
You need to store data by using Azure Table storage.
What should you create first?
Answer : B
First create an Azure storage account, then use Table service in the Azure portal to create a table.
Note: An Azure storage account contains all of your Azure Storage data objects: blobs, files, queues, and tables.
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-quickstart-portal
https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create
Question 6
Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?
Answer : A
Question 7
When you create an Azure SQL database, which account can always connect to the database ?
Answer : D
When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart
All Official Question Types