Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Location Chicago IL, USA

Microsoft 70-466 Exam Actual Questions

The questions for 70-466 were last updated at Oct. 8, 2021.
  • Viewing page 1 out of 48 pages.
  • Viewing questions 1-4 out of 196 questions

Topic 1 - Single Topic

Question #1 Topic 1

You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the row is added to the table.
What should you use? More than one answer choice may achieve the goal. Select the BEST answer.

  • A. A FOREIGN KEY constraint
  • B. A data manipulation language (DML) trigger
  • C. A DEFAULT constraint
  • D. A CHECK constraint
  • E. A Data Definition Language (DDL) trigger
Reveal Solution Hide Solution   Discussion  

Correct Answer: B
DML triggers is a special type of stored procedure that automatically takes effect when a data manipulation language (DML) event takes place that affects the table or view defined in the trigger. DML events include INSERT, UPDATE, or DELETE statements. DML triggers can be used to enforce business rules and data integrity, query other tables, and include complex Transact-SQL statements.
Incorrect Answers:
D: CHECK constraints enforce domain integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical (Boolean) expression that returns TRUE or FALSE based on the logical operators.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/triggers/dml-triggers

Question #2 Topic 1

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column.
The Sales table must meet the following requirements:
✑ Queries must be able to return all rows.
✑ Must be able to support four different processing schedules for different date ranges.
✑ Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?

  • A. Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.
  • B. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
  • C. Create four partitions for the Sales table. Use row filter queries for each partition.
  • D. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.
Reveal Solution Hide Solution   Discussion  

Correct Answer: C

Question #3 Topic 1

You are administrating a SQL Server Analysis Services (SSAS) tabular database.
You need to create a new role that allows its members to query data and to refresh data in the model.
Which permission should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

  • A. Browse and Manage
  • B. Administrator
  • C. Read and Process
  • D. Explore and Manage
Reveal Solution Hide Solution   Discussion  

Correct Answer: C
* Giving a database role permission to process an Analysis Services database means that the role has permission to perform all processing options on the database. This includes the processing of all cubes, dimensions, mining structures, and mining models in the database. However, the role does not have permission to read database metadata or access any data in the database itself.

Question #4 Topic 1

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the
Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

  • A. City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])
  • B. City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey])
  • C. =RELATED(Geography[City])
  • D. =RELATED(Geography.City)
  • E. =VALUES(Geography[City])
  • F. City:=VALUES(Geography[City])
Reveal Solution Hide Solution   Discussion  

Correct Answer: C
* RELATED Function
Returns a related value from another table.


SaveCancel