DP 900 - pt 15

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

• bridge

• dimension

• fact

In a fully denormalized database, how is data read and written for a single entity?

• Data is read from a single table and written to a single table.

• Data is read from multiple tables and written to a single table.

• Data is read from a single table and written to multiple tables.

• Data is read from multiple tables and written to multiple tables.

The pipeline engine used in Azure data factory is available in ​ (a)  

• azure synapse analytics
• azure sql database
• azure HDInsight
• azure databricks

in an analytical model, any point where the dimension intersects represent​ (a)  

• cube
• aggregate measure
• aggregate dimension

In Microsoft Power Bi, you can create ​ (a)   to quickly drill up or drill down to find aggregated values at different levels of dimension

• attribute hierarchy
• dashboard
• fact table
• unique key