DP-900 Exam 2 QUESTIONS with Correct
Verified Solutions
Descriptive analytics tells you:
What occurred in the past
Which of these statements are true:
1. Normalization involves eliminating relationships between database tables.
2. Normalizing a database reduces data redundancy.
3. Normalization improves data integrity.
1. False
2. True
3. True
"An extract, transform, and load (ETL) process requires..."
Which of these statements completes the sentence:
1. a matching schema in the data source and the data target.
,2. a target data store powerful enough to transform data.
3. data that is fully processed before being loaded to the target data store.
4. that the data target be a relational database.
2. a target data store powerful enough to transform data.
"In batch processing..."
Which of these statements completes the sentence:
1. data is always inserted one row at a time.
2. data is processed in real-time.
3. latency is expected.
4. processing can only execute serially.
3. latency is expected.
"Transcribing audio files is an example of _____ analytics."
Which of these statements completes the sentence:
,1. cognitive
2. descriptive
3. predictive
4. prescriptive
1. cognitive
What analytics type correlates with these questions:
1. Why did sales increase last month?
2. How do I allocate my budget to buy different inventory items?
3. Which people are mentioned in a company's business documents?
1. Diagnostic
2. Prescriptive
3. Descriptive
"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"
}
]
}
Verified Solutions
Descriptive analytics tells you:
What occurred in the past
Which of these statements are true:
1. Normalization involves eliminating relationships between database tables.
2. Normalizing a database reduces data redundancy.
3. Normalization improves data integrity.
1. False
2. True
3. True
"An extract, transform, and load (ETL) process requires..."
Which of these statements completes the sentence:
1. a matching schema in the data source and the data target.
,2. a target data store powerful enough to transform data.
3. data that is fully processed before being loaded to the target data store.
4. that the data target be a relational database.
2. a target data store powerful enough to transform data.
"In batch processing..."
Which of these statements completes the sentence:
1. data is always inserted one row at a time.
2. data is processed in real-time.
3. latency is expected.
4. processing can only execute serially.
3. latency is expected.
"Transcribing audio files is an example of _____ analytics."
Which of these statements completes the sentence:
,1. cognitive
2. descriptive
3. predictive
4. prescriptive
1. cognitive
What analytics type correlates with these questions:
1. Why did sales increase last month?
2. How do I allocate my budget to buy different inventory items?
3. Which people are mentioned in a company's business documents?
1. Diagnostic
2. Prescriptive
3. Descriptive
"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"
}
]
}
