DA100 Exam 0.0 / 5 ? AccountingPrepOtherOther Created by: Mamz101Created on: 15-01-22 22:18 What does Column Quality show? Brief Overview of Valid, Error and Empty Values 1 of 28 What does Column Distribution show? Distinct and Unique Values 2 of 28 Unique Values are? Values that appear only once 3 of 28 Distinct values are? Total count of values 4 of 28 What does Column Profile show? Values and Statistics of a table, based on first 1,000 rows of dat 5 of 28 Where can you edit M Code? Power Query - Advanced Editor 6 of 28 What forms the basis of M Code? let & in 7 of 28 What is the risk of null values in numeric columns Average wont' be calculated correctly 8 of 28 What does Append do? It combines rows that share similar column headers 9 of 28 What does merge do? It combines columns between two tables that have a column in common 10 of 28 What are examples of flat files? CSV and txt 11 of 28 What are examples of output files? xlxs (Excel files) 12 of 28 What's an advantage of getting data through online sources like Sharepoint and One Drive? Data is updated in real time 13 of 28 What can break a reporting model Broken file path or reconnecting to a file without the same file structure e.g. deleted or renamed columns 14 of 28 How can you change a file path? Home - Data Source Settings - Change Source 15 of 28 What are the 3 connectivity modes when connecting to a SQL Server? Import, Direct Query, Dual 16 of 28 What is the difference between SQL and NoSQL? NoSQL database does not use tables to store data 17 of 28 What are the steps to import a JSON file? Get Data - Click on Records - Edit in PQ - Select the fields you want to load 18 of 28 What is the difference between Import and Direct Query as Storage modes? Direct Query queries data directly in data source. Importing creates a cached local copy 19 of 28 When should you use DirectQuery? If you can't import a copy of data or the dataset is too large and will take too long to load 20 of 28 How can you fix performance issues for reports in BI Desktop Performance Analyser 21 of 28 What is Query folding? Transformations and edits in PQ are tracked as native Queries that work like SQL Select Statements 22 of 28 What are the benefits of Query Folding? 1. More efficient data and incremental refresh 2. Optimises performance 3. Automatic compatibility with DirectQuery and Data Storage Modes 23 of 28 Where can you find Query Diagnostics? File - Tools - Diagnose Step 24 of 28 3 Ways to Optimise Query Performance in BI? 1. Process data/ perform calculations in original source 2. Use native SQL queries 3. Separate date and time 25 of 28 What are examples of data import errors? 1. Timeout expired 2. Couldn't find data formatted as a table 3. Could not find file 26 of 28 What type of expression do you use to extract data from Microsoft SQL Server? T-SQL 27 of 28 What is the impact of disabling load for a query in PQ? Doesn't get loaded as a table to the data model 28 of 28
Comments
No comments have yet been made