Quiz-summary
0 of 10 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
Information
Practice Questions
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Answered
- Review
-
Question 1 of 10
1. Question
You are tasked with creating monthly partitions and mapping them to a single filegroup labelled “MONTHLY” for the sales column in the International Importers database. The boundary values must be set using the first day of each month to avoid adding the leap day complexity. From the following options, choose the appropriate partition function.
Correct
Range Left partition function uses the last day of each month as the boundary value while the Range Right partition function uses the first day of each month as the boundary value.
Incorrect
Range Left partition function uses the last day of each month as the boundary value while the Range Right partition function uses the first day of each month as the boundary value.
-
Question 2 of 10
2. Question
When a table is partitioned an index may also be created using the same partition schema of the table. Sometimes, however, indexes can also be partitioned independently with a function that does not match the table. Certain guidelines must be followed to do so, from the following list which of these is NOT a guideline for distinct index partitioning?
Correct
In the case of a unique index for both clustered and non clustered the partition column must be added explicitly to the key column list.
Incorrect
In the case of a unique index for both clustered and non clustered the partition column must be added explicitly to the key column list.
-
Question 3 of 10
3. Question
There are multiple methods of partitioning data, for example before table partitioning was introduced, partitioned views was the primary method used. Which of the following options is an incorrect difference between table partitioning and partitioned views?
Correct
Both table partitioning and partitioned views require a partitioning column with a defined check constraint for each table.
Incorrect
Both table partitioning and partitioned views require a partitioning column with a defined check constraint for each table.
-
Question 4 of 10
4. Question
Most companies have data retention policies, to maintain such policies a sliding window partition strategy is used. This allows the same number of partitions to be maintained on a table by removing and adding an equal amount of partitions. However, certain requirements must be maintained for partition switching to work, which of the following is an incorrect requirement?
Correct
The source and target tables must share the same filegroup, however, the source and target tables must NOT be replicated.
Incorrect
The source and target tables must share the same filegroup, however, the source and target tables must NOT be replicated.
-
Question 5 of 10
5. Question
When using a sliding window partition strategy, for the switch function, the partition number should be specified depending on whether the source and target tables are partitioned or not. From the following, which restriction is incorrect?
Correct
If the source is non-partitioned and the target is also non-partitioned, there is no need to specify the partition number.
Incorrect
If the source is non-partitioned and the target is also non-partitioned, there is no need to specify the partition number.
-
Question 6 of 10
6. Question
In order to improve querying and data loading performance, a process called scaling-out data is used. This mechanism spreads the processing of data across as many servers as necessary to improve the performance. However, four factors dictate when the scale-out solution can be implemented. Which of the following is an incorrect factor in determining the implementation of a scale-out solution
Correct
Storage capacity is not one of the factors, the last factor is the interdependence of the data. Based on this factor, data is split depending on how the data is typically related and used.
Incorrect
Storage capacity is not one of the factors, the last factor is the interdependence of the data. Based on this factor, data is split depending on how the data is typically related and used.
-
Question 7 of 10
7. Question
When companies implement a procedure to scale-out data, they can choose from a list of multiple solutions. Some of these solutions include utilizing distributed partitioned views and using middleware service to route queries to the correct database.
Which of the following scale-out solution mechanisms is incorrect?Correct
The six more frequently scale-out solutions used involve; Copying the database to multiple database servers (not to a single server), Utilizing distributed partitioned views, Utilizing a stretch database with Azure, Using middleware service to route queries to the correct database, Utilizing linked servers and executing distributed queries, Granting multiple database engines access to a single copy of the database
Incorrect
The six more frequently scale-out solutions used involve; Copying the database to multiple database servers (not to a single server), Utilizing distributed partitioned views, Utilizing a stretch database with Azure, Using middleware service to route queries to the correct database, Utilizing linked servers and executing distributed queries, Granting multiple database engines access to a single copy of the database
-
Question 8 of 10
8. Question
A frequently implemented solution to scale-out data involves using middleware service to route queries to the correct database. Which of the following options does NOT describe the approach used in routing queries to the correct database via middleware services?
Correct
This scale-out method does require complex management of the data as the database is broken down into separate databases (containing all the information) which are then routed by the middleware. This is why it is also referred to as data dependant routing
Incorrect
This scale-out method does require complex management of the data as the database is broken down into separate databases (containing all the information) which are then routed by the middleware. This is why it is also referred to as data dependant routing
-
Question 9 of 10
9. Question
Another frequently implemented solution to scale-out data involves utilizing distributed partitioned views. Which of the following options does NOT describe the approach used in utilizing distributed partitioned views?
Correct
When utilizing distributed partitioned views, data is partitioned along with tables and then distributed across several databases. The check constraints dictate the table and database the SQL Server should obtain the data from. To filter data being read, distributed partitioned views mainly rely on queries using the partitioning key otherwise, each table from all the databases are read. This method is efficient in data warehouses where historical data is archived.
Incorrect
When utilizing distributed partitioned views, data is partitioned along with tables and then distributed across several databases. The check constraints dictate the table and database the SQL Server should obtain the data from. To filter data being read, distributed partitioned views mainly rely on queries using the partitioning key otherwise, each table from all the databases are read. This method is efficient in data warehouses where historical data is archived.
-
Question 10 of 10
10. Question
A company requires an analysis to compare the number of stock items ordered and stock items received. You are tasked with comparing both these measures and providing the dimensions and attributes for this analysis. Keeping the attributes to a bare minimum, which of the following dimensions/attributes is incorrect? (Dimensions –> Attributes)
Correct
The attributes are kept to a bare minimum, therefore warehouse address is not needed, instead, a Purchase order –> Purchase Order ID, would be a better alternative as it would cover these details.
Incorrect
The attributes are kept to a bare minimum, therefore warehouse address is not needed, instead, a Purchase order –> Purchase Order ID, would be a better alternative as it would cover these details.