[04/Vienne/09]

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which of the following is a subset of source metadata integrated into the Flow.BI repository?

  • sys_procedures
  • sys_sqlinfo
  • sys_catalogs (correct)
  • sys_schemas

What type of data could be added to the Flow.BI repository on demand?

  • Data related to sys_tables
  • Metadata related to authorized apps
  • Transactional data
  • Fully historized data (correct)

Which of the following is NOT a part of the subset of source metadata integrated into the Flow.BI repository?

  • sys_indexes
  • sys_connection_props
  • sys_tablecolumns
  • sys_identity (correct)

Flow.BI repository integrates a fully historized subset of source metadata.

<p>False (B)</p> Signup and view all the answers

More data could be added to the Flow.BI repository on demand.

<p>True (A)</p> Signup and view all the answers

The listed items, such as 'sys_tables' and 'sys_schemas', are part of the subset of source metadata integrated into the Flow.BI repository.

<p>True (A)</p> Signup and view all the answers

Match the following data sources with their integrated subset of source metadata in the Flow.BI repository:

<p>Mailchimp = sys_procedures MySQL = sys_connection_props</p> Signup and view all the answers

Match the following items with the type of data they represent in the Flow.BI repository:

<p>sys_tables = Table columns sys_schemas = Database schemas sys_procedureparameters = Procedure parameters sys_keycolumns = Key columns</p> Signup and view all the answers

Match the following data sources with the type of data that could be added to the Flow.BI repository on demand:

<p>Mailchimp = Identity MySQL = Indexes</p> Signup and view all the answers

Which of the following is part of the subset of source metadata integrated into the Flow.BI repository for both Mailchimp and MySQL?

<p>sys_keycolumns (B)</p> Signup and view all the answers

What type of data is available (fully historized) and could be added to the Flow.BI repository on demand?

<p>Transactional data (A)</p> Signup and view all the answers

Which of the following is a part of the subset of source metadata integrated into the Flow.BI repository specifically for Mailchimp?

<p>authorizedapps (A)</p> Signup and view all the answers

Flashcards are hidden until you start studying

More Like This

Data Integration Techniques
58 questions

Data Integration Techniques

WellEstablishedWisdom avatar
WellEstablishedWisdom
[04/Vienne/09]
3 questions

[04/Vienne/09]

InestimableRhodolite avatar
InestimableRhodolite
ETL Process in Data Integration
6 questions

ETL Process in Data Integration

ImaginativeGreatWallOfChina avatar
ImaginativeGreatWallOfChina
Data Integration in Healthcare Systems
24 questions
Use Quizgecko on...
Browser
Browser