skill lync module 6 session 9 Snowflake and Power BI

Question 1

What is a foreign key?

Accepted Answer

External reference

Question 2

Which command restores data?

Accepted Answer

RESTORE DATA

Question 3

What is a Snowflake schema?

Accepted Answer

Hierarchical model

Question 4

Which command changes a schema?

Accepted Answer

ALTER SCHEMA

Question 5

How do you rename a table?

Accepted Answer

ALTER TABLE

Question 6

Which Python library is used for Snowflake?

Accepted Answer

Snowflake Connector

Question 7

What does SQL stand for?

Accepted Answer

Structured Query Language

Question 8

Which command lists databases?

Accepted Answer

SHOW DATABASES

Question 9

What is the benefit of using Python scripts in Power BI?

Accepted Answer

Enhanced analytics

Question 10

Which command grants access?

Accepted Answer

GRANT ACCESS

Question 11

What does DAX stand for in Power BI?

Accepted Answer

Data Analysis Expressions

Question 12

How does Snowflake handle data storage?

Accepted Answer

Columnar storage

Question 13

True or false: Power BI can connect to Snowflake.

Accepted Answer

True

Question 14

What is the main purpose of Power BI?

Accepted Answer

Data analysis and visualization

Question 15

Which command creates a database?

Accepted Answer

CREATE DATABASE

Question 16

How do you add a column?

Accepted Answer

ADD COLUMN

Question 17

Which Python library is popular for data analysis?

Accepted Answer

Pandas

Question 18

What is a common use of Python in Power BI?

Accepted Answer

Data visualization

Question 19

What is the purpose of a Snowflake warehouse?

Accepted Answer

Data processing

Question 20

True or false: SQL is case-sensitive

Accepted Answer

False

Question 21

What is the main advantage of using Snowflake?

Accepted Answer

Scalability

Question 22

Which SQL command retrieves data?

Accepted Answer

SELECT

Question 23

What is a Snowflake schema?

Accepted Answer

A type of database design

Question 24

How can Python enhance Power BI reports?

Accepted Answer

By creating visuals

Question 25

What is Power BI primarily used for?

Accepted Answer

Data visualization

Question 26

What is a composite key?

Accepted Answer

Multiple columns

Question 27

Which SQL function counts records?

Accepted Answer

COUNT()

Question 28

Which SQL clause filters records?

Accepted Answer

WHERE

Question 29

What is the purpose of a Snowflake stage?

Accepted Answer

Data storage

Question 30

Which command deletes a table?

Accepted Answer

DROP TABLE

Question 31

Which visualization type is best for trends in Power BI?

Accepted Answer

Line chart

Question 32

Which command updates data?

Accepted Answer

UPDATE DATA

Question 33

How do you sort data?

Accepted Answer

ORDER BY

Question 34

What is a view in SQL?

Accepted Answer

Virtual table

Question 35

What is the main advantage of Snowflake's architecture?

Accepted Answer

Separation of compute and storage

Question 36

What does Python help automate in Power BI?

Accepted Answer

Data cleaning

Question 37

Which is a feature of Snowflake?

Accepted Answer

Cloud-based data warehousing

Question 38

What does DAX stand for in Power BI?

Accepted Answer

Data Analysis Expressions

Question 39

What is Power BI primarily used for?

Accepted Answer

Data analysis

Question 40

What is a primary key?

Accepted Answer

Unique identifier

Question 41

What is a key feature of Power BI?

Accepted Answer

Real-time data updates

Question 42

What is a key benefit of using Snowflake?

Accepted Answer

Scalability

Question 43

Which SQL command retrieves data from Snowflake?

Accepted Answer

SELECT

Question 44

How do you define a table?

Accepted Answer

CREATE TABLE

Question 45

Which is a common data source for Power BI?

Accepted Answer

Excel files

Question 46

What is the role of a Power BI dataset?

Accepted Answer

Data analysis

Question 47

Which is a data visualization type in Power BI?

Accepted Answer

Bar chart

Question 48

Which command creates a schema?

Accepted Answer

CREATE SCHEMA

Question 49

Which is a common data format for Power BI?

Accepted Answer

CSV

Question 50

What is the purpose of ETL in data integration?

Accepted Answer

Extract, Transform, Load

Question 51

Which command is used to create a table in Snowflake?

Accepted Answer

CREATE TABLE

Question 52

Which SQL clause filters results in Snowflake?

Accepted Answer

WHERE

Question 53

Which tool can visualize data from Snowflake?

Accepted Answer

Power BI

Question 54

How does Power BI handle large datasets?

Accepted Answer

Data compression

Question 55

What does 'VARCHAR' mean?

Accepted Answer

Variable character

Question 56

Which feature allows Power BI to refresh data?

Accepted Answer

Scheduled refresh

Question 57

Which function is used to load data in Power BI?

Accepted Answer

Get Data

Question 58

What is the role of a data model in Power BI?

Accepted Answer

Organize data relationships

Question 59

How do you remove a column?

Accepted Answer

DROP COLUMN

Question 60

How do you backup a database?

Accepted Answer

BACKUP DATABASE

Question 61

What is the main function of Power Query in Power BI?

Accepted Answer

Data transformation

Question 62

How can you visualize Snowflake data in Power BI?

Accepted Answer

Using charts

Question 63

What is the main benefit of integrating Python with Power BI?

Accepted Answer

Advanced analytics

Question 64

Which language is used for data analysis?

Accepted Answer

Python

skill lync module 6 session 9 Snowflake and Power BI

Questions 67

skill lync module 6 session 9 Snowflake and Power BI

Questions 67