DP 900 Questions and Answers 2022
Descriptive Analytics tells you
what occurred in the past
Normalisation involves eliminating relationships between
... [Show More] database tables
NO
Normalising a database reduces data redundancy
YES
Normalisation improves data integrity
YES
An extract, transform and load (ETL) process requires
that the data target be a relational database
In batch processing
latency is expected
Diagnostic
Why did sales increase last month?
Predictive
How do I allocate my budget to buy different inventory items?
Cognitive
Which people are mentioned in a company's business documents?
Transcribing audio files is an examples of
cognitive analytics
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line 1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
customer is
a root object
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line 1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
address is
a nested object
You have the following JSON document: 'customer': { 'first name': 'ben', 'address': {'line 1': '161 Azure Ln', } } . 'social' : [ { 'service: twitter'., 'handle': @bensmitg'}
social media is
a nested array
Customer > sales Sales < warehouse
The data model is a
Star schema
Customer > sales Sales < warehouse
Customer is a
Dimension
The massively parallel processing (MPP) engine of Azure Synapse Analytics
distributes processing across compute nodes
A clustered index
is an object associated with a table that sorts and stores the data rows in the table based on their key values
A relational database must be used when
strong consistency guarantees are required
Relation data uses ________ to enforce relationships between different tables
keys
A view
is a virtual table that contains content defined by a query
You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet?
- You must have select access to the product table
- You must have a user in the database
- Your IP address must be allowed to connect to the database
Which statement should you use in SQL query to change the inventory quantity of Product1 to 270? [Show Less]