Download DP-900 Exam Preparation: Past Questions and Answers and more Exams Computer Science in PDF only on Docsity!
DP-900 With 252 Past Questions
Correctly Solved
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"?
Google
Amazon
Facebook
Microsoft - ✔ ✔ Facebook Descriptive Analytics tells you
- What is most likely to occur in the future
- What occured in the past
- Which actions you can perform to affect outcomes
- Why something happened in the past - ✔ ✔ 2. What occured in the past Normalisation involves eliminating relationships between database tables
True/False - ✔ ✔ False Normalising a database reduces data redundancy True/False - ✔ ✔ True Normalisation improves data integrity True/False - ✔ ✔ True An ETL process requires:
- A matching schema in the data source and the data target
- A target data store powerful enough to transform data
- data that is fully processed before being loaded to the target data store
- that the data target be a relational database - ✔ ✔ 4. that the data target be a relational database In batch processing:
- data is always inserted one row at a time
- data is processed in real-time
- latency is expected
- processing car only execute serially - ✔ ✔ 3. latency is expected Match the types of analytics that can be used to answer the business questions.
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
- Diagnostic
- Descriptive
- Predictive
- Prescriptive - ✔ ✔ 1. Cognitive
Cognitive analytics attempt to draw inferences from existing data and patterns... Transcribing audio files is an example of:
- Cognitive
- Diagnostic
- Descriptive
- Predictive
- Prescriptive - ✔ ✔ 1. Cognitive 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", }, {
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:
- a nested array
- a nested object
- a root object - ✔ ✔ 2. a nested object 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.
],
"phone numbers": [ { "type" : "mobile", "number" : "555-555-555", } ] }
Social Media is:
- a nested array
- a nested object
- a root object - ✔ ✔ 1. a nested array You are reviewing the data model shown in the following exhibit:
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
- transactional model
- star schema
Key: SalesID Foreign Keys: CustomerID, ProductID, SalesPersonID, WarheouseID
Customer is ......table
- fact
- dimension
- bridge - ✔ ✔ 2. dimension The massively parallel processing (MPP) engine of Azure Synapse Analytics:
- distributes processing across compute notes
- distributes processing across control nodes
- redirects client connections across compute notes
- redirects client connections across control nodes - ✔ ✔ 1. distributes processing across compute notes
- A clustered index
- A Filetable
- A Foreign Key
- A stored procedure
...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....
- a dynamic schema is required
- data will be stored as key/value pairs
- storing large images and videos
- strong consistency guarantees are required - ✔ ✔ 4. strong consistency guarantees are required Relational data uses ......to enforce relationships between different tables
- collections
- columns
- keys
- partitions - ✔ ✔ 3. keys .....is a virtual table that contains content defined by a query
- A heap
- A stored procedure
- A view
- An index - ✔ ✔ 3. A view
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
- Index
- View
- Table - ✔ ✔ 3. Table A database object whose content is defined by a query
- Index
- View
- Table - ✔ ✔ 2. View A database object that helps improve the speed of data retrieval
- Index
- View
- Table - ✔ ✔ 1. Index Which command-line tool can you use to query Azure SQL databases?
