Microsoft Fabric Configuration and Optimization Solutions
Fabric Tenant and Workspace Management
Scenario: You have a Fabric tenant that contains a workspace.
- User Capabilities: User1 can connect to DW1 via the Azure SQL Analytics endpoint.
- XMLA Read-Write Access: To ensure read-write access to DS1 via the XMLA endpoint, you must first modify the C1 settings.
- Fabric Admin Portal Recommendations:
- From the Tenant settings, set Allow XMLA to Enabled.
- From the Capacity settings, set XMLA to Read Write.
- From the Tenant settings, ensure the relevant feature is set
Mastering SQL Queries and Core Database Concepts
Fundamental SQL Retrieval Examples
Basic Selection and Filtering
List full details of all hotels
SELECT * FROM Hotel;List full details of all hotels in London
SELECT * FROM Hotel WHERE city = 'London';List names and addresses of all guests in London
Alphabetically ordered by name. Strictly speaking, using
LIKE '%London%'might also find rows with an address like: ’10 London Avenue, New York’.SELECT guestName, guestAddress FROM Guest WHERE address LIKE '%London%' ORDER BY guestName;List double or family
Essential Definitions of Mechanical and Pneumatic Components
Four-Stroke Engine Operation
The four-stroke engine operates through four distinct stages:
- Intake: Air enters the cylinder, mixing with atomized fuel.
- Compression: The air and fuel mixture is compressed by the upward movement of the piston.
- Power (Combustion): The burning fuel forces the piston downward with great force, producing useful work.
- Exhaust: The upward movement of the piston cleans the cylinder by expelling spent gases.
Two-Stroke Engine Mechanics
Two-stroke engines are piston engines where
Read MoreUnderstanding Glass and Plastic Packaging Materials
Advantages:
- Lightweight
- Good oxidation and sulfidation resistance
- Sensory stability of the product
- Recyclable
Disadvantages:
- Low resistance to acidic foods
- Requires varnishing
- Sterilization containers controlled
- Difficulty with side seam welding (two pieces preferred over three)
Applications:
- Beer
- Carbonated beverages
- Easy open lids
- Fish
- Marine delicacies
Glass Containers: Glass is a supercooled liquid, non-crystalline, with a variable chemical composition and very high viscosity, resulting from the merger of organic
Read MoreDiode and Transistor Circuit Analysis and Functionality
Circuit Analysis Exercises
16. Identify the components in the diagram that allow current flow and emit light when connected.
17. Modify the following circuit so that when the switch is in position 1, the motor turns in one direction and a red LED lights up, and when the switch is in position 2, the motor turns in the opposite direction and a green LED lights up. Components provided: power source, motor, switch, red LED, green LED, and two 1000Ω resistors.
18. Observe the diagram and fill in the following
Read MoreEngineering, Construction, and Logistics Vocabulary
Technical Terminology and Definitions
Design, Drawing, and Measurement
- Design
- The collective word for all the information that is given in order to produce or build something.
- Drawing
- A type of picture that has been drawn in order to present design information.
- Scale
- The ratio between the size of items shown on a drawing and their actual size (in reality).
- Full-Scale Drawing
- The dimensions of the drawing are the same as their real size.
- Small-Scale Drawing
- Often referred to as a general arrangement drawing.
