VCE Microsoft 70-496 Exam Dumps - web services developing

Microsoft 70-496 Exam Questions:

Which of the following statements are true with respect to designing a Power BI Desktop project in DirectQuery mode?

•   You cannot add measures to the data model.
•   All queries within the project must be based on a single source database.
•   You cannot convert column data types when editing a query.
•   You cannot add calculated columns to the data model.

Which language(s) can be used when designing a query in Power BI Desktop?

•   M
•   SQL
•   DAX
•   Python

Which of the following is not a valid privacy level for a Power BI data source?

•   Public
•   Organizational
•   Protected
•   Private

Which of the following in not a valid variable type when programming in the M language?

•   List
•   Record
•   Function
•   Dataframe

When designing a query in Power BI Desktop to clean up data, what operation can be used to remove non-printable characters?

•   Scrub
•   Clean
•   Trim
•   Sanitize

When writing the DAX expression for a calculated column, you can assume your DAX code automatically has row context for the table in which the calculated column is defined.

•   False
•   True

Which of the following statements is false?

•   When referencing a measure in a DAX expression, you must include the table name.
•   When referencing a calculated column in a DAX expression, you must include the table name.
•   When referencing a measure in a DAX expression, you can optionally include the table name.
•   When referencing a measure in a DAX expression, you should prefer not include the table name.

Which of the following DAX functions does not return a table?

•   Filter
•   AllExcept
•   Calculate
•   Values

Which of the following statements are true about data modeling in Power BI Desktop project?

•   Within a Power BI Desktop project, all query parameter names must be unique.
•   Within a Power BI Desktop project, all dimensional hierarchy names must be unique.
•   Within a Power BI Desktop project, all measure names must be unique.
•   Within a Power BI Desktop project, all calculated column names must be unique.

When designing a data model with Power BI Desktop, which of the following statements are true regarding the rules for creating table relationships?

•   You can define multiple relationships between two tables in a data model but only one of the       relationships can be marked as active.
•   At least one column defined in a table relationship must contain unique values.
•   A relationship between two tables can be defined using multiple fields from each table.
•   A relationship between two tables must be defined using a single field from each table.

Which of the following Data Category settings can be used for mapping data to geographic locations in Power BI?

•   Latitude and Longitude (e.g. 47.6080, -122.3351)
•   An address (e.g. 1 Microsoft Way, Redmond, WA 98052)
•   A city (e.g. London)
•   A place (e.g. Logan International Airport)

When writing the DAX expression for a measure, you can assume your DAX code automatically has row context for the table in which the measure is defined

•   False
•   True

Into which of the following scopes can you import a custom visual created for Power BI?

•   Into the scope of a Power BI Desktop project
•   Into the scope of your personal workspace
•   Into the scope of an app workspace
•   Into the scope of a premium capacity

Which of the following field types can be added to the Field well of a Slicer visual?

•   Calculated columns created with a DAX expression
•   Native columns returned by a query
•   Groups created inside a table using the "New Group" Command in Power BI Desktop
•   Measures created by a DAX expression

Which of the following are advantages associated with moving an App Workspace into a premium capacity creating using a Power BI Premium P1 subscription?

•   Users who have the Power BI Free license can enter the App Workspace for read-only access    to its content
•   The App published from the App Workspace can be installed and consumed by users who          have the Power BI Free license
•   Reports and dashboards from the App Workspace can be embedded in custom applications        and served to non-licensed users
•   Dashboards within the App Workspace can be shared with users who have the Power BI Free    license

Which of the following Power BI subscriptions provides the proper licensing for users to view Power BI content through the Power BI mobile apps?

•   Power BI Premium P1 (capacity license)
•   Power BI Free (user license)
•   Power BI Pro (user license)
•   Power BI Premium EM3 (capacity license)

Which of the following versions of the Windows operating system support installing Power BI Desktop?

•   Windows 7
•   Windows 8.1
•   Windows Vista
•   Windows 10