Database Questions With Answers

From Database

From Data Service

From Other Sources

Existing Connections

None of the Above

QUESTION 12

Using the file ImportText.txt, what is the sum of the TransCost column?

$537,230

QUESTION 13

Which of the following types of charts are not available in Power View? 2.Line

Radar

Scatter

Pie

Column

QUESTION 14

Which tab of the Power View interface is used to create column charts?

2.Insert

Formulas

View

Design

Canvas

QUESTION 15

Before you can use Power View in Excel 2016, which of the following option tabs do you need to visit?

2.Advanced

Add-Ins

Trust Center

Formulas

Customize

Ribbon

QUESTION 16

The Refresh button will execute all table queries, discard the existing data, and import all the tables from scratch.

True

False

QUESTION 17

Power BI mobile is a cloud-based business analytics service that allows the user to host and share their own data, reports, and dashboards online

True

False

QUESTION 18

Which of the following actions cannot be performed in the Data Source Settings window?

Managing Security Credentials

Deleting Data Sources

Changing Server/Database names

Change Data Source

QUESTION 19

When working with data in the Query Editor, the underlying data is edited to reflect the steps recorded in the Applied Steps section.

True

False

QUESTION 20

The merge and append queries options are located in which of the Query Ribbon tabs?

Home

Transform

Add Column

View

QUESTION 21

Given the Query Data Type, which of the following is incorrectly matched with the corresponding Storage Data Type?

Text : String

TRUE/FALSE : Boolean

Date : Date

Duration : Time

QUESTION 22

If the user wishes to change more than one column data type at once, the SHIFT key can be used to select non-adjacent columns.

True

False

QUESTION 23

Appending is used when there are additional rows of data that need to be added to an existing query.

True

False

QUESTION 24

Which of the following actions CANNOT be performed by right-clicking on an Applied Step?

Rename

Delete Until End

Move Up

Replace

QUESTION 25

Measures are calculated at run time.

True

False

QUESTION 26

An implicit measure is used when an aggregation behavior is needed that goes beyond a standard aggregation function created by Microsoft.

True

False

QUESTION 27

Which of the following actions cannot be performed in the Data Source Settings window?

Managing Security Credentials

Deleting Data Sources

Changing Server/Database names

Change Data Source

QUESTION 28

DAX does not allow the usage of aggregate functions on entire tables.

True

False

QUESTION 29

DAX can take the place of using a VLOOKUP by referncing a named table/column.

True

False

QUESTION 30

What operator would you use if you wanted to create an [OR] statement using DAX?

2.&&

||

<=

>=

QUESTION 31

The Create Relationships and Edit Relationships windows are the same, except the Create Relationships window has all the fields pre-populated.

True

False

QUESTION 32

In order for Power BI to detect relationships between two columns, the columns must have matching data type

True

False

QUESTION 33

Which of the following is a supported operation for the Relationship object?

Hide

Rename

Maximize

Delete

QUESTION 34

Many-to-One cardinality specifies that there is a single record in one table for many records that map in the table that is joined.

True

False

QUESTION 35

Which is an example of a Parent-Child relationship?

"A list of transactions, each of which takes place at a specific time and place"

"A company with multiple offices, which in turn have multiple branches"

"A list of raw materials, each of which are used to assemble various goods"

"A list of services, each of which are available from various companies"

QUESTION 36

Which of the following are most likely to require a many to many relationship?

A list of parents and a list of their children

A list of dates and a list of historical events

A list of cities and a list of GPS coordinates

A list of companies and a list of brands they produce

QUESTION 37

Edits can be made in Reading View.

True

False

QUESTION 38

When using tiles, which view will allow you to change tile settings?

In Focus Mode

Tile Details

Delete Tile Pin Visual

QUESTION 39

Which of the following actions CANNOT be performed by right-clicking on an Applied Step? 2.Line Graph

Treemap

Shape Chart

Matrix Visualization

QUESTION 40

How many Primary Keys can a table contain?

Only 1

2

3

More than 3

QUESTION 41

The uses of SQL include modifying database table and index structures; adding; updating and deleting rows of data, and retrieving subsets of information from within a database for transaction processing and analytics application.

True

False

QUESTION 42

A_____is also called a record in a table.

Query output

Row

Column

All the above

QUESTION 43

What can you do in the users interface of Visual studio 2017?

Create and save a project

Run code

Manage projects

All the above

QUESTION 44

Developers can access the source code editor, debugger, interpreter and compiler through the GUI.

True

False

QUESTION 45

Which of the following paths allow us to choose Microsoft SQL Server from the data sources list?

View → Server Explorer → Connect to Server

View → Server Explorer → Connect to Database

View → Server Explorer → Add SQL Server

View → Server Explorer → Choose SQL

QUESTION 46

Whenever you run multiple queries:

You get the only last query results

Each query must end with a semicolon

You get an error, because it s not possible to run more than one query

Each query must end with a colon

QUESTION 47

Which of the following is incorrect?

A SELECT clause specifies the columns to be displayed

A FROM clause specifies the table containing the column(s) listed in the SELECT clause

A WHERE clause is used to extract only those records that fulfill a specified condition

None of the above

QUESTION 48

Which of the following statements might delete all records of customers whose first name is Jack from a table named Customer ?

DELETE FROM Customer WHERE firstname = 'Jack' ;

DELETE Jack FROM Customer;

DELETE FROM Jack of Customer;

DELETE Customer WHERE first name = 'Jack' ;

QUESTION 49

Which SQL keyword is used to sort the result-set?

ORDER

ORDER BY

SORT BY

SORT

QUESTION 50

The table Customer has four records listed below, which statement should we use to select the customer whose age is greater than thirty where country is either USA or Canada?

Customer ID CustomerName Age Country

001 Jack 23 USA

002 Mia 33 Canada

003 Amy 13 Japan

004 Jane 35 USA

SELECT * FROM Customer WHERE Age > 30 AND (Country = USA AND Canada );

SELECT * FROM Customer WHERE Age > 30 AND (Country = USA OR Country = Canada );

SELECT * FROM Customer WHERE Age > 30 OR (Country = USA AND Canada) ;

SELECT * FROM Customer WHERE Age < 30 OR (Country = USA OR Canada );

QUESTION 51

With SQL, how do you select all the records from a table named "Customers" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Customers WHERE FirstName='%a%';

SELECT * FROM Customers WHERE FirstName='a';

SELECT * FROM Customers WHERE FirstName LIKE 'a%';

SELECT * FROM Customers WHERE FirstName LIKE '%a';

QUESTION 52

The general syntax of a SQL join is "SELECT column_name FROM table_name1 JOIN table_name2 ON column_1 = column_2 WHERE condition";

True

False

QUESTION 53

How many different types of the JOINs are there in SQL?

2.1

2

3

4

QUESTION 54

There are two tables below:

How many rows should be in the outcome by using the SQL statement below:

SELECT a.Customer_ID, a.Name, b.Age

FROM Customer_name a FULL JOIN Customer_age b

ON a.Customer_ID= b.Customer_ID;

1

3

3

0

QUESTION 55

DDL is a category of SQL statements, which is used to create, delete or modify a database or table structure.

True

False

QUESTION 56

TRUNCATE TABLE statement is used to remove an existing table definition and all data for that table.

True

False

QUESTION 57

Which one is the correct command for deleting a table?

DROP TABLE

DELETE TABLE

REMOVE TABLE

DESTROY TABLE