




























































































Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
A collection of past questions and answers related to the dp-900 exam, covering topics such as data warehousing, analytics, and database concepts. It offers a valuable resource for individuals preparing for the dp-900 certification exam, helping them assess their understanding and identify areas for further study.
Typology: Exams
1 / 148
This page cannot be seen from the preview
Don't miss anything!
A tumbling window can run a job using data for a specific period of time, and not before or after that. SQL Database supports two purchasing models. What are they?
Pay per hour and pay per month
ACUs and CPUs
DTUs and vCore
Standard and Premium - ✔ ✔ DTUs and vCore SQL Database supports both DTU-based and vCore-based pricing models. DTU stands for Database Transaction Unit and is a relative measure of performance. The vCore model lets you select CPU and storage separately from each other. Which Power BI tool helps build paginated reports?
Power BI Server
Power BI Desktop
Power BI Report Builder
Power BI Apps - ✔ ✔ Power BI Report Builder Power BI Report Builder is the tool that allows you to build paginated reports. Which of the following are examples of unstructured data?
Log files
CSV files
SQL Server tables
An external Oracle DB
Blob storage - ✔ ✔ Log files
SQL DW are databases that are specifically designed for reporting. In fact, it does not support updates to data rows once written to the DB. It supports massive amounts of data. The DW has the ability to scale to multiple servers if a complex query is run against it needing a lot of computing power. Which famous company invented the database known as "Cassandra"?
Amazon
Microsoft - ✔ ✔ Facebook Descriptive Analytics tells you
True/False - ✔ ✔ False Normalising a database reduces data redundancy True/False - ✔ ✔ True Normalisation improves data integrity True/False - ✔ ✔ True An ETL process requires:
Why did sales increase last month?
Predictive analytics help answer questions about what will happen in the future Match the types of analytics that can be used to answer the business questions.
Which people are mentioned in a company's business documents?
Cognitive analytics attempt to draw inferences from existing data and patterns... Transcribing audio files is an example of:
"customer": { "first name" : "Ben", "last name" : "Smith", "address": { "line 1" : "161 Azure Ln", "line 2" : "Palo Alto", "ZIP code" : "54762" },
"social media": [ { "service" : "twitter", "handle" : "@bensmith", }, {
You have the following JSON document. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
"customer": { "first name" : "Ben", "last name" : "Smith", "address": { "line 1" : "161 Azure Ln", "line 2" : "Palo Alto", "ZIP code" : "54762" },
"social media": [ { "service" : "twitter", "handle" : "@bensmith", }, { "service" : "linkedin",
"handle" : "bensmith", } ],
"phone numbers": [ { "type" : "mobile", "number" : "555-555-555", } ] }
Address is:
"phone numbers": [ { "type" : "mobile", "number" : "555-555-555", } ] }
Social Media is:
Customer -> Sales Key: CustomerID Foreign Keys: None
Product -> Sales Key: ProductID Foreign Keys: None
SalesPerson -> Sales Key: SalesPersonID Foreign Keys: None
Warehouse -> Sales Key: WarehouseID Foreign Keys: None
Sales: Key: SalesID Foreign Keys: CustomerID, ProductID, SalesPersonID, WarheouseID
The data model is
Key: SalesID Foreign Keys: CustomerID, ProductID, SalesPersonID, WarheouseID
Customer is ......table
...is an object associated with a table that sorts and stores the data rows in the table based on their key values - ✔ ✔ 1. A clustered index A relational database must be used when....
Product3. 176
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
A. INSERT B. MERGE C. UPDATE D. CREATE - ✔ ✔ C. UPDATE Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
A. Azure HDInsight B. Azure SQL Database C. Azure Cosmos DB D. SQL Server on Azure virtual machines - ✔ ✔ B. Azure SQL Database You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.What should you use?
A. Microsoft SQL Server Management Studio (SSMS) B. Azure Data Studio C. Azure CLI D. Azure PowerShell - ✔ ✔ B. Azure Data Studio A database object that holds data