[02/Connecticut/02]
18 Questions
1 Views

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 type of access does Flow.BI require to connect to data sources?

  • Both direct and indirect access (correct)
  • Indirect access only
  • Direct access only
  • No access required

    • Which of the following is NOT a supported query engine by Flow.BI?

  • Impala (correct)
  • Presto
  • Athena
  • Trino

    • What is the purpose of separate metadata connections in Flow.BI?

  • To connect to data sources
  • To store metadata repository
  • To enable data lake access
  • To establish data governance (correct)

    • Flow.BI requires direct access to data sources.

    <p>True</p> Signup and view all the answers

    Flow.BI supports data lake as an indirect access to data sources.

    <p>True</p> Signup and view all the answers

    Flow.BI allows separate metadata connections for data governance and metadata repository.

    <p>True</p> Signup and view all the answers

    Match the following JDBC drivers with their associated query engines in Flow.BI:

    <p>Athena, Presto, Trino, Impala, Polybase, Drill = Requires JDBC driver BigQuery, Snowflake, Synapse, Redshift Spectrum = External table Python, JavaScript, SQL, CSS = Not applicable</p> Signup and view all the answers

    Match the following data sources with their type of access in Flow.BI:

    <p>Direct access to the source = Flow.BI requirement Indirect access via data lake = Supported by Flow.BI Separate metadata connections = Data governance, metadata repository Python, JavaScript, SQL, CSS = Not applicable</p> Signup and view all the answers

    Match the following data lake systems with their associated query engines in Flow.BI:

    <p>Athena, Presto, Trino, Impala, Polybase, Drill = Query engine BigQuery, Snowflake, Synapse, Redshift Spectrum = Not applicable Relational, distributed file systems (S3, HDFS, Azure Data Lake) = Flow.BI requirement Python, JavaScript, SQL, CSS = Not applicable</p> Signup and view all the answers

    Match the following data access methods with their descriptions in the context of Flow.BI:

    <p>Direct access = Flow.BI needs direct access to the actual data source or a replica of it Indirect access = This might be achieved using AWS Data Migration Service (DMS) or a similar CDC tool Daily batches = A method that can be used to provide data to Flow.BI Data lake = A properly setup data lake can be used as a method of access for Flow.BI</p> Signup and view all the answers

    Match the following tools with their potential usage in Flow.BI for data access:

    <p>AWS Data Migration Service (DMS) = A tool that can be used to provide indirect access to data in Flow.BI CDC tool = A similar tool to AWS DMS that can provide indirect access to data in Flow.BI Data lake = A properly setup data lake can be used to provide indirect access to data in Flow.BI Daily batches = A method that can be used to provide direct access to data in Flow.BI</p> Signup and view all the answers

    Match the following terms with their definitions in the context of Flow.BI:

    <p>Data source = The actual source of data that Flow.BI requires direct access to Replica = A copy of the actual data source that can be used for direct access in Flow.BI Daily batches = A method of providing data to Flow.BI which requires proper setup Data lake = A method of providing data to Flow.BI which requires proper setup</p> Signup and view all the answers

    Which of the following is a possible way to provide direct access to data for Flow.BI?

    <p>Using AWS Data Migration Service (DMS)</p> Signup and view all the answers

    What is another option, besides a replica of the data source, that can provide direct access to data for Flow.BI?

    <p>Using AWS Data Migration Service (DMS)</p> Signup and view all the answers

    Which of the following can be used as a data source for Flow.BI?

    <p>A properly setup data lake</p> Signup and view all the answers

    Flow.BI requires direct access to the actual data source or a replica of it

    <p>True</p> Signup and view all the answers

    Flow.BI supports data lake as a possible way to provide direct access to data

    <p>True</p> Signup and view all the answers

    Flow.BI can only connect to data sources through daily batches or a properly setup data lake

    <p>False</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser